Remove automatic appearance of BEGIN TRAN and ROLLBACK in SQL Server 2008 R2

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.

enter image description here

+4
source share
2 answers

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

+8
source

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

+3

All Articles