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

Get your favourite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved in your SSC briefcase from the favorites tab.
Download now (direct download link)

Add a script

   Items 1 to 20 of 35    Older >>
 

Search objects in Database

Use this script to search objects in a Database. Also used to check a tables column types and details when no model is accessible. Replace <DATABASENAME> for database name.  Read more...
By bpimenta 2014/04/16 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 568 reads

NameSQLinConfioIgnite

This will name Ignite SQL hashes that have not been named yet, based on the object (or batch) they are within.  Read more...
By Thomas Keller 2014/02/05 | Source: SQLServerCentral.com | Category: performance tuning
Rating: (not yet rated) |  Discuss |   Briefcase | 538 reads

Search Table And Field In All Database And Return Field Value

In this script, we can search a Field and Table in all databases on the server, returning the Field value.  Read more...
By Babak Pirooz 2013/11/15 | Source: SQLServerCentral.com | Category: search
Rating: |  Discuss |   Briefcase | 627 reads

Search Table And Field In All Database And Return Field Value

In this script, we can search a Field and Table in all databases on the server, returning the Field value.  Read more...
By Babak Pirooz 2013/11/15 | Source: SQLServerCentral.com | Category: search
Rating: |  Discuss |   Briefcase | 471 reads

Simplest way to search any string in db objects

Easiest way to search for a string in any object within the database.  Read more...
By Kshitij Satpute 2013/08/08 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 2,060 reads

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 | 1,150 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,446 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,445 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,571 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,946 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 2013/11/28 | Source: SQLServerCentral.com | Category: string
Rating: |  Discuss |   Briefcase | 2,934 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,366 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,637 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,777 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,725 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,400 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,043 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,296 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,064 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,081 reads
   Items 1 to 20 of 35    Older >>