Regarding the recent script I submitted (dropping/recreating all procedures/views) - I made an important oversight.
I neglected to add a CASE statement in order to make sure that the appropriate type of object was being referenced in the DROP statement.
Below is the corrected script:
Drop all connections from a specific database.
2007-10-19 (first published: 2007-07-25)