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 |
|
vinoth86
Starting Member
27 Posts |
 Posted - 2008-04-24 : 02:38:28
|
| Hi,I am using SQL SERVER2005,I have user <temp>which owns few objects.I wanna change the owner of the objects which owns by user <temp> to dbo.Is it possible?Plz help me ASAP! |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-04-24 : 02:43:57
|
| Used ALTER AUTHORISATION statement.http://msdn2.microsoft.com/en-us/library/ms187359.aspx |
 |
|
|
vinoth86
Starting Member
27 Posts |
Posted - 2008-04-24 : 03:02:57
|
| Its not working..Alter authorization on temp to dbo.It's not working,i wanna change the owner of the 'temp' owned objects to dbo.This is the error message,i am getting it,Msg 15151, Level 16, State 1, Line 1Cannot find the object 'a424465', because it does not exist or you do not have permission. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-04-24 : 03:58:30
|
| what's the object its refering to? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-24 : 22:47:57
|
| >> Alter authorization on temp to dboYou should specify schema of temp in the statement. |
|
|
|
|
|
|
How to migrate object from a user_schema to dbo?