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 |
|
victord
Yak Posting Veteran
64 Posts |
 Posted - 2003-04-07 : 09:15:19
|
| Hello Folks,I have a couple of databases running on SQL Server 7 engine, with a user specified as 'Dbo' and a login of agrprod.My problem is trying to change the user from dbo to agrprod. That is the user and login should be agrprod.I have tried dropping the user and login in order to recreate it, but failed because the user is stated as a dbo. How else could i acheive this. Please help.Regards,Victord |
|
|
Peter Dutch
Posting Yak Master
127 Posts |
Posted - 2003-04-07 : 10:36:10
|
| sp_changeobjectowner [ @objname = ] 'object' , [ @newowner = ] 'owner' |
 |
|
|
|
|
|
Database user issues