Technical Article

SP to find text in code objects in all user db's.

This script creates a stored procedure which helps to find text in all of your code objects in all your databases. It searches the code of SP's, UDF's, views, triggers, and it searches in all databases.Output is a result set with DbName, ObjectName and ObjectType.Advantages are- works reliable also with source codes longer than 4000 […]

2004-03-31

268 reads

Blogs

What’s my MAC Address in a Command Prompt?–#SQLNewBlogger

By

Another post for me that is simple and hopefully serves as an example for...

You don’t need a blockchain

By

After writing several posts about a neat feature in Azure SQL called system-versioned ledger...

Daily Coping 27 Oct 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

Error connecting using AlwaysON Listener

By Arsh

Dear Friends, I have a 2-node Read-Scale Always ON Availability Group to which I...

C?p nh?p d? li?u dánh giá sàn icmarkets chu?n xác nh?t

By sanicmarkets

Ic markets là sàn th? nào dây ? gi?y phép và các th? t?c...

Mumbai to Lakshadweep cruise

By omane

- Explore beautiful cruise destinations like Goa, Lakshadweep, Colombo, Maldives & many more by...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers