We've written a number of (I think!) handy tools over the past few
months which are available from here: http://www.sqlsoft.co.uk/
Newly released is SQLscripta, which both searches _and_ scripts
sprocs, functions, views and triggers, with searches being performed
across multiple databases - it's quick and makes a great alternative
to trudging through menus in SSMS.
Best Wishes,
Will Alber (SQLsoft).
Just tried SQL Audit, after installing says it's expired and closes -
bad start. Looked promising.
Good spot - I've just uploaded a time-unlimited version of the program
- I had imposed a limit for previous beta testing - this version
should be more RC1 rather than Beta - thanks, and enjoy!