>>>>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
In that link it said, that sysindexes is going to be deprecated. Therefore this code needs to be re-written using other system views.
If it's not broken, fix it until it is.
My Blog