Monday, March 19, 2012

Error: 16954, Severity: 10, State: 1

Hi there.
I ran a trace over our SQL server and picked this error up.
Does anyone have any idea what could be causing this ?
Error: 16954, Severity: 10, State: 1
Our server is SQL2000 SP3a patched to 8.00.818 running on Win2K server.
Any help would be greatly appreciated.
Thanks
AndyHi
This error is connected with the use or no use of cursors.
The message indicated that a server side cursor was requested
(sp_cursoropen) but no cursor was necessary, as the SQL statement was
executed directly.
The error message can be informational.
Do you get timeout or disconnection after this error or any specific issue
on the Server Side?
HTH
Regards
Sadeesh
--
This posting is provided AS IS with no warranties, and confers no rights.
"Andy Hayes" <andyh@.friday-ad.co.uk> wrote in message
news:OjUrMY8bEHA.1000@.TK2MSFTNGP12.phx.gbl...
> Hi there.
> I ran a trace over our SQL server and picked this error up.
> Does anyone have any idea what could be causing this ?
> Error: 16954, Severity: 10, State: 1
> Our server is SQL2000 SP3a patched to 8.00.818 running on Win2K server.
> Any help would be greatly appreciated.
> Thanks
> Andy
>

No comments:

Post a Comment