to change owner of object/Stored Procedure
exec sp_changeobjectowner 'objectname','username'
for example
exec sp_changeobjectowner 'proc_getallrecords','dbo'
Showing posts with label change owner of object/Stored Procedure. Show all posts
Showing posts with label change owner of object/Stored Procedure. Show all posts
Friday, October 17, 2008
Subscribe to:
Posts (Atom)
