Saturday, March 5, 2011

~: M H O :~ IT Info - Easy, Free Tool to Search SQL Database- SQL Search 1.0



SQL Search 1.0

Search within SQL Server database schemas



http://goput.it/str/ky2.jpg

SQL Server developers and DBAs use SQL Search to:

  • Find fragments of SQL text within stored procedures, functions, views and more
  • Quickly navigate to objects wherever they happen to be on a server
  • Find all references to an object

SQL Search is an add-in for SQL Server Management Studio that lets you quickly search for SQL across your databases.

SQL Search will eventually become part of SQL Prompt. When this happens, the free version of SQL Search will continue to work without issue.


Why use SQL Search?

  • Impact Analysis
    You want to rename one of your table columns but aren't sure what stored procedures reference it. Using SQL Search, you can search for the column name and find all the stored procedures where it is used.
  • Work faster
    Finding anything in the SSMS object tree requires a lot of clicking. Using SQL Search, you can press the shortcut combo, start typing the name, and jump right there.
  • Make your life easier
    You need to find stored procedures you've not yet finished writing. Using SQL Search, you can search for stored procedures containing the text 'TODO'.
  • Increase efficiency, reduce errors
    You are a DBA, and developers keep using 'SELECT *' in their views and stored procedures. You want to find all these and replace them with a correct list of columns to improve performance and prevent future bugs. Using SQL Search, you can look for 'SELECT *' in the text of stored procedures and views.

http://goput.it/str/44c.gif




__._,_.___


Visit Our WebSite : http://www.MumbaiHangout.Org
                  : http://www.mastchulbule.com/

Our Friends Network: http://www.nayidosti.com/home.php

To Subscribe Get Emails from us click http://groups.yahoo.com/subscribe/MumbaiHangOut

------------------
DISCLAIMER :
------------------
This message serves informational purposes only and should not be viewed as an irrevocable indenture between anyone. If you have erroneously received this message, please delete it immediately and notify the sender at MumbaiHangOut-Owner@yahoogroups.com. The recipient acknowledges that any views expressed in this message are those of the Individual sender and no binding nature of the message shall be implied or assumed unless the sender does so expressly with due authority of The M.H.O. Group. M.H.O. reserves the right to repeal, change, amend, modify, add, or withdraw the contents herein without notice or obligation.
---------------------------------------------------
Note:- MHO is Not Responsible For Any Claims.
---------------------------------------------------




Your email settings: Individual Email|Traditional
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Daily Digest | Switch to Fully Featured
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe

__,_._,___

0 comments:

Post a Comment