Category: Scripts
-
Estimated Time for Backup / Restore
This script can be used to find the estimated time of backup and restore that is on progress in your SQL server. This script is applicable for SQL server 2005 and above.
-
Enabling Remote connections via DOS or T-SQL
How to use the script 1.) Create the procedure in master db 2.) Use the command as below
-
Trigger Status
This will list out status of the trigger in a Database. This is compatible to SQL 2000 and 2005.
-
Table and Column Details
This script gives a detailed information about tables and thier associated column properties for each database. This lists out Database name, owner name, table name, column name, data type, collation, etc. This is compatible to SQL 2000 and 2005.