Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Scripts with tag Search Rss

Search for any content tagged search

Add a script

   Items 1 to 20 of 30    Next 20 >>
 

Locate a column across databases

This utility will locate a column across a subset or all databases across a server. Can be configured to run across versions, and can search tables, views or both.  Read more...
Rating: |  Discuss |   Briefcase | 215 reads

Search all stored procedures on all databases

Need to find every stored procedure in any database that references the table FooBar? Here is a quick and easy search to do that.  Read more...
By Jim Youmans 2013/05/30 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,048 reads

Query all objects created or modified after specified date

This script will query across all databases, returning a result of objects recently created or modified.  Read more...
By Eric Russell 2012/12/21 | Source: SQLServerCentral.com | Category: objects
Rating: |  Discuss |   Briefcase | 1,313 reads

Search for String in all columns

Find all columns containing a string value across all tables and schemas.  Read more...
By Wes Henriksen 2012/11/07 | Source: SQLServerCentral.com | Category: search
Rating: |  Discuss |   Briefcase | 1,429 reads

sp_Find2

Searches database for up to 4 keywords. It will search through SPs, UDFs, Triggers, SSIS packages, jobs, table names, and column names.  Read more...
By Said Khorramshahgol 2012/05/10 | Source: SQLServerCentral.com | Category: search
Rating: |  Discuss |   Briefcase | 1,837 reads

String Search

Search for a string value within columns of data types CHAR, NCHAR, NTEXT, NVARCHAR, TEXT, VARCHAR, XML.  Read more...
By Sean Smith 2012/04/09 | Source: SQLServerCentral.com | Category: string
Rating: |  Discuss |   Briefcase | 1,786 reads

A google like search

A conceptual proof for a google like search procedure  Read more...
By Jean Bulinckx 2012/02/02 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 3,082 reads

Searching through SPs, Tables, Views

Find quickly all stored procedures, tables and views that are somehow related to the search term.  Read more...
By Jano Petras 2011/02/09 | Source: SQLServerCentral.com | Category: search
Rating: |  Discuss |   Briefcase | 2,595 reads

Find a string in database objects

A very simple way to find a string in database objects and see where it is located in object definition.  Read more...
By Laurent Michaud 2010/06/21 | Source: SQLServerCentral.com | Category: string match
Rating: |  Discuss |   Briefcase | 2,665 reads

Search all tables for text

This script will help you search all tables for a specific set of text.  Read more...
By Luis Chiriff 2010/02/15 | Source: SQLServerCentral.com | Category: search
Rating: |  Discuss |   Briefcase | 2,627 reads

Search all columns in every table for a value

This script allows a user to search every field in a database for a specified value - handy when knowing the data but not the schema.  Read more...
By Michael Davis 2010/11/09 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 4,355 reads

Search in your T-SQL objects

This procedure searches for your criteria not only in code, but also in objectnames  Read more...
By Wilfred van Dijk 2009/11/16 | Source: SQLServerCentral.com | Category: search
Rating: |  Discuss |   Briefcase | 1,024 reads

The Ultimate Index-Less Foreign-Key Finder

Searches for foreign key constraints that don't have fully matching indexes. The best partial matching indexes are outputted with MatchCounts and column comparisons.  Read more...
By Jesse Roberge 2009/10/15 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 1,259 reads

Search a particular text string in all SPs

An easy method to search inherited SP codes for a particular text  Read more...
By Jason S Wong 2009/10/23 | Source: SQLServerCentral.com | Category: search
Rating: |  Discuss |   Briefcase | 1,047 reads

The Ultimate Object Searcher

Searches for objects (including CLR) who's names contain the search string. outputs IDs, names, and types of the object and its parent.  Read more...
By Jesse Roberge 2009/10/06 | Source: SQLServerCentral.com | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,050 reads

Object Search

Search any database (or a combination databases, including all) for a specific string found in column names, object names, and /or object definitions.  Read more...
By Sean Smith 2011/10/19 | Source: SQLServerCentral.com | Category: object
Rating: |  Discuss |   Briefcase | 2,468 reads

search every database on server from a single sp

i have recently had the need to search the every database on the server for a particular string. i came up with this... it has lots of room for improvement but it works  Read more...
By Chris Morton 2008/12/19 | Source: SQLServerCentral.com | Category: search
Rating: |  Discuss |   Briefcase | 944 reads

The Ultimate PK-Less / CLIDX-Less Table Finder

Lists Schema/Object of tables that are missing a Primary Key or Clustered Index, along with aggregate data for size, rows, indexes, and columns.  Read more...
By Jesse Roberge 2009/10/02 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 1,073 reads

The Ultimate Table Searcher Mk2

Searches for tables who's names contain the search string. Gives Aggregate Size, Rows, Index, and Column information as well.  Read more...
By Jesse Roberge 2009/10/20 | Source: SQLServerCentral.com | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 828 reads

Find a string in compiled objects

This utility will find strings in procedures, functions, views, and even check constraints.  Read more...
By David Korb 2013/06/18 | Source: SQLServerCentral.com | Category: search
Rating: |  Discuss |   Briefcase | 298 reads
   Items 1 to 20 of 30    Next 20 >>