Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

Scripts by S M profile

   Items 1 to 12 of 12   

Alter database owner to SA from any user details on all user databases

Alter database owner to SA from any other user details against all user databases  Read more...
Rating: |  Discuss |   Briefcase | 1,083 reads

Find no of records in each table in database (against Clustered Index)

If you want to find TotalPages, Usedpages,datapages,totalspaceMB,UsedSpaceMB,DataSpaceMB then can use this query.  Read more...
Rating: |  Discuss |   Briefcase | 1,149 reads

Verify Login SID and Machine SID

This script is to verify which login accounts have SID values that don’t match the correct SID values defined on the machine or in the domain.  Read more...
Rating: |  Discuss |   Briefcase | 1,120 reads

Extracting only Deadlock details from ErrorLog.

If you want to extract only deadlock details, use the script.  Read more...
By S M 2014/12/18 | Source: | Category: deadlock
Rating: |  Discuss |   Briefcase | 1,763 reads

Read all trace file data and print the action performed

If you want to read trace file records from default trace location and want to print to see what are all the activities happened on SQL Server, the query will be helpful for you.  Read more...
Rating: |  Discuss |   Briefcase | 931 reads

Extract SQL Server Key details

Extract SQL Server Name, Instance Name, Service Account details, startMode and ServiceState details with Powershell.  Read more...
By S M 2014/10/27 | Source: | Category: powershell
Rating: |  Discuss |   Briefcase | 1,205 reads

Simple script to list out SPID, Program_name and login details

If you have any requirement where you want to find out all the SPIDs running on a database along with the program/application name of the SPID and the login details. You can run the procedure to get the details very easily.  Read more...
By S M 2014/08/12 | Source: | Category: spid
Rating: |  Discuss |   Briefcase | 1,586 reads

Query to check whether my Full Database Backup is running fine.

The query will help to find whether my database backup to a specific instance of SQL Server is running fine. If HH> 1, this would signify that the backup is running, else this is a failure.  Read more...
By S M 2012/09/13 | Source:
Rating: |  Discuss |   Briefcase | 1,110 reads

Backup Database Size calculation Report - Monthwise

The script helps to calculate the size of the backup of the databases monthwise. This will help to understand the database growth rate from the backup file if we do not have any data collection utility to find the exact details of the DATA File growth.  Read more...
By S M 2012/09/24 | Source:
Rating: |  Discuss |   Briefcase | 1,155 reads

Killing User Connection(session) connected to the Database.

The script will be helpful to kill all the user sessions before performing the refresh of the database.  Read more...
By S M 2011/04/08 | Source: | Category: kill
Rating: |  Discuss |   Briefcase | 2,397 reads

Script: Map Orphan Login and Users

Map the Orphan Login and Users. 
By S M 2011/01/03 | Source: | Category: backup / restore
Rating: |  Discuss |   Briefcase | 2,595 reads
   Items 1 to 12 of 12