• There's not specifically a builtin script for it, but feel free to write it yourself. It doesn't sound like it should be that difficult. Just off the top of my head I'm thinking it'll involve a couple cursors through the user DBs. But that's without looking into it at all.

    Watch my free SQL Server Tutorials at:
    http://MidnightDBA.com
    Blog Author of:
    DBA Rant – http://www.MidnightDBA.com/DBARant

    Minion Maintenance is FREE: