Very Good Question... Try this, I have tested it and it works...
DECLARE @exec_str varchar(256)
CREATE TABLE #mytable
(
LogicalName nvarchar(128),
PhysicalName nvarchar(260),
Type char(1),
FileGroupName nvarchar(128),
Size numeric(20,0),
MaxSize numeric(20,0)
)
SET @exec_str = "RESTORE FILELISTONLY FROM DISK = 'F:\MSSQL7\BACKUP\pubs2.bak'"
INSERT #mytable
EXEC(@exec_str)
select *
from #mytable
Thanks,
Tom ;-)