Link to home
Start Free TrialLog in
Avatar of IxCraZee
IxCraZee

asked on

"SQLGetDiagRec Failed" in SQL Server...

Hi all, I got the message "SQLGetDiagRec Failed" in SQL server 2005. From what I found from Internet, SQLGetDiagRec is an ODBC functions to return the status of diagnostic records that contains error, warning, or status information. But I do not use this function in my Stored Proc (SP). There is a part in my SP that has a cursor loop and inside the cursor loop I do some freetext search. I suspect this error is occured somewhere within this cursor loop.

Does anyone of  you have any idea on this message? How it happens? And how to resolve or avoid this?

Thanks in advance and any help would be greatly appreciated!
ASKER CERTIFIED SOLUTION
Avatar of twoboats
twoboats

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial