I had the joy doing this little exercise last year. There is nothing to complex with this tasks. It is just @#$# work.

Just another thing this script also indicates system databases as not being in used. This can be dangerous if you allow your junior DBA to do database clean ups

This code is great for looking at if the databases are being used at that point in time, if iwant to archive or remove a database from a server I...

Try this I have used it and it does work, but I would suggest testing it first.

All credit should go to the author of this script

Robin Bäck (robin@robbac.com)

*****************************************************

DECLARE@dbVARCHAR(255),

@intervalINT,

@stopatDATETIME,

@totalusersINT,

@reportfileVARCHAR(500)

/*************************************************************************************

**PURPOSE: ...

The links to the Stored Procs are broken. Does anybody stil have the code or a new link to the SP's