Capture execution of stored procedure in SQL Server Posted on November 13, 2009 by trailmax create table #table(text nvarchar(200)) insert #table EXEC master..xp_cmdshell 'dir *.exe' select * from #table