Monthly Archives: March 2012

Searching a string in SQL server 2005 -

It is very tedious to find out all Database objects (functions, stored procedures) containing a particular┬ástring. Here is the script to get it- DECLARE @Search varchar(255) SET @Search=’texttofind’ SELECT DISTINCT AS Object_Name,o.type_desc FROM sys.sql_modules m INNER JOIN sys.objects o … Continue reading

Posted in Knowledge Sharing, SQL Server, Troubleshooting | 4 Comments