How find open transaction statements?

Question

Post reply

How find open transaction statements?

Viewing 7 posts - 16 through 21 (of 21 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

Dave Ballantyne (9/16/2010)
SureshS_DBA (9/16/2010)
Thanks for a long followup Gail....
That was unnecessary.

Huh?

Not sure how it was intended, but I read that as genuine thanks for a long thread.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Dave Ballantyne SSC-Dedicated Points: 33667 More actions · Answer 2

Maybe my glass is half empty , but i read that with a heavy dose of sarcasm.

Apologies to SureshS_DBA if i read wrong.

Clear Sky SQL
My Blog[/url]

S_Kumar_S SSCrazy Eights Points: 9037 More actions · Answer 3

Sure it was a thanks with all my sincerity..Thats my poor writing skills if I appeared sarcastic anywhere 🙂

Online Trainer For SQL DBA and Developer @RedBushTechnologies with 18 yrs exp.

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 4

SureshS_DBA (9/16/2010)
Thats my poor writing skills if I appeared sarcastic anywhere 🙂

It's easy to misread tone on the forums. I'll apologise on Dave's behalf, I'm sure he will as soon as he returns.

It's just that we've had a number of really insulting, rude posts in the last week or so, I think it's making people see sarcasm where it isn't.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Dave Ballantyne SSC-Dedicated Points: 33667 More actions · Answer 5

Dave Ballantyne (9/16/2010)
Maybe my glass is half empty , but i read that with a heavy dose of sarcasm.
Apologies to SureshS_DBA if i read wrong.

Already have done , 🙂

This is the big downside to online forums , all sense of tone is lost , and it can be easy to get the "wrong end of the stick".

Anyway, apologies again.

Clear Sky SQL
My Blog[/url]

S_Kumar_S SSCrazy Eights Points: 9037 More actions · Answer 6

Thats okay Gail/Dave.....it does happen....

Online Trainer For SQL DBA and Developer @RedBushTechnologies with 18 yrs exp.

Nahid-430991 SSC Enthusiast Points: 141 More actions · Answer 7

have you resolved this issue? I use monitoring tool that collect history of transaction, but tht can't be the case in all environment.

Nahid