We have an application connects to the database server, recently at times it gives "Error in OpenConnection ()
TimeOut Expired" Error.
I tried to put profiler and found that
"Error: 16945, Severity: 16, State: 1"
"Error: 16937, Severity: 16, State: 1"
are currently occuring on the server at some regular intervals and at that time connection timeout expired error
the above two cursors talk about cursors, but the procedures that the application is trying to use does not have any
any help would be highly appreciated.
I used to get some timed out errors similar to this when my application server and SQLServer were on 2 machines.
When i moved both to a single machine i stopped getting it.
I suspect its something to do with the network.
i dont think its a network related issue.
error 16937 refers to "A server cursor is not allowed on a remote stored procedure or stored procedure with more than one SELECT statement. Use a default result set or client cursor."
but the stored procedure that is been called has only one select statement in it.
still i get this error.