replication - Sql Server 2008 Replicate Synonym? -
I am planning to update the names of some table by creating synonyms of the old tables and changing the name of the table . Replication can properly refer to synonyms?
Apart from this, as a side question, is there an easy way to see if a particular table is really being repeated or not? (Probably through a question)
I do not think so. The replication works by reading the log and there is no log record for any synonyms. Which tables have been replicated, to know about a query on sysarticles in the table, where do you go to HTH?
Comments
Post a Comment