Changing database owner
This recipe shows how to programmatically change a SQL Server database owner.
Getting ready
This task assumes you have created a database called TestDB
, and a Windows account QUERYWORKS\srogers
. QUERYWORKS\srogers
has been created in our test VM.
Note
For more information, see Appendix B, Create a SQL Server VM.
If you don't have it, create the database TestDB
by following the steps in the Creating a database recipe.
How to do it...
Let's look at the steps involved in changing a database owner:
- Open PowerShell ISE as administrator.
- Import the SQLPS module and create a new SMO Server Object:
#import SQL Server module Import-Module SQLPS -DisableNameChecking #replace this with your instance name $instanceName = "localhost" $server ...
Get SQL Server 2014 with PowerShell v5 Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.