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_msforeachDB @Command = N'DBCC ShrinkDatabase (?,10)',@ReplaceChar = '?''' (Try this at your own risk)4) sp_msforeachtable: This would loop for every table in Database.
