Home > SQL > Search text in SP and Function

Search text in SP and Function

SELECT SOBJ.NAME, SYSC.TEXT
FROM SYS.SYSOBJECTS SOBJ
JOIN SYS.SYSCOMMENTS SYSC ON SOBJ.ID = SYSC.ID
WHERE SYSC.TEXT LIKE ‘%Text to search%’

Advertisements
Categories: SQL
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s

%d bloggers like this: