Please Help

Hi all,
I need to solve a problem with SQL replication, I know very little about it,
and it wasn't me that set it up.
However we have 2 servers both with sql server 2000 Lets say server A & B
server A has been setup as the publisher & distributor with a transaction
push subscription to server B that has been setup as a subscriber.
I want this to work both ways but it doesn't seem to be replicating from
server B to A. Does anybody know what I can look into to check out what's
happening here?
Thanks
Gav> I want this to work both ways but it doesn't seem to be replicating
> from server B to A. Does anybody know what I can look into to check
> out what's happening here?
See Merge Replication|||Are you telling me that Transaction replication only works one way?
Gav
"JTC ^..^" <dave@.(nospam)JazzTheCat.co.uk> wrote in message
news:Xns95DCE2FB8183DdaveJTC@.217.32.252.50...
> See Merge Replication|||Unless you use "with updating subscribers", modifications will only be appli
ed one-way. From
publisher -> subscriber. You can make sure that each site only update its ow
n subset of data and let
both be subscribers and subscribers, but be very careful...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Gav" <spam@.spam.com> wrote in message news:uwXgt1X%23EHA.936@.TK2MSFTNGP12.phx.gbl...seagreen">
> Are you telling me that Transaction replication only works one way?
> Gav
> "JTC ^..^" <dave@.(nospam)JazzTheCat.co.uk> wrote in message
> news:Xns95DCE2FB8183DdaveJTC@.217.32.252.50...
>|||Sorry you have lost me a little bit there... I did say I havn't got much
knowledge in this field, do you have any sources of information on what you
have mentioned here?
Thanks for helping
Gav
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:Ose32EY%23EHA.3376@.TK2MSFTNGP12.phx.gbl...
> Unless you use "with updating subscribers", modifications will only be
applied one-way. From
> publisher -> subscriber. You can make sure that each site only update its
own subset of data and let
> both be subscribers and subscribers, but be very careful...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Gav" <spam@.spam.com> wrote in message
news:uwXgt1X%23EHA.936@.TK2MSFTNGP12.phx.gbl...
>|||I misprinted the last sentence, should be "both be both subscriber and publi
sher". I don't know
offhand where to find more info on this, but I'd start looking in Books Onli
ne.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Gav" <spam@.spam.com> wrote in message news:OdQCosY%23EHA.3472@.TK2MSFTNGP14.phx.gbl...[vbcol
=seagreen]
> Sorry you have lost me a little bit there... I did say I havn't got much
> knowledge in this field, do you have any sources of information on what yo
u
> have mentioned here?
> Thanks for helping
> Gav
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote i
n
> message news:Ose32EY%23EHA.3376@.TK2MSFTNGP12.phx.gbl...
> applied one-way. From
> own subset of data and let
> news:uwXgt1X%23EHA.936@.TK2MSFTNGP12.phx.gbl...
>[/vbcol]|||Try to look at
http://www.microsoft.com/sql/evalua...replication.asp or Search
Books online for Replication. That will give you an initial knowledge about
Replication.
Regards
Steen
Gav wrote:[vbcol=seagreen]
> Are you telling me that Transaction replication only works one way?
> Gav
> "JTC ^..^" <dave@.(nospam)JazzTheCat.co.uk> wrote in message
> news:Xns95DCE2FB8183DdaveJTC@.217.32.252.50...