I use this in my proc:
EXEC xp_cmdshell 'dir \\server3\Diffe rentialArchive'
It returns me a result set Like this:
Volume in drive \\server3\Diffe rentialArchive has no label.
Volume Serial Number is 620-######
NULL
Directory of \\server3\Diffe rentialArchive
NULL
05/24/2007 04:24 PM <DIR> .
05/24/2007 04:24 PM <DIR> .....
Mirover
Last Activity: Jan 1 '08, 08:08 AM
Joined: Jul 11 '07
Location:
-
Give a hand(return value)
-
use file position (restore headeronly)
how can I use the "result set " (fill a temp table) with the returned result set of querys like this : restore filelistonly,re store headeronly
-----------------------------------------------------------------------------
i want to know at least what is the last file position in diffrential backup file
declare @var as int
restore headeronly return me a result set that contains the file position...
No activity results to display