Error 313: The optimizer could not find a unique index which it could use to ...

[olowalu2]

I've got a stored procedure which runs fine if I just run it in ISQL.

When I tried to create query subject with in within Cognos, it gave me the following error: "The optimizer could not find a unique index which it could use to perform an isolation level 0 scan on table <temp table name>."

I have created a unique index on my tempdb table. I have also tried using the HOLDLOCK keyword on my select statements. I have also tried setting the isolation level to 3, all to no avail. And all of the above at one. I am thoroughly stumped.

Does anyone have any ideas how to breakthrough on this?

[olowalu2]

NM, I got it! I changed the table from tempdb..tmp_chks to #tmp_chks and that seemd to do the trick.