Very timely for me, thank you for the script.

Thanks for noting that Paul.

It would appear that the OP has taken your contribution/comments to heart and (has now) provided the casual reader with some guidance.

In fairness the OP does state: "...Make sure that you understand the implications of this script on the backup and recovery of your database(s): Managing Transaction Logs."

The linked article...

rob-660781 (4/24/2013)

---

Is there a way to modify this to work in SQL 2000? I can get a list of stored procedures by changing sys.objects to sysobjects and removing the modify_date...

My test of the script on SQL 2000 didn't involve huge varbinary or image, hence I didn't look into this further. Regardless, this...

Many thanks to Josep for the effort in creating the script, also to Henrik Staun Poulsen for augmenting the script with "move".

To get Henrik's script working on my...

Here's a reworked script versioned for SQL...

Can this be adapted to handle db's with names that have an embedded space? i.e. "My dbname" The Script works great otherwise.

<Before I get harpooned by anyone...