Capture t-sql error occured in xp_cmdshell

• AK1516

  SSCrazy

  Points: 2705

  More actions

  October 15, 2013 at 11:27 am

  #299986

  Is there a way to capture the t sql error occured while running the tsql script via xp_cmdshell ???

  Help is really appreciated!!

• sestell1

  SSChampion

  Points: 10230

  More actions

  October 15, 2013 at 1:44 pm

  #1658693

  You can capture the output from a command executed with xp_CMDshell by doing something like this:

  DECLARE @CMD VarChar(500)

  DECLARE @Results TABLE

  (

  ID Int Not Null IDENTITY(1,1),

  Line VarChar(256)

  )

  SET @CMD = 'dir C:\'

  INSERT INTO @Results (Line)

  EXEC xp_CMDShell @CMD

  SELECT *

  FROM @Results