SET QUOTED_IDENTIFIER ON

SET ANSI_NULLS ON

GO

create function sys.dm_db_index_physical_stats

(

@DatabaseId SMALLINT = 0,

@ObjectId INT = 0,

@IndexId INT = -1,

@PartitionNumber INT = 0,

@Mode nvarchar(20) = NULL

)

returns table

as

return select * from OpenRowset

(

IndexAnalysis,

@DatabaseId,

@ObjectId,

@IndexId,

@PartitionNumber,

@Mode

)

GO

dm_db_index_physical_stats->OpenRowset