Welcome to Aussie SQL Server Bloggers Sign in | Join | Help

March 2005 - Posts

Tuesday, 29 March 2005 1:14 PM

A query to list indexes in a database

I'm always hunting around my hard-drive for a query that lists indexes in a database, so here's one for everyone's (including my) future reference (SQL2K only) select so.name as 'tablename'     , si.indid     ,
posted by Greg_Linwood | 0 Comments
Wednesday, 23 March 2005 11:44 AM

Collecting multi-resultset output from DBCC SHOW_STATISTICS using DTS

Someone asked how to collect the multi-resultset output from DBCC SHOW_STATISTICS in the SQL MVP forum today. This is a tricky thing to do in TSQL because there are no features on TSQL to catch multi-resultset output from stored procs, DBCC etc. You
posted by Greg_Linwood | 0 Comments