Cursors Using Stored Procedures

Server cursors can only be opened on a stored procedure that contains a single SELECT statement. Using a stored procedure that contains no SELECT statement, more than one SELECT statement, or any statement other than a SELECT statement will generate an error. Because of this restriction, server cursors cannot be used with the ODBC catalog functions when connected to SQL Server 6.0 or earlier.