Found the solution at:

The following T-SQL code executes the system stored procedure sp_helpfile and stores the result in the table variable @temp.


declare @temp table
    name varchar(255),
    field varchar(255),
    filename varchar(255),
    filegroup varchar(255),
    size varchar(255),
    maxsize varchar(255),
    growth varchar(255),
    usage varchar(255)
INSERT @temp  Exec sp_helpfile;
select * from @temp;

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.