I want to remove the automatically occurring BEGIN TRAN and ROLLBACK in SQL Server 2008 R2.
Here is the following image that I get when choosing New Query for recording.
Is the SSMS tool package installed?
in some cases, the New Request Template option was somehow enabled and configured.
I think that if you disabled it, it should have been removed
Probably because you have SSMS tools installed.
SSMS Tools> New Query Template> Options> Disable
SSMS Tools: http://www.ssmstoolspack.com/Features?f=13
: http://www.sqlservercentral.com/Forums/Topic1206272-391-1.aspx