Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Use AdventureWorks2014;
- Select OBJECT_SCHEMA_NAME(PA.object_id) + N'.' + OBJECT_NAME(PA.object_id) As ObjectName,
- DF.name As FileName,
- PA.allocation_unit_type_desc As TypeData,
- PA.allocated_page_file_id As FileID,
- PA.allocated_page_page_id As PageID
- From sys.dm_db_database_page_allocations(db_id(), null, 1, null, 'limited') PA
- Inner Join sys.database_files DF On DF.file_id = PA.allocated_page_file_id
- Order By PA.object_id;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement