>>Thanks. For some reason I thought since it's an inner join to sysindexes it means table should have indexes (as the name suggests). Thanks again.
>
>No you are wrong. It doesn't mean that table should have indexes. SysIndexes doesn't only hold information about tables that have indexes and it is clearly documented.
>Cetin

Thanks again. http://msdn.microsoft.com/en-us/library/ms190283.aspx

So, looks like the code above needs to be re-written. I'll take a closer look into this problem later today.