CODEWITHSUNDEEP
sqlsql-servertransactional-replication
amindomeniko
amindomeniko

Reputation: 429

Transactional Replication does not replicate SET QUOTED_IDENTIFIER

I have set up a one-to-one push trasactional replication with all articles copy properties set to TRUE. That's because I will need to back up the subscriber at some point with new data and restore as the primary database.

The setup is all fine except one schema issue: SET QUOTED_IDENTIFIER OFF is not transferred to subscriber when I compare the two databases on any of the articles (tables, views, etc). Is there a configuration that I am missing to have this corrected?

enter image description here

Upvotes: 2

Views: 172

Answers (1)

dfundako
dfundako

Reputation: 8314

This sounds like a documented bug with the Distribution agent replacing the square brackets around the name with quotes during replication. As a result, the quoted identifier hint is dropped so it does not throw a syntax error near the name. The documentation mostly refers to SProcs, but it may be worth investigating. Sources below:

https://www.captechconsulting.com/blogs/sql-server-transactional-replication https://support.microsoft.com/en-us/kb/278324

Upvotes: 2

Related Questions