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!
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.