Search For Object in The DB

LogicDissector — Wed, 22 Aug 2012 14:11:20 GMT

Originally posted on: http://geekswithblogs.net/LogicDissector/archive/2012/08/22/search-for-object-in-the-db-again.aspx

So this is my first blog post and I will keep things short and simple. Actually I will apply this to all my posts; short, simple, and concise.

Ever wanted to search your database for a piece of text? It might be a table name , stored proc, or even a funtion. Many Developers have several ways to get around this, I will be sharing a tool I recently discovered which accomplishes this job very quickly and efficiently.

SQL Search is a tool by Red-Gate that intergrates into SQL Server Management Studio and allows you to search through objects. Once installed it should show on SSMS. You can specify the type of object you want to search in i.e Tables, Stored procs e.t.c. It also allows you to Choose the Database and Server.
The picture below shows an example. I have searched for the substring "user" in all my TABLES under the ASPNETDB.MDF database.

As you can see the result is quite detailed since it shows the object name and where the match occurs e.g column. If you are sold here is the download link SQL Search download
I hope this will help you save a lot of time.

Code Slave

Search For Object in The DB