Data Engineering – Learn from the experts
-
Table Space Details
This script will list out the details of the space used by each in a database.This is compatible to SQL 2000 and 2005.
-
Server Property
This will list out the server properties of your sql server including the account under which your services run. 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.
-
Trigger Status
This will list out status of the trigger in a Database. This is compatible to SQL 2000 and 2005.
-
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
Got any recommendations?