Forum Replies Created

Viewing post 1 (of 1 total)

  • RE: Running Ola script and getting error

    Try to remove the piece of code in bold:

    EXECUTE dbo.IndexOptimize

    @databases = 'USER_DATABASES', -databasename,

    @FragmentationLow = NULL,

    @FragmentationMedium = 'INDEX_REORGANIZE,INDEX_REBUILD_ONLINE,INDEX_REBUILD_OFFLINE',

    @FragmentationHigh = 'INDEX_REBUILD_ONLINE,INDEX_REBUILD_OFFLINE',

    @FragmentationLevel1 = 5,

    @FragmentationLevel2 = 30,

    @sortinTempdb = 'Y'

Viewing post 1 (of 1 total)