• To be technical, it is not a DMV you are looking for but a catalog view. (The difference is that a catalog shows information persisted in the system catalog, while the a exposes internal data inside the SQL Server executable, but which is not stored on disk directly.)

    Here is a query:

    SELECT t.name, ds.name

    FROM sys.tables t

    JOIN sys.data_spaces ds ON t.filestream_data_space_id = ds.data_space_id

    ORDER BY t.name

    [font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]