arr.nagaraj (3/18/2009)
select object_name(id) from sysindexes where name like ''
While this definitely will work, it won't provide the table name that the index is associated with. In an earlier post I offered that I'd bet the index by that name existed on a different table. My posted query will pinpoint exactly which one it is. 😉
-- You can't be late until you show up.