access to xp_cmd results

[SimonTheSponge]

Is there any way to programmatically access the results of the executing an xp_cmdshell 'dir '. I receive a very nice resulting 1 column cursor containing lots of information including all my files and the details of each file, but I woiuld like to be able to fetch through this cursor to process the results. Is there any way that I can do this ?

 

[dbomrrsm]

create table #DIR (comments varchar (200))
declare @SQL nvarchar(50)
set @SQL = N'xp_cmdshell ''dir '''
print @SQL
insert into #DIR exec sp_executesql @SQL

select * from #dir

[blue]DBomrrsm[/blue]

[blue]Software code, like laws and sausages, should never be examined in production[/blue][black] - [/black][purple]Edward Tenner[/purple]

 

[SimonTheSponge]

Cheers dbo, that's just the ticket