SP3 & Cursors -
10-02-2003
, 01:02 PM
We just installed SP3 and the cursor behaviors changed,
does anyone know anything about that? I call this stored
procedure from DTS:
DECLARE Queue_cursor
SCROLL CURSOR FOR SELECT SOURCE_PATH,COMPANY, TABLE_NAME
FROM dl.dbo.companies
OPEN Queue_cursor
FETCH ABSOLUTE @lineNumber FROM
Queue_cursor
CLOSE Queue_cursor
DEALLOCATE Queue_cursor
If the cursor contains returns more than one row I get the
number of rows in the cursor instead! |