Здравствуйте 4auHuK, Вы писали:

>(там курсор делает DEALLOCATE после первого же resultset).

Ты уверен в своей правоте?

[msdn]
The SQL Server ODBC driver does not support multiple active recordsets on the same connection when using the forward-only cursor. The OLE DB Provider for ODBC drivers attempts to work around this limitation by creating a second connection. Since temporary tables are only visible to the connection that created it, the application fails to find the table and returns a DB_E_NOTABLE HRESULT

[/msdn]


kb <a target='_blank' class='m' href='http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q238116'>Q238116</a>