SQLServerCentral.com Content tagged T-SQL, Search

Search for a Value Throughout Your Database

Thu, 14 Mar 2013 06:00:00 UT

Learn how to search for a value throughout all database tables.

Find occurence of any value in database!

Mon, 09 Jan 2012 07:00:00 UT

Search entire database for occurrence of any text!

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 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 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 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.

Get alerts within 15 seconds of SQL Server issues
SQL Monitor checks performance data every 15 seconds, so you can fix issues before your users even notice them. Start monitoring with a free trial.

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.

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.

How to automate your .NET and SQL Server deployments
Deploy .NET code and SQL Server databases in a single repeatable process with Red Gate Deployment Manager. Start deploying with a 28-day trial

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 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.

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.

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.