Hi,

I thought to list few SQL Server 2005 system tables, stored procedures which could be used in daily DBA activities. The ones which mostly used
1) Information_Schema.Tables : Holds information of available tables in Database
2) Information_Schema.Columns: Lists all columns from all tables in specific Database
3) sp_MSforeachdb: usefull for free up disk space, e.g., Shrink Command. There is are some limitations of using shrink command thats in next post if I get time to post. E.g. Exec sp_msfor...
Continue reading ...