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.
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data.
But that feeling is fleeting. Attacks these days can happen in many w…
With just a little bit of SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form. If you have never written code or looked at an SQL statement before, no problem! ... give i…