tags:

views:

228

answers:

1
Q: 

what's the best way to implement logging during transactions in T-SQL?

I want to implement a simple debug log, which consists of a table into which I insert insightful messages about the current state of a transaction. How do I stop inserts to this table being affected by rollbacks on the transaction that I'm trying to debug? In Oracle I can use PRAGMA AUTONOMOUS_TRANSACTION to ensure that the inserts are done outside of the transaction, but what are my options in T-SQL? How do you implement logging in your shop?

NB: I'm not using SQL Server, I'm using Sybase 12.5.

A: 

Finally tracked down the Sybase manuals on line. According to the documents, it looks like your only way out is to log via RPC to an external log server.

tvanfosson  2008-10-27 00:17:10
I'm not sure that your links work there, the URLs are both the same and it resolves to a description of global variables (at least for me). The advice on the other hand is spot on, sadly.
ninesided  2008-10-27 02:52:10
Stupid frame-based web sites and their broken navigation. I fixed it by changing to a single link to the root of the document tree.
tvanfosson  2008-10-27 02:57:05

related questions

*= in Sybase SQL
sql missing rows when grouped by DAY, MONTH, YEAR
Adapt Replace all strings in all tables to work with text
Can you call a webservice from TSQL code?
How to tell the data types after executing a stored procedure?
C# - SQLClient - Simplest INSERT
SQL Server: Get data for only the past year
Get last item in a table - SQL
Is there a way to make a TSQL variable constant?
Create a database from another database?
SQL Server PIVOT examples?
What are some references, lessons and or best practices for SQL optimization training.
What's a good way to check if two datetimes are on the same calendar day in TSQL?
Trigger without a transaction?
How do I do an Upsert Into Table?
What is the easiest way using T-SQL / MS-SQL to append a string to existing table cells?
How do I avoid using cursors in Sybase (T-SQL)?
Best .NET Solution for Frequently Changed Database
T-Sql date format for seconds since last epoch / formatting for sqlite input
HOWTO - Compare a date string to datetime in SQL Server?
Differences Between MySql and MS SQL
Best method for varchar date validation in Sybase (T-SQL)?
interrogating table lock schemes in T-SQL
Testing for inequality in T-SQL
T-Sql Remove Decimal Point From Money Data Type