Home Forums SQL Server 7,2000 T-SQL Save result ofa xp_cmdshell command RE: Save result ofa xp_cmdshell command
Steve Jones - SSC Editor
SSC Guru
Points: 734498
More actions
February 12, 2009 at 5:20 pm
#943298
You can insert..exec into a table.
insert MyTable exec xp_cmdshell ''
but you need to match up the result set with the schema correctly