mmmm Nice tidy interface

Oh my!!! A sense of accomplishment. Now I can do just about anything with my indexes, schedule rebuild, monitor changes, create an alert if the delta is out of line.

DECLARE @return_value int,
@ErrorMsg varchar(4000)

EXEC @return_value = [dbo].[sp_IndexMaintenance]
@DBName = N'MyDB',
@ViewType = N'',
@Rebuild_CIX = 0,
@Rebuild_NCIX = 1,
@Rebuild_ViewExecuteLoad = 'LOAD',
@Rebuild_UsingLast = 0,
@MinRows = 1,
@MaxRows = 1000000,
@MinFragPercent = 3,
@MaxFragPercent = 90,
@MinDensity = 1,
@MaxDensity = 90,
@ErrorMsg = @ErrorMsg OUTPUT

Comments :

0 comments to “mmmm Nice tidy interface”