sql solace
Friday, 21 July 2006
sp_changeobjectowner
Changes the owner of an object (table/view/sp etc) -
use :
sp_changeobjectowner [objectname] , [new owner]
example :
sp_changeobjectowner 'fasttrackuser.FastTrackPackageDocumentsCombinations', 'dbo'
remarks :
must have appropriate permissions to perform this action.
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment