Category: Scripts
-
Check Identity
This will list out identity columns in a Database. This is compatible to SQL 2005 only.
-
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.