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 = ] 'owne
r'
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...[vbcol=seagreen]
> Never mind. I got it. I did not query MSDN correctly to find the answer.
> sp_changeobjectowner
> "sxa222" wrote:
>

No comments:

Post a Comment