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 |
|
dbaman
Starting Member
46 Posts |
 Posted - 2009-02-17 : 14:06:37
|
| I have Database on SQLServer2005 box. The current owner of the objects and stored procedure is DBO. I want to change the owner to lets say devteam1. devteam1 is a user in the database with db_datareader db_datawriter db_ddladmin permission.However when I run the script USE DBNAMEExec sp_changeobjectowner 'emp Information', 'devteam1';goI am getting the error message: Msg 15411, Level 11, State 1, Procedure sp_changeobjectowner, Line 107Database principal or schema 'devteam1' does not exist in this database.What I am doing wrong?Thanks for all the help.R |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
dbaman
Starting Member
46 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Change Table/SP owner