Search for synonym base object name
Search for object that synonym is created for (select name, baseobjectname from sys.synonyms - baseobjectname)
74
votes
mrozik
shared this idea
-
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