issue w/ default begin tran and rollback when opening new window in ssms

  • I'm just started working at this place and there must be some setting on the ssms that they set up on my box.

    Whenever i open a new window for querying it already has the below in it. It's rather annoying. Anyone know how i can ensure this doesnt happen?

    BEGIN TRAN

    ROLLBACK

  • It looks like you have SSMS tools installed.

    This is a free download:

    http://www.ssmstoolspack.com/

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

  • captcooldaddy (11/15/2011)


    I'm just started working at this place and there must be some setting on the ssms that they set up on my box.

    Whenever i open a new window for querying it already has the below in it. It's rather annoying. Anyone know how i can ensure this doesnt happen?

    BEGIN TRAN

    ROLLBACK

    SSMS Tools -> New Query Template -> Options -> Disable


    Alex Suprun

  • Alexander Suprun (11/15/2011)


    captcooldaddy (11/15/2011)


    I'm just started working at this place and there must be some setting on the ssms that they set up on my box.

    Whenever i open a new window for querying it already has the below in it. It's rather annoying. Anyone know how i can ensure this doesnt happen?

    BEGIN TRAN

    ROLLBACK

    SSMS Tools -> New Query Template -> Options -> Disable

    It's good in a way, you will harm less to your DB. Unwanted changes will be rolled back, even if you miss on it.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply