What is the syncobj_xxx generated in views? | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

What is the syncobj_xxx generated in views?

I am a novice at setting up replication, and tried to do so for the first time last week. After I set up Snapshot replication and then synchronization on the SQL Server 2000 db, there were many new views generated with the prefix of syncobj_. Can anyone offer an explanation to what these objects are and why they are created? Will they disappear after the first Snapshot is run? If anyone can be of any help, I would greatly appreciate it. Thank you.
I believe those are auto-generated by system during snapshot replication, which is also controlled automatically and will not cause any issues in performance. _________
Satya SKJ
quote:Originally posted by lshores ….Will they disappear after the first Snapshot is run? .

No they normally don’t just disappear (at least on most servers I’ve seen). In fact you might have to deal with them later when you remove replication from your boxes – They sometimes don’t get removed together with everything else. They are SCHEMABOUND views and may not allow you to issue DDL statements on the underlying tables. So you might have to manually remove them later. ..But that’s later. For now , just replicate. NHO
]]>