Tag: Database Owner
-
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 to the ubiquitous ‘sa’ account and here goes the script to do so without offending…