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
424 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,644 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,095 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
622 reads
Blogs
New Centralized View of SQL Resources in Azure
Yesterday, some new views were made available in the Azure portal that will be...
Letter To My Father
We spread my Fathers ashes over the past weekend. It was one of the...
My Organizer's Notes and Goodbye after #SQLSatBR 2019
Some 2019 tips for other SQLSat organizers from my last year as lead organizer...
Forums
AOAG Secondary Checkdb
I'm looking into setting up a AOAG with a DR server which will have...
sp_executesql with multiple parameters
I'm trying to write a stored procedure that will select the entire table if...
SQL Server 2016 Archive Strategy advice.
Greetings. I’m after some advice. I’m helping a colleague with a SQL Server 2016...
Ask SSC