2007-09-11 (first published: 2007-05-03)
553 reads
Find The Database Recovery Model
A simple script to find the database recovery model. Cut & paste into Query Analyser
2007-05-17 (first published: 2007-05-08)
2,958 reads
Easily Kill All Users In A Database
This simple script (ran from the master database) in Query Analyser removes all the requirements of collating currently connected spids to a database and the need to systematically open a cursor to kill each spid individually by simply placing the database offline, then immediately online.
2007-03-16 (first published: 2007-02-13)
359 reads
Blogs
On Dynamic Ports, Named Instances, and Firewalls
By Will Assaf
Recently I had a client and their vendor trying to configure a firewall for...
Daily Coping 13 Jul 2020
By Steve Jones
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...
Last Week Reading (2020-07-12)
By Kamil
Press Azure resource providers operations List of all of the available ADF-specific RBAC permissions....
Forums
The transaction log for database 'mydb' is full due to 'LOG_BACKUP'
I got an alert The transaction log for database 'mydb' is full due to...
The C in ACID
Comments posted to this topic are about the item The C in ACID
Renting Features
Comments posted to this topic are about the item Renting Features
Ask SSC