Sql Search Tool#

I have always been a Sql junkie. Analyzing data was one of the things that I enjoy alot...

Sometimes this task also involves writing gargantuan scripts.. and that is where the problem starts. Finding what stored procedure or view that uses a specific table could give you a hard time since SQL server doesn't have a feature that enables you to look at each and every stored procedure and view. usually when this problem arises we tend to open each and every script that we could think of(when this happens i usually script my database, open the generated .sql file in note pad and start using the Find function to search for the table/view name).

Pretty tough huh?! an easier approach is to use MS SQL Search from the guys at CodeAlchemy. The tool is a WinForm application that enables you to do a quick search on your database(much like google desktop except that this is for db). Impressive. Cool. Nice!

Check it out here.

Thursday, October 19, 2006 10:20:51 PM (GMT Daylight Time, UTC+01:00) #    Comments [0]  | 

 

All content © 2010, Keith Rull
On this page
This site
Calendar
<October 2006>
SunMonTueWedThuFriSat
24252627282930
1234567
891011121314
15161718192021
22232425262728
2930311234
Archives
Sitemap
Blogroll OPML
Disclaimer

Powered by: newtelligence dasBlog 2.3.9074.18820

The opinions expressed herein are my own personal opinions and do not represent my employer's view in any way.

Send mail to the author(s) E-mail

Theme design by Jelle Druyts


Pick a theme: