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 |
|
lauramayer
Posting Yak Master
152 Posts |
 Posted - 2006-02-10 : 06:40:48
|
| Morning, I have a developer who thought in order to give himself dbo.owner permisisons he had to change the login name of dbo to his login name so now when you look at dbo is says name: dbo login name domain\usernameIS there a way I can change that back without breaking anything else?ThanksLaura |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-02-10 : 07:49:30
|
| try sp_changedbowner==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
lauramayer
Posting Yak Master
152 Posts |
Posted - 2006-02-10 : 07:52:08
|
| thanks |
|
|
|
|
|
|
developer changed dbo account