SP3 & CURSORS
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 returns more than one row I get the number of rows
instead of
the selection! |