We recently had a customer who wanted to find out if there were any references to another SQL database within the SQL views and procedures that had been developed within their Infor CRM database. There is a way to do this by using the sql_modules. Objects of type Store Procedures, Replication Filter, View, Trigger, Scalar Function , Inline table Function, Table Value Function, Rule, and Default all have an associated SQL module.
select object_name(a.object_id), a.* from sys.sql_modules a where a.definition like N'%someDBName%'
