workaround for no TRUNCATE with synonym
Does anyone know of any workaround to not being able to truncate a
table using a synonym?
The problem is this...
There are several databases, each with a different schema owner that the
tables are created under. For all the databases, there is a synonym created
for each table name so SELECT and other commands can span databases without
having to specify the schemaowner.tablename. However, there are certain commands
like truncate which the synonym doesn't work.
Anyone with good ideas to get around this?
Thanks,
John