SQL Server Advanced options... do i need to restart my SQL Server

• Oracle_91

  SSChampion

  Points: 14548

  More actions

  July 19, 2009 at 11:36 am

  #208480

  Hi Pals,

  Do we need to restart SQL Server whenever i turn on any advance option in Surface Area Configuration/sp_configure ???

  Is it required or not?

  Thanks in Advance

• george sibbald

  SSC Guru

  Points: 104210

  More actions

  July 19, 2009 at 12:37 pm

  #1026654

  In most cases no. BOL will tell you which options require a restart.

  ---------------------------------------------------------------------