• When I try to execute

    select object_name(object_id),

     index_id,

     index_type_desc,

     avg_fragmentation_in_pct

    from sys.dm_db_index_physical_stats(db_id(),null,null,null,'limited')

    on my server, I get the following error:

    Server: Msg 102, Level 15, State 1, Line 5

    Incorrect syntax near '('.

    Anybody else having this problem?  If you can, please reply to bscrivener@hcad.org.  Thanks.