>>>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.

What needs to be re-written? What problem are you talking about? Once again I don't understand what you mean. Complete your closer look and then ask.
Cetin