Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sqlfresher2k7
Aged Yak Warrior
623 Posts |
 Posted - 2007-08-28 : 14:31:08
|
| I need scripts to create a new login also the login should have dbo owner role!!thanks for yr help in advance!! |
|
|
sqlfresher2k7
Aged Yak Warrior
623 Posts |
Posted - 2007-08-28 : 15:57:09
|
| I have used to create the below scripts to create login & grantaccessEXEC sp_addlogin 'test', 'testpwd', 'testdb'EXEC sp_grantdbaccess 'test', 'testdb'But should i make the login as dbo privilegdes.. |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-28 : 21:51:16
|
| Use sp_adduser. |
|
|
|
|
|
|
Scripts for sqlserver 2000