this one of wonderful scripts and very important 

—Change DB Owner on All Databases
EXEC sp_MSforeachdb ‘IF ”?” NOT IN (”Master”,”tempDB”,”model”,”msdb”)
BEGIN
EXEC [?]..sp_changedbowner ”User Name”
END
‘

To know More about new feature in SQL Server 2016 you can check it from HERE

Follow Us :

LinkedIn , Slideshare ,Youtube Channel.MSDN POSTS ,Facebook , WHO WE ARE

Published by Mustafa EL-Masry

MY NAME IS MUSTAFA ELMASRY I have total years’ Experience +10 in SQL Server technology started my carrier path in 2008 as technical Support and now I am working as a Database Consultant in the banking sector managing around 200 DB Servers AS Production servers plus other environments UAT, SIT and staging servers, I have High-level experience in Database Administration, Performance Tuning, disaster recovery, development (T-SQL), SSRS. And Good Experiences in SSIS, SSAS AZURE DB, Automation (Power-Shell + TSQL) I will be Happy if you take a look on my main profile to know more information about me and to know how you can contact me (https://mostafaelmasry.com/about-me/)

Leave a Reply

Fill in your details below or click an icon to log in:

Gravatar
WordPress.com Logo

You are commenting using your WordPress.com account. ( Log Out /  Change )

Google photo

You are commenting using your Google account. ( Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. ( Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. ( Log Out /  Change )

Cancel

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.