why i can't run this syntax

• Mad-Dog

  SSCertifiable

  Points: 6117

  More actions

  July 21, 2008 at 2:21 pm

  #191376

  Hi,

  i want to check if the xp_cmdshell option not on then start it.

  so i write this syntax and i get an error.why?

  THX

  if not exists (select name from sys.configurations where name = 'xp_cmdshell' and value_in_use = 1)

  (

  EXEC sp_configure 'show advanced options', 1

  RECONFIGURE

  EXEC sp_configure 'xp_cmdshell', 1

  RECONFIGURE

  )

• Kyle Neier ,

  SSCrazy

  Points: 2252

  More actions

  July 21, 2008 at 2:27 pm

  #846010

  Try replacing your parentheses with BEGIN and END around your statement block...

  http://msdn.microsoft.com/en-us/library/ms182717.aspx

• Perry Whittle

  SSC Guru

  Points: 234013

  More actions

  July 21, 2008 at 3:05 pm

  #846031

  avipenina (7/21/2008)

  ---

  so i write this syntax and i get an error.why?

  THX

  this should do it

  if not exists (select name from sys.configurations where name = 'xp_cmdshell' and value_in_use = 1)

  begin

  EXEC sp_configure 'show advanced options', '1'

  RECONFIGURE

  EXEC sp_configure 'xp_cmdshell', '1'

  RECONFIGURE

  end

  EXEC sp_configure 'show advanced options', '0'

  RECONFIGURE

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

  "Ya can't make an omelette without breaking just a few eggs" 😉

• Mad-Dog

  SSCertifiable

  Points: 6117

  More actions

  July 21, 2008 at 11:25 pm

  #846150

  Thx.