Question on Functions in SQL Server

[EM1107]

Good day everyone. I have started playing with function and I would have a question for the best.

In the past I have created a store procedure to extract the information from a backup dump and use that information to restore the databases. In my function I was using the following command:
RESTORE FILELISTONLY FROM DISK I was taking the information and sending that to a temporary table in order to find out in what order I had to restore my database. I was thinking about making use of a function in order to return the content of the dump file to simplify the procedure and not have to create a temporary table. I would like to know if there is a way I could use a function to perform that task.

Thanks all.

 

[SQLScholar]

sounds to me more like a stored procedure?

Why do you want it as a function?


----------------------------------------

http://www.fountain.me.uk

Be who you are and say what you feel, because those who mind don't matter and those who matter don't mind - Dr. Seuss

Computer Science is no more about computers than astronomy is about telescopes - EW Dijkstra
----------------------------------------