Home
Manage Your Code
Snippet: Specific word or phrase from all stored procedure, views, and triggers (SQL)
Title: Specific word or phrase from all stored procedure, views, and triggers Language: SQL
Description: Find Specific word or phrase from all stored procedure, views, and triggers available in SQL Server 2005/2008 Views: 348
Author: Pragnesh Patel Date Added: 9/22/2011
Copy Code  
SELECT DISTINCT so.name,sc.text
FROM syscomments sc
INNER JOIN sysobjects so ON sc.id=so.id
WHERE so.xtype in ('P','TR','V') and sc.TEXT LIKE '%fsu%'
order by name
Usage
This will give all object with word FSU