Saturday, February 25, 2012

Change table owner to dbo

How do I change the table owner back to dbo?Never mind. I got it. I did not query MSDN correctly to find the answer.
sp_changeobjectowner
"sxa222" wrote:
> How do I change the table owner back to dbo?|||sp_changeobjectowner [ @.objname = ] 'object' , [ @.newowner = ] 'owner'
--
MG
"sxa222" wrote:
> How do I change the table owner back to dbo?|||Note that in 2005, this proc change both owner and schema, and also that the proc is deprecated. As
of 2005, use ALTER AUTHORIZATION to change owner of an object.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"sxa222" <sxa222@.discussions.microsoft.com> wrote in message
news:06384594-B178-42B8-B705-33E60E1F8B40@.microsoft.com...
> Never mind. I got it. I did not query MSDN correctly to find the answer.
> sp_changeobjectowner
> "sxa222" wrote:
>> How do I change the table owner back to dbo?

No comments:

Post a Comment