Script to Find String in Database object
Script that searches every object in a database for a specific string.
2016-06-20 (first published: 2016-05-02)
863 reads
Script that searches every object in a database for a specific string.
2016-06-20 (first published: 2016-05-02)
863 reads
Return a list of databases which contain a table from wildcard table name.
2014-05-05 (first published: 2014-04-14)
1,143 reads
Find all columns containing a string value across all tables and schemas.
2012-11-07 (first published: 2012-10-12)
1,853 reads
Search for a string value within columns of data types CHAR, NCHAR, NTEXT, NVARCHAR, TEXT, VARCHAR, XML.
2019-04-15 (first published: 2012-03-19)
6,358 reads
2010-02-15 (first published: 2010-01-18)
18,072 reads
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.
2019-04-15 (first published: 2009-04-29)
4,945 reads
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2004-10-11
You're a legend. Server had set up permissions on the security section but not the actual permission for the SQL login.Thanks, it works perfectly now
2004-09-05
I am Sorry....... The table has two fields; Last Name, First Name.In the view I want Last name and first name into one field.Thanks
2004-09-03
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2004-09-03
By Steve Jones
Note: I DO NOT recommend this. Any changes to a pipeline should be in...
By Steve Jones
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...
I recently received a complaint that Query Store for a particular database was turned...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers