469,275 Members | 1,567 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

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

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,restore 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

set @var = --what should be here ?(related to restore headeronly)

restore database tdb
from disk = 'E:\TDB200728.sbk'
with recovery
,file = @var
Jul 11 '07 #1
0 1113

Post your reply

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

Similar topics

2 posts views Thread by Kevin Zhou | last post: by
1 post views Thread by Bob Powell | last post: by
1 post views Thread by Bryan | last post: by
5 posts views Thread by Brian Cryer | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.