Link to home
Create AccountLog in
Avatar of Francois_Tremblay
Francois_Tremblay

asked on

Help needed - Cannot bulk copy into a table 'tablename' enabled for immediate-updating subscriptions

Hi!

I have a remote location with 3 desktop.   They have a merge replication going on between them so that the operators know what "alarms" are in the database.

One of the desktop also has a transactional replication setup with another server on the network that the other users use for their queries.

For some reason ( what I believe to be a buggy application ), the data in the alarm table has been lost in the desktop database.

I was able to bulk copy using a DTS from station C to the station B ( merge replication between all them).
I cannot bulk copy with the DTS from station C to station A because of the transactional replication.

Error I get is :
Error : Cannot bulk copy into a table 'tablename' enabled for immediate-updating subscriptions.

Is there anyway I can recover the data and copy inside that table?  I tried using a DTS with object / query and it does not work.

How can I "re-import" these data?

Please note that Station A is the one running the merge publication and is the subscriber to the transactional replication...  SQL Server 2000 / MSDE is still used for all these PC.

Thanks a lot experts!

Frank
ASKER CERTIFIED SOLUTION
Avatar of lcohan
lcohan
Flag of Canada image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of Francois_Tremblay
Francois_Tremblay

ASKER

I found the solution on microsoft knowledge base