June 30, 2005 at 4:22 am
We are using Hp open view for remotely administrating Sql server.We defined one matrics for number of lock request per second that resulted in a dead lock for all objects combined.For these particular matrics we are getting 50-60 alerts per day giving the message 'Error opening cursor mESQLCursor [The cursor was not declared. (16945)]'
Any help will be hignly apreciated.
June 30, 2005 at 4:45 am
In BOL it is mentioned that a 'separate database connection required for each open browse cursor.Each connection counts toward the total number of user connections configured on an instance of Microsoft® SQL Server™ 2000. If an attempt to make a new connection fails when opening a browse cursor, or if a valid current connection is not made when opening a standard cursor, then run-time error -19521 "Open cursor failure" - usually occurs.'
Any relation?
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply