Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

INSERTS that will STAY after a ROLLBACK is issued

By well0549,

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: 713 | Views in the last 30 days: 1
 
Related Articles
FORUM

Table Design for storing xml message

--xml message--

FORUM

Linked Server Error Message

Linked Server Error Message

FORUM

Hide Report Generation message

Hide Report Generation message

FORUM

Msg vs Message

Error message format

FORUM

Xp_cmdshell failure message

Xp_cmdshell Message

 
Contribute