I need the syntax for using the sp_XPCommand .....

• mw_sql_developer

  SSCoach

  Points: 19445

  More actions

  March 10, 2015 at 6:48 am

  #315356

  The following just works fine at the command prompt.

  osql -E -S "SERVER.edu" -d "DBNAME" -i "E:\ACRC443\event_echo_1\event_echo_ins_1_1.sql"

  However can someone help me with the syntax so that I can run directly from SSMS please ?

• idpain73

  Newbie

  Points: 1

  More actions

  March 10, 2015 at 9:23 am

  #1782971

  See MS article:

  https://msdn.microsoft.com/en-us/library/ms175046.aspx

  What are you trying to achieve?

• Emil B

  SSCertifiable

  Points: 5659

  More actions

  March 10, 2015 at 9:59 am

  #1782976

  You need these options on to use xp_cmdshell

  EXEC sp_configure 'show advanced options', 1

  RECONFIGURE

  EXEC sp_configure 'xp_cmdshell', 1

  RECONFIGURE

  EXEC xp_cmdshell 'osql -E -S "SERVER.edu" -d "DBNAME" -i "E:\ACRC443\event_echo_1\event_echo_ins_1_1.sql" '