Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Remove auto appearing BEGIN TRAN and ROLLBACK in SQL Server 2008 R2

I want to remove the auto appearing BEGIN TRAN and ROLLBACK in SQL Server 2008 R2.

Here is the following image which I am getting while selecting New Query to write.

enter image description here

like image 776
MAK Avatar asked Dec 15 '22 15:12

MAK


2 Answers

Do you have "SSMS Tools Pack" installed ?

at some times that the "New Query Template" option had somehow been enable and configured.

I think if you disabled it then this should have been removed

like image 177
Dhaval Avatar answered Apr 27 '23 18:04

Dhaval


It's likely because you have SSMS tools installed.

SSMS Tools > New Query Template > Options > Disable

From SSMS Tools site: http://www.ssmstoolspack.com/Features?f=13

Props: http://www.sqlservercentral.com/Forums/Topic1206272-391-1.aspx

like image 33
Phil Walton Avatar answered Apr 27 '23 16:04

Phil Walton