Hi,

Not sure if this will help, but you should be able to achieve the same thing this way...

CREATE PROCEDURE usp_TestRestore AS

BEGIN

RESTORE FILELISTONLY FROM DISK = 'c:\code3Billing\ClientSQLData\Master\code3billing.bak'

END

GO

IF OBJECT_ID('tempdb..#Restore') IS NOT NULL DROP TABLE #Restore

CREATE TABLE #Restore (

LogicalName NVARCHAR(128),

PhysicalName NVARCHAR(260),

[Type] CHAR(1),

FileGroupName NVARCHAR(128),

Size NUMERIC(20,0),

MaxSize NUMERIC(20,0),

FileID BIGINT,

CreateLSN NUMERIC(25,0),

DropLSN NUMERIC(25,0),

UniqueID UNIQUEIDENTIFIER,

ReadOnlyLSN NUMERIC(25,0),

ReadWriteLSN NUMERIC(25,0),

BackupSizeInBytes BIGINT,

SourceBlockSize INT,

FileGroupID INT,

LogGroupGUID UNIQUEIDENTIFIER,

DifferentialBaseLSN NUMERIC(25,0),

DifferentialBaseGUID UNIQUEIDENTIFIER,

IsReadOnly BIT,

IsPresent BIT,

TDEThumbprint VARBINARY(32)

)

INSERT #Restore

EXEC usp_TestRestore

SELECT * FROM #Restore