We have received this error message. Does anyone know what it means or how to fix it?
[Microsoft][SQL Server Native Client 11.0] Invalid transaction state
Debugging info: DeleteDbConnection – SQLFreeHandle Failed
Option info:SqlState = 25000 NativeError = 0 ErrorMsg = [Microsoft][SQL
Server Native Client 11.0]Invalid transaction state pcbErrorMsg = 67
*This post is locked for comments
We have faced this issue as well and including the “SET NOCOUNT ON” to custom triggers to resolve this issue.
Hence, you need to check for “SET NOCOUNT ON” statement is available in custom triggers or stored procedures. If it is not available then alter that trigger / procedure to include the abovesaid statement.
Hope it helps
We have faced this issue as well and including the “SET NOCOUNT ON” to custom triggers to resolve this issue.
Hence, you need to check for “SET NOCOUNT ON” statement is available in custom triggers or stored procedures. If it is not available then alter that trigger / procedure to include the abovesaid statement.
Hope it helps
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (