"Kristy" <pleasereplyby@posting.com> wrote in message
news:u8Cc2lEVGHA.4248@TK2MSFTNGP10.phx.gbl...
> When I look at my publisher and the publications in EM, they say they are
> transaction replication.
> HOWEVER, when I run sp_helppullsubscription on both of the subscriber DBs,
> they return a publication_type of 1 (well except for one of them which
> returns a 0 and is the one causing me high latency issues.) BOL says 1 =
> snapshot and 0 = transactional replication.
>
> Can someone please explain what in the heck is going on? My brain is about
> to explode.
> Thx,
> Kristy
>
>

"Hilary Cotter" <hilary.cotter@gmail.com> wrote in message =
news:uvuc5PXWGHA.2376@TK2MSFTNGP03.phx.gbl...
> That's strange. I just deployed a transactional and snapshot =
publication and=20
> verified that BOL is accurate here.
>=20
> can you review the descriptions to make sure that they are referring =
to=20
> current productions, sometimes data from old publications remain.
>=20
> --=20
> Hilary Cotter
> Director of Text Mining and Database Strategy
> RelevantNOISE.Com - Dedicated to mining blogs for business =
intelligence.
>=20
> This posting is my own and doesn't necessarily represent =
RelevantNoise's=20
> positions, strategies or opinions.
>=20
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>=20
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>=20
>=20
>=20
> "Kristy" <pleasereplyby@posting.com> wrote in message=20
> news:u8Cc2lEVGHA.4248@TK2MSFTNGP10.phx.gbl...
> > When I look at my publisher and the publications in EM, they say =
they are
> > transaction replication.
> > HOWEVER, when I run sp_helppullsubscription on both of the =
subscriber DBs,
> > they return a publication_type of 1 (well except for one of them =
which
> > returns a 0 and is the one causing me high latency issues.) BOL =
says 1 =3D
> > snapshot and 0 =3D transactional replication.
> >
> > Can someone please explain what in the heck is going on? My brain is =
about
> > to explode.
> > Thx,
> > Kristy
> >
> >=20
>=20