469,622 Members | 1,462 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,622 developers. It's quick & easy.

Give a hand(return value)

I use this in my proc:

EXEC xp_cmdshell 'dir \\server3\DifferentialArchive'

It returns me a result set Like this:

Volume in drive \\server3\DifferentialArchive has no label.
Volume Serial Number is 620-######
NULL
Directory of \\server3\DifferentialArchive
NULL
05/24/2007 04:24 PM <DIR> .
05/24/2007 04:24 PM <DIR> ..
06/01/2007 06:16 AM <DIR> Accon
.
.
.
but it is not worth me a rush , because I should read it by me procedure.
so , how can I fill a temp table with this result set and see what is returned ?
I need the return value.
:(
Jul 14 '07 #1
0 722

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

8 posts views Thread by DaKoadMunky | last post: by
reply views Thread by Bajal Mohamed via SQLMonster.com | last post: by
4 posts views Thread by AssanKhan Ismail | last post: by
5 posts views Thread by Sam | last post: by
8 posts views Thread by gregory_may | last post: by
1 post views Thread by Kermit Piper | last post: by
3 posts views Thread by Atmapuri | last post: by
10 posts views Thread by alij | last post: by
reply views Thread by devrayhaan | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.