Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Scripts with tag Search Rss

Search for any content tagged search

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

Add a script

<< Newer    Items 21 to 37 of 37   
 

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,100 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,119 reads

Object Search

Procedure to search any database (or a combination of databases, including all) for a specific string found in column names, object names, and / or object definitions.  Read more...
By Sean Smith 2015/12/23 | Source: SQLServerCentral.com | Category: object
Rating: |  Discuss |   Briefcase | 4,806 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 | 960 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,099 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 | 859 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 2008/10/31 | Source: SQLServerCentral.com | Category: search
Rating: |  Discuss |   Briefcase | 339 reads

Search for objects in a database

Find in a flexible way different type of objects on databases.  Read more...
By Alberto De Rossi 2008/12/02 | Source: SQLServerCentral.com | Category: search
Rating: |  Discuss |   Briefcase | 1,198 reads

The Ultimate Table Searcher

Searches for tables who's names contain the search string. Gives Size and Rows information as well.  Read more...
By Jesse Roberge 2009/10/14 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 2,213 reads

The Ultimate Column Searcher

Searches for columns with names containing @Colname that belong to tables with names containing @TableName or schemas with names containing @SchemaName. Gives size and rowcount for tables.  Read more...
By Jesse Roberge 2009/10/16 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 1,381 reads

Useful Sql Queries

Searching through system tables.  Read more...
By Ashis Das 2008/10/01 | Source: SQLServerCentral.com | Category: search
Rating: |  Discuss |   Briefcase | 2,540 reads

Search word in sps

Get the list of sps or functions having a word e.g. "Return"  Read more...
By Deepa Gheewala 2008/07/17 | Source: SQLServerCentral.com | Category: stored procedures
Rating: |  Discuss |   Briefcase | 325 reads

The Ultimate Foreign Key Researcher

Searches for actual and potential foreign key columns for a given primary key reference.  Read more...
By Jesse Roberge 2009/10/12 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 2,464 reads

The Ultimate Precompiled Procedure Searcher

Searches precompiled procedures for the provided search string, optionally limiting to names matching a 2nd search string.  Read more...
By Jesse Roberge 2009/10/08 | Source: SQLServerCentral.com | Category: sql server 2005
Rating: |  Discuss |   Briefcase | 1,873 reads

Search for a String in all Stored Procedures and beyond?

Search for String Occurence with this script in your stored procedures.  Read more...
By Mani Singh 2011/10/20 | Source: SQLServerCentral.com | Category: search
Rating: |  Discuss |   Briefcase | 4,941 reads

Search for a text in all databases

This procedure searches for a specified text in all (or one selected) databases in all (or selected) tables.  Read more...
By Rafal Skotak 2011/03/02 | Source: SQLServerCentral.com | Category: sql server 2005
Rating: |  Discuss |   Briefcase | 4,831 reads

Find occurence of any value in database!

Search entire database for occurrence of any text!  Read more...
By Reddy Software Solutions 2012/01/09 | Source: SQLServerCentral.com | Category: search
Rating: |  Discuss |   Briefcase | 4,772 reads
<< Newer    Items 21 to 37 of 37