Search for synonym base object name
Search for object that synonym is created for (select name, baseobjectname from sys.synonyms - baseobjectname)
74
votes
![](https://secure.gravatar.com/avatar/2bf42d2a90db3712b2bf3bbdc473b27a?size=40&default=https%3A%2F%2Fassets.uvcdn.com%2Fpkg%2Fadmin%2Ficons%2Fuser_70-6bcf9e08938533adb9bac95c3e487cb2a6d4a32f890ca6fdc82e3072e0ea0368.png)
-
Jimbo commented
Should also search for server attribute of synonym as well. Times I've been caught out when looking for synonyms that are referencing objects on a particular server