Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rahulgoel
Starting Member
1 Post |
 Posted - 2006-09-04 : 12:25:58
|
| Hi,I am having a problem..Problem is : Suppose I have written "Begin Tran A"and executed any sql statement...and forgot to commit..After some time I again written "Begin tran B"and executed one more statement.Now I want to get the list of active transaction with their description.I knw I can get the count of active transactions using "@@trancount"But I want the name as well.So Please help me out. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-09-04 : 12:38:09
|
| I don't think you can. I think the names are stored internally. You can commit or rollback the latest transation without using a name.Peter LarssonHelsingborg, Sweden |
 |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2006-09-05 : 07:10:40
|
| Check out the undocumented DBCC LOG command...I don't know for sure !Harsh AthalyeIndia."Nothing is Impossible" |
|
|
|
|
|
|
Transactions in SQL