Sharing the information you need to get development done!
Welcome to DevAuthority.Com Sign in | Join | Help
in Search

Confessions of a Webgypsy

Change Object Owner in Sql Server 2000

I'm posting this mostly as a "note to self."  I don't often have to change the owner of an object in Sql Server, but when I do I always have to scratch my head saying, "how did I do that?"  The answer is simple.  There is a system stored proc that you can use to do it, sp_changeobjectowner.  It takes two paramaters, the name of the object you wish to change as a string, and the name of the new owner of the object. 

exec sp_changeobjectowner 'MyObjectName','myNewOwner'

Published Thursday, August 10, 2006 6:32 AM by dbalzer
Filed Under:

Comments

No Comments
Anonymous comments are disabled







This Blog

Post Calendar

<August 2006>
SuMoTuWeThFrSa
303112345
6789101112
13141516171819
20212223242526
272829303112
3456789

Syndication



Powered by Community Server, by Telligent Systems