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