Monday, December 15, 2008

SQL Server 2005 search in objects

Anyone who works with SQL Server has most likely run into a situation where searching all SQL Server 2005 objects like views, stored procedures, triggers etc. for the existence of a given string is necessary. So what's the best way to do it? There is a cool, free tool by xSQL Software called xSQL Object Search that allows the user to search for a given string into all objects (you can choose to search in the object names, object definitions or both and you can search in one database or all the databases in a SQL Server at the same time.

Supports: SQL Server 2005 and SQL Server 2008
Price: Free
Download page: http://www.xsql.com/download/
Product page: http://www.xsql.com/products/sql_server_object_search/

What is this blog about?

The aim of this blog is to provide direct answers to specific SQL Server related questions that people search for on google. Every blog entry will tackle a specific question exactly as it was asked / searched for on google.