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.
Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.
This article will describe one method to parse a delimited string into a table of data.
Why would I do that you ask? Let's say that you need to pass multiple parameters into a stored procedure to search for. For our sake, we'll say that we wa…
This article will provide a solution for an error that might occur installing a new SQL 2005 64-bit cluster. This article will assume that you are fully prepared to complete the installation and describes the error as it occurred durin…
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…