Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

Set all databses to dbo.


I got this script from this site and it works fantastic. I would just like to give an update to this script. All credit should go to the person that published this script on this site not me. I would just like to point out a few things. If you want to schedule this as a job once a new databse get created you should include the msdb, model, northwind, pubs, master and tempdb in the script to not be set to dbo or single user otherwise your sql server agent wont start. The databses can not be set to dbo and single at the same time. I made it to only set the database to dbo and to exclude the above mentioned database. PLEASE NOTE THIS IS NOT MY WORK ALL THE CREDIT SHOULD GOT TO GREG LARSEN FOR THIS GREATE SCRIPT.

Total article views: 409 | Views in the last 30 days: 4
Related Articles


Need Automated Script


drop script

drop script


Monitoring script



script errors

script errors


Join the most active online SQL Server Community

SQL knowledge, delivered daily, free:

Email address:  

You make SSC a better place

As a member of SQLServerCentral, you get free access to loads of fresh content: thousands of articles and SQL scripts, a library of free eBooks, a weekly database news roundup, a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals that makes it such a success.

Join us!

Steve Jones

Already a member? Jump in:

Email address:   Password:   Remember me: Forgotten your password?
Steve Jones