sql server replication: Dear All,

I have setup a transactional replication between two MS SQL Server 2000.
The replication from the publisher to subscriber is success. The replication
from subscriber to publisher will retrun 'sa' login failure, so I have used
sp_link_publication to fix it, but when I try to update the sbuscriber
again, it will return the following errors :

"Could not change the Publisher because the subscription has been dropped.
Use sp_subscription_cleanup to clean up the triggers."

I have tried to delete the replication, run "sp_subscription_cleanup" to
cleanup the subscribtion DB and create the replication again, but it still
return the same error. Does anyone have any ideas/suggestions? Thanks in
advance for your help.

Regards,
Joe

Joe,
this is very odd. Are the clocks on the systems synchronized? If they're
not, it could be that the subcription is expiring. Alternatively there are
some reports that this could be related to servernames being changed. Please
check the publisher and subscriber to ensure that @@SERVERNAME and
SERVERPROPERTY('ServerName') return the same name.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com