SQLServerCentral.com Scripts tagged Search

Query all objects created or modified after specified date

Fri, 21 Dec 2012 07:00:00 UT

This script will query across all databases, returning a result of objects recently created or modified.

Search for String in all columns

Wed, 07 Nov 2012 07:00:00 UT

Find all columns containing a string value across all tables and schemas.

sp_Find2

Thu, 10 May 2012 06:00:00 UT

Searches database for up to 4 keywords. It will search through SPs, UDFs, Triggers, SSIS packages, jobs, table names, and column names.

String Search

Mon, 09 Apr 2012 06:00:00 UT

Search for a string value within columns of data types CHAR, NCHAR, NTEXT, NVARCHAR, TEXT, VARCHAR, XML.

A google like search

Thu, 02 Feb 2012 07:00:00 UT

A conceptual proof for a google like search procedure

Searching through SPs, Tables, Views

Wed, 09 Feb 2011 07:00:00 UT

Find quickly all stored procedures, tables and views that are somehow related to the search term.

Find a string in database objects

Mon, 21 Jun 2010 06:00:00 UT

A very simple way to find a string in database objects and see where it is located in object definition.

Search all tables for text

Mon, 15 Feb 2010 07:00:00 UT

This script will help you search all tables for a specific set of text.

Search all columns in every table for a value

Tue, 09 Nov 2010 07:00:00 UT

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.

Search in your T-SQL objects

Mon, 16 Nov 2009 07:00:00 UT

This procedure searches for your criteria not only in code, but also in objectnames

The Ultimate Index-Less Foreign-Key Finder

Thu, 15 Oct 2009 06:00:00 UT

Searches for foreign key constraints that don't have fully matching indexes. The best partial matching indexes are outputted with MatchCounts and column comparisons.

Search a particular text string in all SPs

Fri, 23 Oct 2009 06:00:00 UT

An easy method to search inherited SP codes for a particular text

The Ultimate Object Searcher

Tue, 06 Oct 2009 06:00:00 UT

Searches for objects (including CLR) who's names contain the search string. outputs IDs, names, and types of the object and its parent.

Object Search

Wed, 19 Oct 2011 06:00:00 UT

Search any database (or a combination databases, including all) for a specific string found in column names, object names, and /or object definitions.

search every database on server from a single sp

Fri, 19 Dec 2008 07:00:00 UT

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

The Ultimate PK-Less / CLIDX-Less Table Finder

Fri, 02 Oct 2009 06:00:00 UT

Lists Schema/Object of tables that are missing a Primary Key or Clustered Index, along with aggregate data for size, rows, indexes, and columns.

Make working with SQL a breeze
SQL Prompt 5 is the effortless way to write, edit, and explore SQL. It's packed with features such as code completion, script summaries, and SQL reformatting, that make working with SQL a breeze. Try it now.

The Ultimate Table Searcher Mk2

Tue, 20 Oct 2009 06:00:00 UT

Searches for tables who's names contain the search string. Gives Aggregate Size, Rows, Index, and Column information as well.

Find a string in compiled objects

Sat, 01 Nov 2008 02:27:12 UT

This utility will find strings in procedures, functions, views, and even check constraints.

Search for objects in a database

Tue, 02 Dec 2008 07:00:00 UT

Find in a flexible way different type of objects on databases.

The Ultimate Table Searcher

Wed, 14 Oct 2009 06:00:00 UT

Searches for tables who's names contain the search string. Gives Size and Rows information as well.

The Ultimate Column Searcher

Fri, 16 Oct 2009 06:00:00 UT

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.

Useful Sql Quries

Wed, 01 Oct 2008 06:00:00 UT

Searching through system tables.

Search word in sps

Thu, 17 Jul 2008 10:47:34 UT

Get the list of sps or functions having a word e.g. "Return"

The Ultimate Foreign Key Researcher

Mon, 12 Oct 2009 06:00:00 UT

Searches for actual and potential foreign key columns for a given primary key reference.

The Ultimate Precompiled Procedure Searcher

Thu, 08 Oct 2009 06:00:00 UT

Searches precompiled procedures for the provided search string, optionally limiting to names matching a 2nd search string.

Search for a String in all Stored Procedures and beyond?

Thu, 20 Oct 2011 06:00:00 UT

Search for String Occurence with this script in your stored procedures.

Search for a text in all databases

Wed, 02 Mar 2011 07:00:00 UT

This procedure searches for a specified text in all (or one selected) databases in all (or selected) tables.

Find occurence of any value in database!

Mon, 09 Jan 2012 07:00:00 UT

Search entire database for occurrence of any text!