There are other options available like Sql search from Red Gate. Here's a simple script to search for objects(s) containing a particular keyword.
2013-04-15 (first published: 2012-08-23)
2,871 reads
This script quickly returns Server Name, Cluster Node, Default Drive Letter for MSDB database, IP address and port
2013-04-11 (first published: 2013-03-24)
1,483 reads
2013-04-05 (first published: 2009-03-27)
4,616 reads
2013-04-03 (first published: 2013-03-08)
1,723 reads
2013-04-02 (first published: 2008-09-11)
15,409 reads
2013-04-01 (first published: 2013-03-08)
1,819 reads
2013-03-29 (first published: 2013-03-08)
1,452 reads
Get backup status email daily to your inbox in HTML format.
2013-03-27 (first published: 2013-03-14)
2,412 reads
2013-03-26 (first published: 2013-03-15)
807 reads
Check which transactions are running, query text, percent complete , query_plan, wait_type, and how long they have been running etc. - with one command.
2013-03-25 (first published: 2013-03-15)
2,317 reads
By Steve Jones
Next week I’m at VS Live in San Diego (register and join me) and...
Ten years ago today, I filmed a Pluralsight Play by Play on open source...
By Steve Jones
It’s time for T-SQL Tuesday again and this is a great prompt to start...
Telp/WA 62 8218200233 Sudirman Mansion, JL Jenderal Sudirman, Kav. 59 No.77 Lt. G No....
Telp/WA 62 8218200203 Jl. Tebet Raya No.25 B Blok CI, RT.1/RW.2, Tebet Tim., Kec....
Telp/WA 62 8218200174 Setiabudi Atrium, Plaza Setiabudi, Jl. H. R. Rasuna Said No.Kave 62...
I have this data in a table in a SQL Server 2025 database:
EmailAddressID EmailAddress 7 dylan0@ADVENTURE-WORKS.COM 8 Diane1@ADVENTURE-WORKS.COMIf I run this query, which row(s) are returned?
SELECT top 10 * FROM person.EmailAddress WHERE REGEXP_LIKE(EmailAddress, '^d') AND BusinessEntityID IN (7,8)See possible answers