April 21, 2018 at 11:10 am
Good Morning Experts,
A user typed "begin transaction" and went home. Will this have any affect on the log file(.ldf file). Will it cause any issues. Will it impact anything? Please let me know
April 22, 2018 at 2:22 pm
coolchaitu - Saturday, April 21, 2018 11:10 AMGood Morning Experts,
A user typed "begin transaction" and went home. Will this have any affect on the log file(.ldf file). Will it cause any issues. Will it impact anything? Please let me know
Most likely, it'll affect your career for allowing users to have such access to the database. 😀
The answer is a possible "yes" to all you've stated and more. It depends on what they were actually doing within the transaction. Things like this deserve a phone call to that person and their boss to find out if you can kill the SPID if it starts causing issues.
--Jeff Moden
April 23, 2018 at 2:24 am
Did they run anything else when they did it as well? Running an INSERT statement afterwards and leaving it in situ is going to be more problematic than simply opening a query window with BEGIN TRANSACTION and nothing else.
Like Jeff said though, this is definitely something that deserves a further conversation with the member of staff; they should understand the implications of their actions if they don't already (and if they do understand the implications, they why on earth did that do it?).
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
April 23, 2018 at 2:33 am
Thom A - Monday, April 23, 2018 2:24 AMDid they run anything else when they did it as well? Running an INSERT statement afterwards and leaving it in situ is going to be more problematic than simply opening a query window with BEGIN TRANSACTION and nothing else.Like Jeff said though, this is definitely something that deserves a further conversation with the member of staff; they should understand the implications of their actions if they don't already (and if they do understand the implications, they why on earth did that do it?).
They simply opened a query window with BEGIN TRANSACTION and nothing else.
April 23, 2018 at 3:04 am
coolchaitu - Monday, April 23, 2018 2:33 AMThom A - Monday, April 23, 2018 2:24 AMDid they run anything else when they did it as well? Running an INSERT statement afterwards and leaving it in situ is going to be more problematic than simply opening a query window with BEGIN TRANSACTION and nothing else.Like Jeff said though, this is definitely something that deserves a further conversation with the member of staff; they should understand the implications of their actions if they don't already (and if they do understand the implications, they why on earth did that do it?).
They simply opened a query window with BEGIN TRANSACTION and nothing else.
Did they actually *execute* that command?
Thomas Rushton
blog: https://thelonedba.wordpress.com
April 23, 2018 at 4:45 am
ThomasRushton - Monday, April 23, 2018 3:04 AMcoolchaitu - Monday, April 23, 2018 2:33 AMThom A - Monday, April 23, 2018 2:24 AMDid they run anything else when they did it as well? Running an INSERT statement afterwards and leaving it in situ is going to be more problematic than simply opening a query window with BEGIN TRANSACTION and nothing else.Like Jeff said though, this is definitely something that deserves a further conversation with the member of staff; they should understand the implications of their actions if they don't already (and if they do understand the implications, they why on earth did that do it?).
They simply opened a query window with BEGIN TRANSACTION and nothing else.
Did they actually *execute* that command?
Yes sir
April 23, 2018 at 7:43 am
coolchaitu - Monday, April 23, 2018 4:45 AMThomasRushton - Monday, April 23, 2018 3:04 AMcoolchaitu - Monday, April 23, 2018 2:33 AMThom A - Monday, April 23, 2018 2:24 AMDid they run anything else when they did it as well? Running an INSERT statement afterwards and leaving it in situ is going to be more problematic than simply opening a query window with BEGIN TRANSACTION and nothing else.Like Jeff said though, this is definitely something that deserves a further conversation with the member of staff; they should understand the implications of their actions if they don't already (and if they do understand the implications, they why on earth did that do it?).
They simply opened a query window with BEGIN TRANSACTION and nothing else.
Did they actually *execute* that command?
Yes sir
That probably didn't cause a problem because nothing was locked by that. However, that's some pretty irresponsible action on the part of the user and they should either be seriously recalibrated or their privs should be taken away until they can demonstrate some responsibility.
Ok... so you went through the whole weekend with this.... and I have some questions.
1. How did you find that the user did this and that nothing else was executed?
2. What actually happened to your system because of this? I'm thinking that nothing different happened but I'd like to know your findings especially when it comes to the transaction log.
3. If the user only executed BEGIN TRANSACTION and then nothing else, why didn't you just kill their SPID to make sure?
--Jeff Moden
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply