SQL Replication

Question

SQL Replication

myukas

SSC Eights!

Points: 860
More actions
November 30, 2017 at 10:08 am

#341045

Is there an easy way to find out the following
Get Transactional replication details (publisher name, Publication, table, sp_names, filters)

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

goher2000 SSCertifiable Points: 5479 More actions · Answer 1

yes, https://docs.microsoft.com/en-us/sql/relational-databases/replication/administration/distributor-and-publisher-information-script

myukas SSC Eights! Points: 860 More actions · Answer 2

it does not work on 2005 because the code has system tables that do not exist in 2005

goher2000 SSCertifiable Points: 5479 More actions · Answer 3

and i was under the impression that this is SQL 2014 forum..

myukas SSC Eights! Points: 860 More actions · Answer 4

you are and it is i posted here with title of 2005 because there is no 2005 forum

goher2000 SSCertifiable Points: 5479 More actions · Answer 5

goher2000

SSCertifiable

Points: 5479

November 30, 2017 at 1:18 pm

#1970165

my bad.

Sue_H SSC Guru Points: 90860 More actions · Answer 6

myukas - Thursday, November 30, 2017 1:10 PM
you are and it is i posted here with title of 2005 because there is no 2005 forum

There are 2005 forums if you scroll down towards the end of the page listing the forums:
SQL Server 2005

I don't have a 2005 instance to check and I can't remember what was in 2005 or what changed for 2005. First thing to go is the memory....
In your distribution database, check for tables dbo.MSpublications and dbo.MSarticles.
In the published database check for the dbo.MSarticles table.
If 2005 switched to sys.objects, query that looking for the is_published flag.

Sue

myukas SSC Eights! Points: 860 More actions · Answer 7

there does not seem an easy with with it for 2005 or anything with 2005