November 11, 2008 at 1:42 pm
Just did a number of updates on my workstation that I have been putting off. Some were SQL 2005 patches. All loaded through windows update. Now when I open a new query window in SSMS it automatically has a BEGIN TRAN/ROLLBACK. I am finding this to be a major PITA to constantly have to delete.
Anyone know how I can get back a blank query window functionality instead?
Tim
Denver, CO
December 30, 2008 at 3:28 pm
I have the same problem. Have you found a solution to this problem yet?
thx.
December 30, 2008 at 3:44 pm
No solution yet and no one else seems to have much to say about it. I have just gotten fast at deleting the obnoxious Begin Tran/End Tran that someone thinks is helping me.
Tim
Denver, CO
December 31, 2008 at 12:46 am
What patches did you install? (kb numbers if possible)
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
December 31, 2008 at 2:36 pm
I really don't know. I just accepted a lengthy list of updates that had been pending in the windows updaate for the last month or two.
Tim
Denver, CO
February 16, 2009 at 4:38 am
Hello,
I had the same issue...
Do you have "SSMS Tools Pack" installed ?
It turned out that the "New Query Template" option had somehow been enable and configured.
I disabled it and all was well.
James.
February 16, 2009 at 9:39 am
James,
That seems to be the issue. I do have the SSMS Toolkit installed and as you said, the query template got set to enable. Set it to disable and the issue has disappeared.
Forgot that product even had that ability and crazy that it auto enabled itself. We using it to support regions in some very large procs I was working on. Never used templates, so did not think of looking there.
Thanks!!
Tim
Denver, CO
February 17, 2009 at 12:09 pm
James,
Thumbs up, big man. That issue was annoying the hell out me.
April 27, 2009 at 7:53 am
hey everyone!
i'm the author of the SSMS Tools Pack.
can anyone please provide me with the updates you have installed, the OS version, SQL and SSMS versions and is it a 64 or 32 bit system.
i have never seen this happen and the options shouldn't just reenable themselves.
so it's worth investigating.
Thanx!
Mladen
_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp
SSMS Add-in that does a few things: www.ssmstoolspack.com
April 27, 2009 at 8:30 am
Not sure what patches were applied that caused my issues. But I am on XP Pro Service Pack 2 32 bit. SQL is SQL 2005.
Tim
Denver, CO
April 18, 2012 at 7:59 am
I just acquired this problem in SSMS SS 2008 with Intellisense on. WHERE can I turn it off? It'd driving me crazy.;-)
May 1, 2012 at 6:23 am
If you have the SSMS Tool Pack installed...
1. Open SQL Management Studio
2. Click SSMS Tools
3. Click New Query Template
4. Edit the text in the Template Text window.
5. Click OK
All done!
:exclamation: "Be brave. Take risks. Nothing can substitute experience." :exclamation:
November 22, 2013 at 12:21 pm
I have same problem after SSMS Toolkit, I'm on W7 32 , 2008 R2
August 24, 2014 at 5:37 pm
I have the same isssue. thanks for pointing me out it is from ssms tool.
I don't have it last week, but not sure why it suddenly comes out of this issue.
I am at windows 7, 64 bits
Viewing 14 posts - 1 through 13 (of 13 total)
You must be logged in to reply to this topic. Login to reply