• Olla Hallengren has created some awesome maintenance scripts, you can check it out here: http://ola.hallengren.com/[/url]

    You'll need to schedule the sp's via SQLcmd using the windows task scheduler.

    Rich

    Hope this helps,
    Rich

    [p]
    [/p]