Wednesday, February 15, 2012

Error security level explanation please.

Hi
Why would this error stop the execution of my Stored procedure.
Server: Msg 8501, Level 16, State 3, Line 1
[Microsoft][ODBC SQL Server Driver][SQL Server]MSDTC on server 'Server1' is
unavailable.
I thought that only errors with level 20 to 25 did that.
IanHi,
Read these about error handling:
http://www.sommarskog.se/error-handling-I.html
http://www.sommarskog.se/error-handling-II.html
Check XACT_ABORT setting...
"Ian" <ian@.NoWhere.com> wrote in message
news:%23ZcyUFpiEHA.4092@.TK2MSFTNGP10.phx.gbl...
> Hi
>
> Why would this error stop the execution of my Stored procedure.
> Server: Msg 8501, Level 16, State 3, Line 1
> [Microsoft][ODBC SQL Server Driver][SQL Server]MSDTC on server 'Server1'
is
> unavailable.
> I thought that only errors with level 20 to 25 did that.
>
> Ian
>|||You had batch abort... There is not much documentation from MS on these
kinds of things, but Erland Sommerskog's articles that the previous
respondent points to is the best information available anywhere on the
subject. (Thanks Erland.)
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Ian" <ian@.NoWhere.com> wrote in message
news:%23ZcyUFpiEHA.4092@.TK2MSFTNGP10.phx.gbl...
> Hi
>
> Why would this error stop the execution of my Stored procedure.
> Server: Msg 8501, Level 16, State 3, Line 1
> [Microsoft][ODBC SQL Server Driver][SQL Server]MSDTC on server 'Server1'
is
> unavailable.
> I thought that only errors with level 20 to 25 did that.
>
> Ian
>|||Thanks heaps.
"Ian" <ian@.NoWhere.com> wrote in message
news:%23ZcyUFpiEHA.4092@.TK2MSFTNGP10.phx.gbl...
> Hi
>
> Why would this error stop the execution of my Stored procedure.
> Server: Msg 8501, Level 16, State 3, Line 1
> [Microsoft][ODBC SQL Server Driver][SQL Server]MSDTC on server 'Server1'
is
> unavailable.
> I thought that only errors with level 20 to 25 did that.
>
> Ian
>

No comments:

Post a Comment