>>We are trying to use SQL Server xp_cmdshell SP to retireve directory information using a 'DIR xxx.*' type command. This returns a result set in Query Analyzer with an nvarchar(255) column named 'output'. However, we have not been able to find documentation on how to run the command in a SP and force the result set into, say, a temporary table in order to manipulate the data. How would this be done?
>>
>>Thanks,
>
>Bill,
>
>I don't see anything either. However, if it's not possible, you could re-direct the output to a text file, and import it into a cursor or temporary table as a workaround.
Hi George,
I guess you saw Sergey's post and my response. There's got to be a way to access the resultant data set in a SP. If I get the answer external to UT, I'll let you know. Thanks for responding.
William A. Caton III
Software Engineer
MAXIMUS
Atlanta, Ga.