Post reply

In Query Editor only commit when I execute commit command

  • April 27, 2011 at 2:23 am

    #237213

    I want to make my query editor as non comitted permanently, only commit when I execute commit command.

    Thanks

  • April 27, 2011 at 2:29 am

    #1316408

    Run the below query for the database you want

    SET IMPLICIT_TRANSACTIONS ON

    Ryan
    //All our dreams can come true, if we have the courage to pursue them//

  • April 27, 2011 at 2:33 am

    #1316409

    In SSMS under the Tools->Options->Query Execution->SQL Server->ANSI

    You can check the IMPLICIT_TRANSACTIONS

    Ryan
    //All our dreams can come true, if we have the courage to pursue them//

  • April 27, 2011 at 2:41 am

    #1316414

    Thanks it works...,

    Thanks

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

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