March 12, 2009 at 12:36 pm
Hello,
We use the SQL Server 2005 Management Studio to process data for our business. We use Read Committed transactions when we are performing risky or novel modifications to data, so we can verify our changes before committing the tran.
The problem is that occasionally, a user will open a transaction and then get distracted or pulled away, or maybe just go home for the night, and inadvertently leave the transaction open, which can hold locks on critical tables during maintenance or standard processing, obviously causing a variety of problems.
I'm trying to find a way to visually alert the user that he has an open transaction in the session. Ideally, something like the screen background would change color as soon as the begin tran command is sent, and then back to the default color when it is committed or rolled back. I know that SSMS is aware of transaction status in a session, because if you try to close a query window with an open transaction, it asks you what you want to do with the tran. So I figure there's got to be a way to hook in to this and modify the screen background, but I can't find anything besides some transaction status classes.
Has anyone done this sort of thing before, or can anyone point me in the right direction to look? Many TIA!
Richard
March 12, 2009 at 2:23 pm
Only way I can think of doing it by means of an add-in but my .NET skills are hmm .. well I don't have :hehe:. IF you find a way please post here; as I know few developers it will save me from.
Thanks.
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply