INSERTS that will STAY after a ROLLBACK is issued

By well0549, 2013/05/23

Sometimes it is usefull to log stuff in SQL server while stored procs are running. If a long stored proc runs you sometimes want to be able to log a message in a loggin file. But what if a rollback occurs.... The message is lost as well.

Here is a method to set up a seperate connection to SQL inside TSQL and log those messages......

Had a discussion a while ago about this but this solution never popped up.....

Run this script and be amazed.........

Total article views: 703 | Views in the last 30 days: 1

FORUM

Table Design for storing xml message

--xml message--

FORUM

Linked Server Error Message

FORUM

Hide Report Generation message

FORUM

Msg vs Message

Error message format

FORUM

Xp_cmdshell failure message

Xp_cmdshell Message

Join the most active online SQL Server Community

SQL knowledge, delivered daily, free:

Email address:

You make SSC a better place

As a member of SQLServerCentral, you get free access to loads of fresh content: thousands of articles and SQL scripts, a library of free eBooks, a weekly database news roundup, a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals that makes it such a success.

Join us!

Steve Jones
Editor, SQLServerCentral.com

INSERTS that will STAY after a ROLLBACK is issued

Table Design for storing xml message

Linked Server Error Message

Hide Report Generation message

Msg vs Message

Xp_cmdshell failure message

Join the most active online SQL Server Community

SQL knowledge, delivered daily, free:

You make SSC a better place

Already a member? Jump in: