change db ownership

August 25th, 2008 by Mr.M | No Comments »

There comes a time when all of your databases are owned by some retarded users or that you forgot to change the database owner after a restore. The following sproc will loop thru your databases and change the owner to ‘sa.’

You can take it a step further and have it the server send you an email when all the changes. I was just too lazy to write that party in.

Download Change db ownership Version 0.2

Leave a Reply

You must be logged in to post a comment.