Change owner of stored procedure SQL Server

Now I am not a DBA by any means but I like to think that I am a pretty damn good Googler but it took me going to the second page of results to find out how to change the owner of a stored procedure.

A lot of posts pointed to this Microsoft article on changing the owner of MANY objects but I only wanted to change ONE.

This post is mostly for me but here is the solution:

sp_changeobjectowner ‘objectName’, ‘newObjectOwner’

It’s that simple. Now kick yourself in the ass for wasting so much time.

blog comments powered by Disqus