Setting All User Databases To Read Only Status
Every want to keep everyone from updating all your users database? If so this script will set each database to read only status.
2002-09-26
318 reads
Gregory Larsen
Set All databases to DBO only and Single User Mode
Every want an easy way to set all database to DBO only and single user mode? Well here is a script to do that for you. This script is useful when you want to keep users out of the all the databases.
2002-09-23
919 reads
Turn off DBO and Single User mode for all DB's
Here is a companion script to "Set All databases to DBO only and Single User Mode" that will turn off dbo and single user mode for all databases.
2002-09-23
423 reads
Nightly Failed Jobs Report
Do you get tired of reviewing each SQL Agent notifications nightly to determine which SQL Agent jobs failed? Is there a significant number of SQL Agent job notifications that it takes a while to review each? Here is an alternative that allows you to have a single email report of all job failures.
2002-09-17
11,640 reads
Beware to the System Generated Constraint Name
New columnist Gregory Larsen used to not care what his objects were called until recently when he began to become concerned with the system generated constraint names. This short article tells you why.
2002-08-16
7,089 reads
Get Record Counts for All Tables in Every Database
This stored procedure produces a report of record counts for every table on your server. The record count report is organized by database, and table name.
2002-05-16
621 reads
Blogs
SQLSaturday Automatic Messages
By Andy Warren
For those who haven’t used the admin tools for SQLSaturday when an event is...
Using the Announcement/News Part of SQLSaturday
By Andy Warren
One of the interesting but not often used features of the SQLSaturday tools is...
SQLSaturday Orlando 2019 Begins
By Andy Warren
We’ll be event number 911, set for September 28th at our usual location at...
Forums
Statistics Profile Results
Comments posted to this topic are about the item Statistics Profile Results
Transaction was deadlocked on lock | communication buffer resources with another
I have a table that contains case numbers. The following stored procedure assigns a...
Microsoft and Oracle Cloud Partnership
Comments posted to this topic are about the item Microsoft and Oracle Cloud Partnership
Ask SSC