I have a website that used to connect to a database...
well it still technically connects but it cannot
pull data from a specific table. The error when you
run a select statement against it is 'Synonym translation
is no longer valid.' Now according to my research this means
that it is calling a synonym or table that is no longer there.
The problem is...it is, and it is fully populated with data.
Aside from exporting the data dropping the table and recreating
it might there be something less invasive that I am overlooking?
I'd hate to drop and recreate only to find out it still does has
the same issue. FWIW I am not a DBA, but I can muddle around.