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
922 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
425 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,645 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,097 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
625 reads
Blogs
SQL in the City Comes Back to Seattle
By Steve Jones
This year at the PASS Summit, Redgate is holding our SQL in the City...
Backup Techniques for SQL Server on Azure Virtual Machines
By Arun Sirpal
In the previous blog post I did a quick overview building a SQL VM...
SQLCover 0.5 - Fixes, smaller features and an exciting surprise
By Ed Elliott
It has been a little while but I have updated SQLCover to include a...
Forums
Exception handling for backup related errors.
Hi All, Need some help in exception handling. In below code, I want to...
DB Log File Location Error
Hi, I am taking full backup of db on remote location. The issue we...
SQL query help
I have a table like this: Year month col_abc1 col_abc2 col_abc3 col_abc4 col_processing 2019...
Ask SSC