http://www.sqlmag.com/authors/author/author/5777874/rsscomment/5777874en-USFri, 25 May 2012 09:29:02 GMTFri, 25 May 2012 09:29:02 GMThttp://www.sqlmag.com/article/stored-procedures/find-strings-in-database-code-sql-server-agent-jobs-and-ssis-packages#commentsAnchorMon, 04 Apr 2011 13:07:24 GMT
Where is the 101896.zip hotlink that is mentioned? I don’t see any such link.]]>Dennis SchankMon, 04 Apr 2011 13:07:24 GMThttp://www.sqlmag.com/article/stored-procedures/find-strings-in-database-code-sql-server-agent-jobs-and-ssis-packages#commentsAnchorhttp://www.sqlmag.com/article/stored-procedures/find-strings-in-database-code-sql-server-agent-jobs-and-ssis-packages#commentsAnchorThu, 10 Feb 2011 14:22:22 GMT
Why not post this on codeplex so people can submit bug fixes?]]>ColamatteoThu, 10 Feb 2011 14:22:22 GMThttp://www.sqlmag.com/article/stored-procedures/find-strings-in-database-code-sql-server-agent-jobs-and-ssis-packages#commentsAnchorhttp://www.sqlmag.com/article/stored-procedures/find-strings-in-database-code-sql-server-agent-jobs-and-ssis-packages#commentsAnchorTue, 12 Oct 2010 13:32:26 GMT
I have just downloaded sp_find and applied to MSS2008.I still get the same error that was reported earlier.

msg 208, level 16, state 1, Procedure sp_Find, line 144 Invalid object name ’MSDB.dbo.sysDTSPackages90’

And David’s code reference was already in file sp_FindMag.sql

Please help.
]]>DaveTue, 12 Oct 2010 13:32:26 GMThttp://www.sqlmag.com/article/stored-procedures/find-strings-in-database-code-sql-server-agent-jobs-and-ssis-packages#commentsAnchorhttp://www.sqlmag.com/article/stored-procedures/find-strings-in-database-code-sql-server-agent-jobs-and-ssis-packages#commentsAnchorMon, 26 Apr 2010 09:56:43 GMT
Brian, The SQL2008 system tables is MSDB.dbo.sysSSISPackages.]]>LescherMon, 26 Apr 2010 09:56:43 GMThttp://www.sqlmag.com/article/stored-procedures/find-strings-in-database-code-sql-server-agent-jobs-and-ssis-packages#commentsAnchorhttp://www.sqlmag.com/article/stored-procedures/find-strings-in-database-code-sql-server-agent-jobs-and-ssis-packages#commentsAnchorThu, 05 Nov 2009 18:24:21 GMT
Can’t search SQL 2008 SSIS packages...get this error: Invalid object name ’msdb.dbo.sysDTSPackages90’.]]>BrianThu, 05 Nov 2009 18:24:21 GMThttp://www.sqlmag.com/article/stored-procedures/find-strings-in-database-code-sql-server-agent-jobs-and-ssis-packages#commentsAnchorhttp://www.sqlmag.com/article/stored-procedures/find-strings-in-database-code-sql-server-agent-jobs-and-ssis-packages#commentsAnchorWed, 22 Jul 2009 15:13:55 GMT
I checked with Bill and you’re correct. Bill sent along a corrected version of sp_FindMag.sql, which is now in the 101896.zip file. Thanks for letting us know about this! Karen Bemowski, senior editor SQL Server Magazine, Windows IT Pro]]>KarenWed, 22 Jul 2009 15:13:55 GMThttp://www.sqlmag.com/article/stored-procedures/find-strings-in-database-code-sql-server-agent-jobs-and-ssis-packages#commentsAnchorhttp://www.sqlmag.com/article/stored-procedures/find-strings-in-database-code-sql-server-agent-jobs-and-ssis-packages#commentsAnchorThu, 16 Jul 2009 10:19:18 GMT
The select from #FoundObject is missing the PreviewTest. Select should read: Select DatabaseName , ObjectName , ObjectTypeDesc As ObjectType , PreviewText From #FoundObject Order By DatabaseName, ObjectName;]]>DavidThu, 16 Jul 2009 10:19:18 GMThttp://www.sqlmag.com/article/stored-procedures/find-strings-in-database-code-sql-server-agent-jobs-and-ssis-packages#commentsAnchor