June 5, 2007 at 7:31 pm
How to view what/which tables are marked for replication in Publisher database? is there any system stored proc to check?
Thanks!!!
June 5, 2007 at 10:50 pm
Have a look at
sp_helparticle @publication = 'publication'
where 'publication' is the name of your publication.
Alternatively, you can use table sysarticles to see all table that are published regardless of the publication they are in. You may need to join to sysobjects to get the name of the underlying table/view etc.
Table syspublications has the info on each publication.
June 5, 2007 at 10:50 pm
Have a look at
sp_helparticle @publication = 'publication'
where 'publication' is the name of your publication.
Alternatively, you can use table sysarticles to see all table that are published regardless of the publication they are in. You may need to join to sysobjects to get the name of the underlying table/view etc.
Table syspublications has the info on each publication.
June 6, 2007 at 7:39 am
Thanks a lot !!!
sp_helparticle @publication = 'publication' is good enough
Regards!
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply