If XACT_ABORT is on for the current connection, parsing a T-SQL query will generate the following error:
.Net SqlClient Data Provider: Msg 0, Level 11, State 0, Line 0
A severe error occurred on the current command. The results, if any, should be discarded.
The SQL will still execute. To avoid this error being reported, simply set XACT_ABORT off.
No comments:
Post a Comment