• This looks very interesting (I've not tried it out myself as at time of writting), however isn't it RBAR using the cursor? Or rather DBAD ... Database By Agonising Database! :hehe:

    How long are people finding it takes to run on 2/3/5/10 databases?

    Is there a SET based solution?

    On a similar theme, if you want to search the SQL code within database objects, I can't recommend enough Redgate's SQL Search (tiny SSMS addon)...

    http://www.red-gate.com/products/sql-development/sql-search/[/url]

    Regards,

    - Gavin