InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 11:27:38 GMT20http://www.sqlservercentral.com/Forums/Topic651977-1476-1.aspxRed Gate SQL search will do this and much more as well as being totally free.http://www.red-gate.com/products/sql-development/sql-search/Tue, 21 May 2013 04:34:33 GMTFairFunkhttp://www.sqlservercentral.com/Forums/Topic651977-1476-1.aspxHi,There is an article posted on my Blog site where you can search for specific text in all sql server objects easily and the query is also very simple. [url=http://mstechnoblogger.blogspot.com/2009/10/search-text-in-sql-server-objects.html]Search Text in all SQL Server Object[/url]Cheers...Sat, 10 Oct 2009 04:53:26 GMTchandreshwarhttp://www.sqlservercentral.com/Forums/Topic651977-1476-1.aspxAny suggestions on how to ignore results where the searched for text only occurs as part of a comment?Thu, 17 Sep 2009 11:10:23 GMTCongruent Influencehttp://www.sqlservercentral.com/Forums/Topic651977-1476-1.aspx[quote][b]jwalker8680 (4/23/2009)[/b][hr]Except maybe the length issue and I wasn't aware I was running into that issue... :-P[/quote]Lucky you. I found out the hard way. :-DThu, 23 Apr 2009 10:50:31 GMTJacekOhttp://www.sqlservercentral.com/Forums/Topic651977-1476-1.aspxExcellent suggestions all... and all situations I never ran into ;-) ... Except maybe the length issue and I wasn't aware I was running into that issue... :-PThu, 23 Apr 2009 10:46:09 GMTjwalker8680http://www.sqlservercentral.com/Forums/Topic651977-1476-1.aspxThis script crash when a database is offline:A simple where condition should is missing: SELECT [NAME] FROM Master.dbo.sysdatabases WHERE [NAME] NOT IN ('MASTER', 'TEMPDB', 'MSDB', 'MODEL') AND Status & 512 = 0Mon, 16 Mar 2009 00:58:10 GMTYenidaihttp://www.sqlservercentral.com/Forums/Topic651977-1476-1.aspxDon't forget to clean up and drop the #Results table if running as a script not a procedure.Fri, 13 Mar 2009 10:23:06 GMTshelleybobellyhttp://www.sqlservercentral.com/Forums/Topic651977-1476-1.aspxThere is one problem with your script: it will not find all instances of the text in SPs, Views or functions that are larger then 4000 characters and the searchabe text is close to the 4000 character position. Because SQL Server will split the code between multiple syscomments records you may end up with 'Joshua' in one syscomments record and 'A Walker' in another.In order to prevent this you could use something similarSELECT DISTINCT nameFROM syscomments SCINNER JOIN sysobjects SO ON SC.id = SO.idWHERE SC.text LIKE '%' + @FieldName + '%' UNIONSELECT DISTINCT nameFROM syscomments AS L1INNER JOIN sysobjects SO ON L1.id = SO.idINNER JOIN syscomments AS L2 ON L1.id = L2.id AND L1.colid = L2.colid - 1WHERE RIGHT(L1.text, 50) + LEFT(L2.text, 50) LIKE '%' + @FieldName + '%' This is what I use when looking for a text in the SQL code. It only works for one database but so far I did not have a need to search all databases on a server.Thu, 19 Feb 2009 07:49:04 GMTJacekOhttp://www.sqlservercentral.com/Forums/Topic651977-1476-1.aspxComments posted to this topic are about the item [B]<A HREF="/scripts/Stored+Procedures/65768/">Search All SQL Script Objects in All Databases for Text</A>[/B]Fri, 06 Feb 2009 13:58:20 GMTjwalker8680