Category: Scripts
-
Determine which objects exist in a particular filegroup
This script will help you to determine the objects existence in a filegroup. You can get on which file group does a object exists. Change dbname before using the script.
-
Trigger to Check Job failures
I was trying to find a alert which could fire immediately upon any of the job failure in the server to send an email. Unfortunately I couldn’t find any the alert related to this. So I thought of writing a DML trigger which should fire immediately when an entry is inserted in sysjobhistory table on…
-
Disk space (including mounted drive) Check via SQL Server
In my previous article on Diskspace Check via SQLServer will find only physical logical drives that is attached to the system i.e the drive which you see under my computer. Ive used this script in one of my client machine and found that this script is not capable to check disk space for mounted drives.…
-
Script to Get Job Details in SQL 2005
This script will get job details for all the jobs Applies to SQL Server 2000 SQL Server 2005 SQL Server 2008
-
Script to CHECK Startup procedures in SQL Server
Today while checking a server for SQL Server startup performance issue, Im in thought of listing the startup procedures and to analyze those procedures for any issues. But when I Googled & I couldn’t find any script to list out the startup procedures, hence Ive written a script to list the startup procedures. Im sharing…