Post reply

sp_configure ‘user options’, 2

  • August 19, 2013 at 5:31 pm

    #297123

    Hi,

    I accidentally ran the below command and I do not know what changes this command did.

    sp_configure ‘user options’, 2

    How to roll back the changes?

    Thanks

  • August 20, 2013 at 7:00 am

    #1643052

    sp_configure is used to configure the user options to change the setting for the ANSI_WARNINGS server option.

    You have selected option 2 ..

    2 - IMPLICIT_TRANSACTIONS

    For dblib network library connections, controls whether a transaction is started implicitly when a statement is executed. The IMPLICIT_TRANSACTIONS setting has no effect on ODBC or OLEDB connections.

    ************************************
    Every Dog has a Tail !!!!! :-D

  • August 20, 2013 at 7:15 am

    #1643062

    See url http://technet.microsoft.com/en-us/library/ms190763(v=sql.110).aspx for more explanation on this setting.

    You can use the following code to reset the value to the default 0:

    exec sp_configure 'user options', 0

    reconfigure

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

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

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