Help needed - Cannot bulk copy into a table 'tablename' enabled for immediate-updating subscriptions
Posted on 2011-02-14
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!