Thread: SP3 & CURSORS
View Single Post

   
  #1 (permalink)  
Old 02-28-2008, 07:10 PM
Ahmed B. Zayan
 
Posts: n/a
Default 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!
Reply With Quote