Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
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.

By CSVIKING,

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
FORUM

Script

Need Automated Script

FORUM

drop script

drop script

FORUM

Monitoring script

script

FORUM

script errors

script errors

 
Contribute