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
319 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
930 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
427 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,647 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,100 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
627 reads
Blogs
Transforming JSON data with the help of Azure Data Factory - Part 4 - Passing Arrays around
By Rayis Imayev
(2020-May-24) It has never been my plan to write a series of articles about how...
3D Printing Ear Savers
By Tim Radney
On April 5th, I started printing ear savers for healthcare workers. I started with...
Updated Default Settings for Azure SQL Managed Instance Databases
By Tim Radney
A common saying about Azure is that it is always changing. This is a...
Forums
Are there application developers in here? Where are you doing your SQL?
Hi, Are there app developers in this forum? Where does your app's SQL live?...
Building Better Software for Everyone
Comments posted to this topic are about the item Building Better Software for Everyone
Rounding and Sums
Comments posted to this topic are about the item Rounding and Sums
Ask SSC