Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
Scripts with tag
Search
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...
By
Douglas Osborne
2013/06/18
|
Source:
SQLServerCentral.com
|
Category:
utility
|
SQL Scripts Manager Compatible
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 >>
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.