Extremely useful stored procedure template that enables searching through every module definition and the names of every table, column, view, procedure, function, synonym, foreign key, and data type within every database on a SQL Server database server in seconds. Outputs module definitions to SSMS Messages window from where it can be copied/pasted unmodified into a query window for execution.

Search Databases Template

Tags: SQL Server

---