Home Forums Article Discussions Article Discussions by Author Discuss content posted by Arun Kumar Defragmenting and rebuilding indexes RE: Defragmenting and rebuilding indexes

  • January 9, 2013 at 5:32 am

    #1575191

    ssaari (8/26/2009)

    When I ran the script, I received this error:

    Msg 102, Level 15, State 1, Line 27

    Incorrect syntax near '('.

    Line 27:

    FROM sys.dm_db_index_physical_stats (DB_ID(), NULL, NULL, NULL, 'LIMITED') AS i

    Please help.

    Thanks.

    Scott

    If you are using SQL 2000 (80) the script fail with this message. The same problem appears in 2005 when the master db is in level 80, may be because its a server has been updated in place from a 2000.