Skip to content

SQL Server Utilities

SQL Server Search
A stored procedure that allows an admin or developer to quickly locate SQL Server objects that contain a word or phrase.

Usage: To find all tables, stored procedures, views and triggers that contain the text EmployeeID, type sch ‘EmployeeID’. Note that this only searches object definitions, not the actual contents of tables or whatnot.

Download SQL Server Search

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: