InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 19 May 2013 21:54:28 GMT20http://www.sqlservercentral.com/Forums/Topic929416-2703-1.aspxNice script and great tip on doing the left join to get table info.[code="other"]SELECT DISTINCT TypeDescription, SchemaName, Name, '...' + SUBSTRING(t.ObjectDefinition, CHARINDEX(@chvStringToFind, t.ObjectDefinition) - @intNbCharToExtract, LEN(@chvStringToFind) + ( @intNbCharToExtract * 2 )) + '...' AS Extract, CreationDate, ModificationDate FROM ( SELECT DISTINCT o.name AS Name, SCHEMA_NAME (o.schema_id) AS SchemaName, o.type_desc AS TypeDescription, o.create_date AS CreationDate, o.modify_date AS ModificationDate, ISNULL(OBJECT_DEFINITION(object_id), c.name) AS ObjectDefinition FROM sys.objects o WITH (NOLOCK) LEFT OUTER JOIN syscolumns c ON c.id = o.object_id WHERE --( -- ( o.type IN ( 'AF', 'FN', 'IF', 'P', 'TF', 'TT', 'U', 'V', 'X' ) -- AND @chrObjectType IS NULL -- ) -- OR o.type = @chrObjectType --) (o.type = @chrObjectType OR @chrObjectType IS NULL) AND (OBJECT_DEFINITION(o.object_id) LIKE '%' + @chvStringToFind + '%' OR c.name LIKE '%' + @chvStringToFind + '%' ) ) AS tORDER BY 1, 2, 3, 4, 5, 6[/code]Fri, 22 Jun 2012 08:54:30 GMTKevin Kennedyhttp://www.sqlservercentral.com/Forums/Topic929416-2703-1.aspxI think mine works better:http://www.sqlservercentral.com/scripts/Search/64839/It hits all databases and includes job steps.Mon, 21 Jun 2010 17:16:22 GMTDavid Korbhttp://www.sqlservercentral.com/Forums/Topic929416-2703-1.aspxI wasn't seeing any tables in my results. I think you need a left outer join to sys_columns because Object_Definition on Table returns NULLMon, 21 Jun 2010 05:17:55 GMTJason Akinhttp://www.sqlservercentral.com/Forums/Topic929416-2703-1.aspxComments posted to this topic are about the item [B]<A HREF="/scripts/String+Match/70371/">Find a string in database objects</A>[/B]Thu, 27 May 2010 20:26:00 GMTLaurent Michaud