Home Forums SQL Server 7,2000 T-SQL Save result ofa xp_cmdshell command RE: Save result ofa xp_cmdshell command

  • February 13, 2009 at 8:45 am

    #943686

    Thank you this works for me 😀

    Create Table #Output

    (

    Output varchar(150) default('')

    )

    INSERT INTO #Output

    EXECUTE xp_cmdshell 'ping 192.168.10.1'

    SELECT *

    FROM #Output