SQL Server 2000 - list the current Statistics names that exist on a table
Using Query Analyzer you can list an execution plan for a query , where you can find/get any statistics that are missing for that query. So to see the create missing statistics you will get further information such as Statistics name and so on and further information on statistics you could use DBCC SHOW_STATISTICS statement.
To get the same with TSQL you can simply run :
SELECT name, id from sysindexes where name like '%WA_Sys%'
