sp_configure ‘user options’, 2

• gary1

  SSC-Insane

  Points: 21152

  More actions

  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

• OnlyOneRJ

  Hall of Fame

  Points: 3894

  More actions

  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

• HanShi

  SSC-Dedicated

  Points: 33510

  More actions

  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’! **