I have a real problem with SQL 6.0 and SQL 6.5 not recognize a creation
of an index in a temporary table when done inside a stored procedure only.
It is okay when done outside in the query window using GO.
try this experiment and you will understand what I am saying.
in the query window type
select * into #temp1 from sysindexes
create index temp1_index on #temp1(id)
select * from #temp1(index=temp1_index)
The above code will run fine.
try to put the code inside a sp, without the go
and run it,
it will give you the following error
Msg 308, Level 16, State 1
Index 'temp1_index ' on table '#temp1' (specified in the FROM clause) does
I need to find an answer to my problem, or a work around it
Thank you for hep
Tomas S Polanco
Sanpoco Computer System