May 12, 2016 at 3:24 pm
Comments posted to this topic are about the item Replication-Quick way to determine the articles
June 6, 2016 at 1:00 pm
No results from both of my production replication servers, one SQL 2005 one SQL 2012.
August 17, 2022 at 5:55 pm
-----------------------------------------------
--marcello miorelli
--adding the schema to the articles
-----------------------------------------------
SELECT art.artid,
table_name = OBJECT_SCHEMA_NAME(art.OBJID) + N'.' + OBJECT_NAME(art.OBJID),
dest_table_name = art.dest_owner + N'.' + art.dest_table,
sync_table_name = OBJECT_SCHEMA_NAME(art.sync_objid) + N'.' + OBJECT_NAME(art.sync_objid),
art.[del_cmd],
art.[upd_cmd],
art.[ins_cmd],
art.[filter],
art.[filter_clause],
art.fire_triggers_on_snapshot,
art.[schema_option]
FROM syspublications pub
INNER JOIN sysarticles art
ON art.pubid = pub.pubid
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply