2016-04-01 (first published: 2016-03-23)
825 reads
Steve Jones
- Interests: yoga, reading, biking, skiing, volleyball
2015-12-25 (first published: 2015-12-17)
1,658 reads
2015-10-09 (first published: 2014-03-21)
4,745 reads
Check if SQL Server is running
This script will check if the SQL Server you are connected to is actually running.
2015-04-01 (first published: 2015-03-27)
1,705 reads
SS2K - sp_helprevlogin`
Old version, archived, that works on ss2k. Updated version works on ss2k5. NOTE: This is a Microsoft developed script, not from the contributor (Steve Jones)
2007-06-27 (first published: 2006-05-04)
875 reads
All Encompassing Disaster Recovery Script
A script that will help you deal with and get through any disaster recovery situation.
2005-04-01 (first published: 2005-03-29)
521 reads
Stored Procedure to Backup all files
This stored procedure performs a full backup on all databases on a server. It takes a parameter for a drive letter and will create the backup structure as needed. The standard backup structure is "\mssql\backup\".
2001-10-22
535 reads
Kill spids that are idle
Ever wanted to get rid of users who are sitting idle for long periods of time? Here's a script that removes spids idle for a variable period of time.
2001-10-03
4,442 reads
Trim Backup Files
This script runs within a DTS package. It searches the backup directory stored as a global variable in the script and trims all backup files older than some number of days. the script includes logging to the C: drive so you can trace the effects of the script. You need to create the global variables […]
2001-09-12
1,467 reads
Idle Spid Time
This script will search all logged in users and return the spid along with the number of seconds since that spids last batch was executed.
2001-08-22
909 reads
Blogs
Power BI Meets Programmability – TOM, XMLA, and C#
By DataOnWheels
For anyone who read the title of this and immediately thought, “Oh no, I...
Do Full Backups Break Log Shipping?
By Kevin3NF
TLDR: Nope. Keep on doing your full backups. Make sure that any databases you...
Daily Coping 15 Oct 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
Disabling all access to the server
Hello everyone! We have a small group of users (4) using MS Access 2000...
How to remove data and index fragmentation in a table
The picture is showing the results that I used sp_spaceused for OldTable and NewTable,...
Database Recovery but DB is 7GB and log file is almost 3
I have had a server crash and although I was able to recover the...
Ask SSC