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 |
|
nitin1353
Constraint Violating Yak Guru
381 Posts |
 Posted - 2006-10-06 : 06:03:28
|
| Gurushow do we make a user dbo after these commandsexec sp_addlogin 'test','test','dbname'exec sp_adduser 'test','test'RegardsNitin |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-10-06 : 06:07:56
|
| EXEC sp_addrolemember 'db_owner', 'UserName'From memory! if I'm slightly off you'll probably now find it in BoLKristen |
 |
|
|
|
|
|
making dbo