Is there a DMV or something similar that will allow me to search for a particular string in the DDL of a synonym? For example if I created a synonym as follows: CREATE SYNONYM [my_schema].[my_synonym] FOR [other_server].[other_db].[other_schema].[other_view_about_business_stuff] ...how can I search through all my synonyms for the string 'business_stuff'? Oh... and I'd want it to be able to work on SQL 2005 or later.