Error Viewing the Execution option of a Report

I select the option execution from a report (it's in properties option) and then raise an error which says An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help

EXECUTE permission denied on object 'xp_sqlagent_notify', database 'mssqlsystemresource', schema 'sys'.

I have full privileges in the DB and I think the report server is well configured. This is happening since I reinstalled all the system (including windows). Any ideas?

I think you would need to grant permissions to SQL Agent stored procedures that Reporting services use. Here is the list from our installation script:

USE master

GO

GRANT EXECUTE ON master.dbo.xp_sqlagent_notify TO RSExecRole

GO

GRANT EXECUTE ON master.dbo.xp_sqlagent_enum_jobs TO RSExecRole

GO

GRANT EXECUTE ON master.dbo.xp_sqlagent_is_starting TO RSExecRole

GO

USE msdb

GO

-- Permissions for SQL Agent SP's

GRANT EXECUTE ON msdb.dbo.sp_help_category TO RSExecRole

GO

GRANT EXECUTE ON msdb.dbo.sp_add_category TO RSExecRole

GO

GRANT EXECUTE ON msdb.dbo.sp_add_job TO RSExecRole

GO

GRANT EXECUTE ON msdb.dbo.sp_add_jobserver TO RSExecRole

GO

GRANT EXECUTE ON msdb.dbo.sp_add_jobstep TO RSExecRole

GO

GRANT EXECUTE ON msdb.dbo.sp_add_jobschedule TO RSExecRole

GO

GRANT EXECUTE ON msdb.dbo.sp_help_job TO RSExecRole

GO

GRANT EXECUTE ON msdb.dbo.sp_delete_job TO RSExecRole

GO

GRANT EXECUTE ON msdb.dbo.sp_help_jobschedule TO RSExecRole

GO

GRANT EXECUTE ON msdb.dbo.sp_verify_job_identifiers TO RSExecRole

GO

GRANT SELECT ON msdb.dbo.sysjobs TO RSExecRole

GO

GRANT SELECT ON msdb.dbo.syscategories TO RSExecRole

GO

|||I'm seeing that i'm not have RsExecRole. If there is something wrong with my installation of RS, or the RS DB? Any one have an idea if I have to create a SQL group and then run the script above?|||Yes, you have to create a role called RsExecRole in ReportServer, ReportServerTempDB, master and msdb.
You probably have it in ReportServer and ReportServerTempDB if you backed up your database and restored it on a new SQL server.

Thanks
Tudor|||Yeeeees. You were right. I created the roles in master and in msdb. Because it was already in RS DB (I restore those DB). After that I executed the script you gave me and that's all.
Thank you
VectorR3|||

Hi,

we have the same error for a scheduled subscription report. when we run the report normally it works

I applied the script but still getting the same error. any idea?

Thanks
Bava

|||I was unable to subscribe to reports and this solved my problem. Thanks for your help.

John Cutsinger
Altegris|||This also solved the problem for me. Thanks!

|||

Thanks for the post.. i got the same error and was able to solve it thanks to Tudor

|||

Hi. I am very much having this error, and it doesn't want to go away!

I have the RsExecRole role on all 4 the DB's. It was already there.

I ran your scripts, but still getting the error. I changed the DB owner of my ReportServer$SQL2005 and ReportServer$SQL2005TempDB DB's from my domain administrator to the sa user, which is the user I use in my report's datasource to connect to the DB. Still it doesn't work.

I am quite fedup with this thing now. Spent most of the day on it with no progress.

Any help / tips will be supremely appreciated.

Error Viewing the Execution option of a Report

I select the option execution from a report (it's in properties option) and then raise an error which says An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help

EXECUTE permission denied on object 'xp_sqlagent_notify', database 'mssqlsystemresource', schema 'sys'.

I have full privileges in the DB and I think the report server is well configured. This is happening since I reinstalled all the system (including windows). Any ideas?

I think you would need to grant permissions to SQL Agent stored procedures that Reporting services use. Here is the list from our installation script:

USE master

GO

GRANT EXECUTE ON master.dbo.xp_sqlagent_notify TO RSExecRole

GO

GRANT EXECUTE ON master.dbo.xp_sqlagent_enum_jobs TO RSExecRole

GO

GRANT EXECUTE ON master.dbo.xp_sqlagent_is_starting TO RSExecRole

GO

USE msdb

GO

-- Permissions for SQL Agent SP's

GRANT EXECUTE ON msdb.dbo.sp_help_category TO RSExecRole

GO

GRANT EXECUTE ON msdb.dbo.sp_add_category TO RSExecRole

GO

GRANT EXECUTE ON msdb.dbo.sp_add_job TO RSExecRole

GO

GRANT EXECUTE ON msdb.dbo.sp_add_jobserver TO RSExecRole

GO

GRANT EXECUTE ON msdb.dbo.sp_add_jobstep TO RSExecRole

GO

GRANT EXECUTE ON msdb.dbo.sp_add_jobschedule TO RSExecRole

GO

GRANT EXECUTE ON msdb.dbo.sp_help_job TO RSExecRole

GO

GRANT EXECUTE ON msdb.dbo.sp_delete_job TO RSExecRole

GO

GRANT EXECUTE ON msdb.dbo.sp_help_jobschedule TO RSExecRole

GO

GRANT EXECUTE ON msdb.dbo.sp_verify_job_identifiers TO RSExecRole

GO

GRANT SELECT ON msdb.dbo.sysjobs TO RSExecRole

GO

GRANT SELECT ON msdb.dbo.syscategories TO RSExecRole

GO

|||I'm seeing that i'm not have RsExecRole. If there is something wrong with my installation of RS, or the RS DB? Any one have an idea if I have to create a SQL group and then run the script above?|||Yes, you have to create a role called RsExecRole in ReportServer, ReportServerTempDB, master and msdb.
You probably have it in ReportServer and ReportServerTempDB if you backed up your database and restored it on a new SQL server.

Thanks
Tudor|||Yeeeees. You were right. I created the roles in master and in msdb. Because it was already in RS DB (I restore those DB). After that I executed the script you gave me and that's all.
Thank you
VectorR3|||

Hi,

we have the same error for a scheduled subscription report. when we run the report normally it works

I applied the script but still getting the same error. any idea?

Thanks
Bava

|||I was unable to subscribe to reports and this solved my problem. Thanks for your help.

John Cutsinger
Altegris|||This also solved the problem for me. Thanks!|||

Thanks for the post.. i got the same error and was able to solve it thanks to Tudor

|||

Hi. I am very much having this error, and it doesn't want to go away!

I have the RsExecRole role on all 4 the DB's. It was already there.

I ran your scripts, but still getting the error. I changed the DB owner of my ReportServer$SQL2005 and ReportServer$SQL2005TempDB DB's from my domain administrator to the sa user, which is the user I use in my report's datasource to connect to the DB. Still it doesn't work.

I am quite fedup with this thing now. Spent most of the day on it with no progress.

Any help / tips will be supremely appreciated.

Error Viewing the Execution option of a Report

I select the option execution from a report (it's in properties option) and then raise an error which says An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help

EXECUTE permission denied on object 'xp_sqlagent_notify', database 'mssqlsystemresource', schema 'sys'.

I have full privileges in the DB and I think the report server is well configured. This is happening since I reinstalled all the system (including windows). Any ideas?

I think you would need to grant permissions to SQL Agent stored procedures that Reporting services use. Here is the list from our installation script:

USE master

GO

GRANT EXECUTE ON master.dbo.xp_sqlagent_notify TO RSExecRole

GO

GRANT EXECUTE ON master.dbo.xp_sqlagent_enum_jobs TO RSExecRole

GO

GRANT EXECUTE ON master.dbo.xp_sqlagent_is_starting TO RSExecRole

GO

USE msdb

GO

-- Permissions for SQL Agent SP's

GRANT EXECUTE ON msdb.dbo.sp_help_category TO RSExecRole

GO

GRANT EXECUTE ON msdb.dbo.sp_add_category TO RSExecRole

GO

GRANT EXECUTE ON msdb.dbo.sp_add_job TO RSExecRole

GO

GRANT EXECUTE ON msdb.dbo.sp_add_jobserver TO RSExecRole

GO

GRANT EXECUTE ON msdb.dbo.sp_add_jobstep TO RSExecRole

GO

GRANT EXECUTE ON msdb.dbo.sp_add_jobschedule TO RSExecRole

GO

GRANT EXECUTE ON msdb.dbo.sp_help_job TO RSExecRole

GO

GRANT EXECUTE ON msdb.dbo.sp_delete_job TO RSExecRole

GO

GRANT EXECUTE ON msdb.dbo.sp_help_jobschedule TO RSExecRole

GO

GRANT EXECUTE ON msdb.dbo.sp_verify_job_identifiers TO RSExecRole

GO

GRANT SELECT ON msdb.dbo.sysjobs TO RSExecRole

GO

GRANT SELECT ON msdb.dbo.syscategories TO RSExecRole

GO

|||I'm seeing that i'm not have RsExecRole. If there is something wrong with my installation of RS, or the RS DB? Any one have an idea if I have to create a SQL group and then run the script above?|||Yes, you have to create a role called RsExecRole in ReportServer, ReportServerTempDB, master and msdb.
You probably have it in ReportServer and ReportServerTempDB if you backed up your database and restored it on a new SQL server.

Thanks
Tudor|||Yeeeees. You were right. I created the roles in master and in msdb. Because it was already in RS DB (I restore those DB). After that I executed the script you gave me and that's all.
Thank you
VectorR3|||

Hi,

we have the same error for a scheduled subscription report. when we run the report normally it works

I applied the script but still getting the same error. any idea?

Thanks
Bava

|||I was unable to subscribe to reports and this solved my problem. Thanks for your help.

John Cutsinger
Altegris|||This also solved the problem for me. Thanks!|||

Thanks for the post.. i got the same error and was able to solve it thanks to Tudor

|||

Hi. I am very much having this error, and it doesn't want to go away!

I have the RsExecRole role on all 4 the DB's. It was already there.

I ran your scripts, but still getting the error. I changed the DB owner of my ReportServer$SQL2005 and ReportServer$SQL2005TempDB DB's from my domain administrator to the sa user, which is the user I use in my report's datasource to connect to the DB. Still it doesn't work.

I am quite fedup with this thing now. Spent most of the day on it with no progress.

Any help / tips will be supremely appreciated.

Error Viewing the Execution option of a Report

I select the option execution from a report (it's in properties option) and then raise an error which says An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help

EXECUTE permission denied on object 'xp_sqlagent_notify', database 'mssqlsystemresource', schema 'sys'.

I have full privileges in the DB and I think the report server is well configured. This is happening since I reinstalled all the system (including windows). Any ideas?

I think you would need to grant permissions to SQL Agent stored procedures that Reporting services use. Here is the list from our installation script:

USE master

GO

GRANT EXECUTE ON master.dbo.xp_sqlagent_notify TO RSExecRole

GO

GRANT EXECUTE ON master.dbo.xp_sqlagent_enum_jobs TO RSExecRole

GO

GRANT EXECUTE ON master.dbo.xp_sqlagent_is_starting TO RSExecRole

GO

USE msdb

GO

-- Permissions for SQL Agent SP's

GRANT EXECUTE ON msdb.dbo.sp_help_category TO RSExecRole

GO

GRANT EXECUTE ON msdb.dbo.sp_add_category TO RSExecRole

GO

GRANT EXECUTE ON msdb.dbo.sp_add_job TO RSExecRole

GO

GRANT EXECUTE ON msdb.dbo.sp_add_jobserver TO RSExecRole

GO

GRANT EXECUTE ON msdb.dbo.sp_add_jobstep TO RSExecRole

GO

GRANT EXECUTE ON msdb.dbo.sp_add_jobschedule TO RSExecRole

GO

GRANT EXECUTE ON msdb.dbo.sp_help_job TO RSExecRole

GO

GRANT EXECUTE ON msdb.dbo.sp_delete_job TO RSExecRole

GO

GRANT EXECUTE ON msdb.dbo.sp_help_jobschedule TO RSExecRole

GO

GRANT EXECUTE ON msdb.dbo.sp_verify_job_identifiers TO RSExecRole

GO

GRANT SELECT ON msdb.dbo.sysjobs TO RSExecRole

GO

GRANT SELECT ON msdb.dbo.syscategories TO RSExecRole

GO

|||I'm seeing that i'm not have RsExecRole. If there is something wrong with my installation of RS, or the RS DB? Any one have an idea if I have to create a SQL group and then run the script above?|||Yes, you have to create a role called RsExecRole in ReportServer, ReportServerTempDB, master and msdb.
You probably have it in ReportServer and ReportServerTempDB if you backed up your database and restored it on a new SQL server.

Thanks
Tudor|||Yeeeees. You were right. I created the roles in master and in msdb. Because it was already in RS DB (I restore those DB). After that I executed the script you gave me and that's all.
Thank you
VectorR3|||

Hi,

we have the same error for a scheduled subscription report. when we run the report normally it works

I applied the script but still getting the same error. any idea?

Thanks
Bava

|||I was unable to subscribe to reports and this solved my problem. Thanks for your help.

John Cutsinger
Altegris|||This also solved the problem for me. Thanks!|||

Thanks for the post.. i got the same error and was able to solve it thanks to Tudor

|||

Hi. I am very much having this error, and it doesn't want to go away!

I have the RsExecRole role on all 4 the DB's. It was already there.

I ran your scripts, but still getting the error. I changed the DB owner of my ReportServer$SQL2005 and ReportServer$SQL2005TempDB DB's from my domain administrator to the sa user, which is the user I use in my report's datasource to connect to the DB. Still it doesn't work.

I am quite fedup with this thing now. Spent most of the day on it with no progress.

Any help / tips will be supremely appreciated.

Error Viewing the Execution option of a Report

I select the option execution from a report (it's in properties option) and then raise an error which says An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help

EXECUTE permission denied on object 'xp_sqlagent_notify', database 'mssqlsystemresource', schema 'sys'.

I have full privileges in the DB and I think the report server is well configured. This is happening since I reinstalled all the system (including windows). Any ideas?

I think you would need to grant permissions to SQL Agent stored procedures that Reporting services use. Here is the list from our installation script:

USE master

GO

GRANT EXECUTE ON master.dbo.xp_sqlagent_notify TO RSExecRole

GO

GRANT EXECUTE ON master.dbo.xp_sqlagent_enum_jobs TO RSExecRole

GO

GRANT EXECUTE ON master.dbo.xp_sqlagent_is_starting TO RSExecRole

GO

USE msdb

GO

-- Permissions for SQL Agent SP's

GRANT EXECUTE ON msdb.dbo.sp_help_category TO RSExecRole

GO

GRANT EXECUTE ON msdb.dbo.sp_add_category TO RSExecRole

GO

GRANT EXECUTE ON msdb.dbo.sp_add_job TO RSExecRole

GO

GRANT EXECUTE ON msdb.dbo.sp_add_jobserver TO RSExecRole

GO

GRANT EXECUTE ON msdb.dbo.sp_add_jobstep TO RSExecRole

GO

GRANT EXECUTE ON msdb.dbo.sp_add_jobschedule TO RSExecRole

GO

GRANT EXECUTE ON msdb.dbo.sp_help_job TO RSExecRole

GO

GRANT EXECUTE ON msdb.dbo.sp_delete_job TO RSExecRole

GO

GRANT EXECUTE ON msdb.dbo.sp_help_jobschedule TO RSExecRole

GO

GRANT EXECUTE ON msdb.dbo.sp_verify_job_identifiers TO RSExecRole

GO

GRANT SELECT ON msdb.dbo.sysjobs TO RSExecRole

GO

GRANT SELECT ON msdb.dbo.syscategories TO RSExecRole

GO

|||I'm seeing that i'm not have RsExecRole. If there is something wrong with my installation of RS, or the RS DB? Any one have an idea if I have to create a SQL group and then run the script above?|||Yes, you have to create a role called RsExecRole in ReportServer, ReportServerTempDB, master and msdb.
You probably have it in ReportServer and ReportServerTempDB if you backed up your database and restored it on a new SQL server.

Thanks
Tudor|||Yeeeees. You were right. I created the roles in master and in msdb. Because it was already in RS DB (I restore those DB). After that I executed the script you gave me and that's all.
Thank you
VectorR3|||

Hi,

we have the same error for a scheduled subscription report. when we run the report normally it works

I applied the script but still getting the same error. any idea?

Thanks
Bava

|||I was unable to subscribe to reports and this solved my problem. Thanks for your help.

John Cutsinger
Altegris|||This also solved the problem for me. Thanks!|||

Thanks for the post.. i got the same error and was able to solve it thanks to Tudor

|||

Hi. I am very much having this error, and it doesn't want to go away!

I have the RsExecRole role on all 4 the DB's. It was already there.

I ran your scripts, but still getting the error. I changed the DB owner of my ReportServer$SQL2005 and ReportServer$SQL2005TempDB DB's from my domain administrator to the sa user, which is the user I use in my report's datasource to connect to the DB. Still it doesn't work.

I am quite fedup with this thing now. Spent most of the day on it with no progress.

Any help / tips will be supremely appreciated.

Error Viewing the Execution option of a Report

I select the option execution from a report (it's in properties option) and then raise an error which says An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help

EXECUTE permission denied on object 'xp_sqlagent_notify', database 'mssqlsystemresource', schema 'sys'.

I have full privileges in the DB and I think the report server is well configured. This is happening since I reinstalled all the system (including windows). Any ideas?

I think you would need to grant permissions to SQL Agent stored procedures that Reporting services use. Here is the list from our installation script:

USE master

GO

GRANT EXECUTE ON master.dbo.xp_sqlagent_notify TO RSExecRole

GO

GRANT EXECUTE ON master.dbo.xp_sqlagent_enum_jobs TO RSExecRole

GO

GRANT EXECUTE ON master.dbo.xp_sqlagent_is_starting TO RSExecRole

GO

USE msdb

GO

-- Permissions for SQL Agent SP's

GRANT EXECUTE ON msdb.dbo.sp_help_category TO RSExecRole

GO

GRANT EXECUTE ON msdb.dbo.sp_add_category TO RSExecRole

GO

GRANT EXECUTE ON msdb.dbo.sp_add_job TO RSExecRole

GO

GRANT EXECUTE ON msdb.dbo.sp_add_jobserver TO RSExecRole

GO

GRANT EXECUTE ON msdb.dbo.sp_add_jobstep TO RSExecRole

GO

GRANT EXECUTE ON msdb.dbo.sp_add_jobschedule TO RSExecRole

GO

GRANT EXECUTE ON msdb.dbo.sp_help_job TO RSExecRole

GO

GRANT EXECUTE ON msdb.dbo.sp_delete_job TO RSExecRole

GO

GRANT EXECUTE ON msdb.dbo.sp_help_jobschedule TO RSExecRole

GO

GRANT EXECUTE ON msdb.dbo.sp_verify_job_identifiers TO RSExecRole

GO

GRANT SELECT ON msdb.dbo.sysjobs TO RSExecRole

GO

GRANT SELECT ON msdb.dbo.syscategories TO RSExecRole

GO

|||I'm seeing that i'm not have RsExecRole. If there is something wrong with my installation of RS, or the RS DB? Any one have an idea if I have to create a SQL group and then run the script above?|||Yes, you have to create a role called RsExecRole in ReportServer, ReportServerTempDB, master and msdb.
You probably have it in ReportServer and ReportServerTempDB if you backed up your database and restored it on a new SQL server.

Thanks
Tudor|||Yeeeees. You were right. I created the roles in master and in msdb. Because it was already in RS DB (I restore those DB). After that I executed the script you gave me and that's all.

Thank you

VectorR3|||

Hi,

we have the same error for a scheduled subscription report. when we run the report normally it works

I applied the script but still getting the same error. any idea?

Thanks
Bava

|||I was unable to subscribe to reports and this solved my problem. Thanks for your help.

John Cutsinger
Altegris|||This also solved the problem for me. Thanks!

|||

Thanks for the post.. i got the same error and was able to solve it thanks to Tudor

Error traping in DTS

I am using a DTS for my purpose and I am calling that DTS execution in a stored procedure(using master..xp_cmdshell dtsrun/F).I like to store the error meassage or error description in the Stored Procedure if it fails due to any reason.How can I do that?call the dtsrun also with /L<log file path >|||Will you kindly give me a brief of that please?|||dtsrun gets some arguments the /L <file path > switch "tells" dtsrun where to log it executed steps results
for more info search books online for "dtsrun Utility" there you can find all info about dtsrun.

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 'Server
1'
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 'Server
1'
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 'Server
1'
is
> unavailable.
> I thought that only errors with level 20 to 25 did that.
>
> Ian
>

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.
Ian
Hi,
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
>

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
>