Change owner of a Microsoft SQL Server database

Home General Change owner of a Microsoft SQL Server database

Mar

Change owner of a Microsoft SQL Server database

by Xavier in General, IT, SQL Server

We had a spaghetti of database owners so I decided to get this straightened out. How to do it? Simple!

– Open New Query in SQL Server Management Studio in the database that you want to change the owner
– Run EXEC sp_changedbowner ‘domain\owner’
– Wait for Command(s) completed successfully.

As simple as that!

About the Author: Xavier

Xavier is an entrepreneur, project manager, trainer, Certified Scrum Master & Professional and Certified Microsoft professional who has spent a great deal of his career working on cutting edge projects, with a primary focus on .Net and recently iOS. His expertise is primarily web applications, search and mobile. Throughout multiple projects he has acquired skills in dealing with complex enterprise software deployments with companies that range from startups to Microsoft. Also worked as a worldwide v-trainer/evangelist for Microsoft.

« How to throttle Google Drive

Determine number of active connections to each database in SQL Server »