What is the easiest way to change owner of some db object (table, sp, etc.)?
Thanks!from Books Online:
Syntax
sp_changeobjectowner [ @.objname = ] 'object' , [ @.newowner = ] 'owner'
Example
EXEC sp_changeobjectowner 'authors', 'Corporate\GeorgeW'|||This was really fast! :)
Thank you very much!sql
Showing posts with label easiest. Show all posts
Showing posts with label easiest. Show all posts
Monday, March 26, 2012
Subscribe to:
Posts (Atom)