Faceți căutări pe acest blog

5.9.08

xSQL Object Search

http://www.softpedia.com/get/Internet/Servers/Database-Utils/xSQL-Object-Search.shtml

SQL tool that locates database objects by checking their names and/or definition against a search criteria

xSQL Object Search is a simple tool that provides for locating database objects.

You can search on one or multiple databases simultaneously, select from various search options, search for all or specific objects types, export the results to output files and more.

With xSQL Object Search you will find the items you seek in no time.

xSQL Object Search allows you to search SQL Server 2005 databases for objects that match a search pattern. The pattern you specify is matched against two properties of the database objects: name and definition.

The name of an object is its identifier used when the object is created, it is the same name that appears in the Management Studio object tree.

The definition, for the purpose of the search, is the T-SQL that defines the object. For a stored procedure, for example, the definition is the statement that was used to create the stored procedure.

The definition of an object is not the same as the T-SQL script that can be used to re-create that object. A table, like all database objects, can be created via a T-SQL script, but has no definition in the database.

The following are the database objects that have a definition:
· Views
· Stored Procedures (excluding CLR procedures, which have no definition in the database)
· User-Defined Functions (excluding CLR functions)
· Defaults (both constraints and stand-alone defaults)
· Rules
· DML Triggers (excluding CLR triggers)
· Database DDL Triggers
· Server DDL Triggers