Monthly Archives: May 2012

T-SQL Script Using sp_msforeachdb to Change All Databases’ Owner to ‘sa’ Account

Oftentimes, some DB’s in our inventory are modified or restored or created by different user accounts, which leads to having various DB owners in an instance. And a good ‘best practice’ claimed by Microsoft is to align all DB owners … Continue reading

Posted in T-SQL Script | Tagged , | Leave a comment