March 3, 2006 at 8:56 am
I was looking for a script that would enumerate a database for all indexes and associated information and write all that information to a permenant table.
Appreciate replies
March 3, 2006 at 9:51 am
I haven't got one to hand but it's all in the sysindexes table. Probably wouldn't take long to write one.
March 3, 2006 at 2:22 pm
There is one in the script section here -> just lOOk
_/_/_/ paramind _/_/_/
March 4, 2006 at 12:22 am
Here is the select statement, i don't know whether it is useful for you or not.
use
select a.name table_name,xtype,b.name Index_name from sysobjects a,sysindexes b
where a.xtype='U' and a.id=b.id order by a.name
Ramaa
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply