2007-09-11 (first published: 2007-05-03)
557 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,961 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)
362 reads
Blogs
Daily Coping 30 Nov 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Fail activity in Azure Data Factory and Why would I want to Fail
By Rayis Imayev
(2021-Nov-30) I heard a story about a young person who was asked why she was...
Hiding Email with a Dynamic Data Masking Function–#SQLNewBlogger
By Steve Jones
Another post for me that is simple and hopefully serves as an example for...
Forums
How to move Paas SQL Database from one subscription to another subscription
Hi experts, Can some one please post procedure/Steps to move ( including Logins, Users)...
Arithmetic overflow error converting expression to data type datetime when selec
I have such an issue. I want to select a column PDWEDT (it is...
inner join give me huge data when package id equal package id from another table
I work on sql server 2014 i face issue when join two tables as...
Ask SSC