How to search all objects in all databases with specific word phrase in SQL Server
When migrating SQL databases to new server, one of the challenge is to identify all the hard-coded references to old servers or services. Here is a small piece of code that I wrote to search all databases to identify all objects with references to specific keywords or phases. DECLARE @listReferenceObjects