Tag: scripts
-
Script to find SQL Job activity details
Ive written a script to find the job activity details, this script will give the output similar to job activity monitor in SQL2K5 or SQL2K8. In my working place we had a request to collect the job details from all the servers which includes all version of SQL Server. Ive tried sp_help_jobactivity for SQL2K5 SQL2k8,…
-
Script to get row count for all the tables in all the databases
Ive written this script to get details of row count in all the tables in all the database including the system database. You can modify the script to exclude system database if you dont need details for that. You can see that I havent use COUNT() function to get these values, If I run using…
-
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.
-
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.…