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 |
|
Adde
Starting Member
9 Posts |
 Posted - 2006-01-23 : 05:26:15
|
| I cannot find where to change the login name for the dbo user in a single database in SQL Server 2000?//Adde |
|
|
Chris Veldt
Starting Member
3 Posts |
Posted - 2006-01-23 : 06:33:49
|
| Try this: exec sp_changedbowner 'login name' |
 |
|
|
Adde
Starting Member
9 Posts |
Posted - 2006-01-23 : 15:05:27
|
quote:
Originally posted by Chris Veldt
Try this: exec sp_changedbowner 'login name'
Thanks!  |
|
|
|
emayer
Starting Member
1 Post |
Posted - 2009-09-09 : 17:44:21
|
I tried it and it works great for me.Thanks,elaine |
|
|
|
|
|
|
Set dbo login name