Friday, October 17, 2008

How to change owner of object/Stored Procedure

to change owner of object/Stored Procedure

exec sp_changeobjectowner 'objectname','username'

for example

exec sp_changeobjectowner 'proc_getallrecords','dbo'
Posted by Website For Business at 4:17 AM
Labels:

1 comment:

dextro123 said...

I'm sure it's a pretty good guide for programmer. Just too bad I don't understand anything about it. It's too advance for a newbie like me mate!

October 23, 2008 at 8:55 AM

Post a Comment

Subscribe to: Post Comments (Atom)