I have setup a Merge Replication(Local and Remote Servers) in my application. I am Using a table (for example) Employee in which Empno is a PrimaryKey+Identity field.During Insertion, Iam Getting An Error as "Primary Key Violation".How its possible?.What is the reason behind this?.Please give ...more >>

Hi all, Forgive me if this is a stupid question, but we lost our DBA a few months ago to a better job opportunity. As I am the person on staff who knows most about writing SQL queries, guess who has his duties now? :) (At least I don't have to do backups and such... the person who knows most...more >>

I am replicating data by transactional replication, between 2 float data types, and I am getting different results. '3294676.0' is replicating as '3294676.0000000005'. Does anyone know why this is? My procs and table definitions match, and I shouldn't be expecting to see this. ...more >>

Hi All, When I try it to push a suscriber I got an error: The process could not bulk copy out of table '[dbo].[OrderDetails]'. Function sequence error (Source: ODBC SQL Server Driver (ODBC); Error number: 0) ---------------------------------------------------------------- In the snopshot sai...more >>

Not sure why this keeps happening. The table is not that large compared to others that we do. This is with the 2 set on the logging and still is pretty vague as far as the "general network error".. Any ideas on how to make this snapshot go through. Both our connection and theirs is a ...more >>

Anybody knows where can I find some info related to replicating data from Oracle(Publisher) to SQL Server 2000(Subscriber), some examples? Thanks in advance! ...more >>

We have a replication desing with several publications (merge, unidirectional merge, and snapshot) synchronizing with several MSDE instances on laptops. On one of the uniderectional merges one laptop replicated the first time and received all data (1067 rows). More data was added to the server...more >>

We are trying to implement a warm stand-by sql server, but after initializing a new push subscription, neither the users no the table permissions are being transferred. Isn't the snapshot be responsible for those (sysusers and syspermissions) tables? Thanks...more >>

I have set up the transactional replication with Qued option .. I have a trigger on one of the table which inserts the data in another tables after insert /update activity happens . I have set up the trigger with Not for replication but still the trigger is fired twice without any interva...more >>

Hello All, I would greatly appreciate some help on this issue. I am very stuck and struggling. Basicall I have a SQL 2000 Server, that is the publisher for a merge replication. This merge replication, is to replicate to handhelds, that via a mobile application, insert into the tables. T...more >>

Hi, I'm trying to create a pull subscription but it fails. I would like to synchronize data between my laptop (remote or in network) and our SQL Server. I managed to create a push subscription replicating every hour but it would be better to have a pull subscription. I always get an err...more >>

I have a problem that needs tip: Our main replica server need to be restored. It has been the main server within a network using merge replications between around 10 servers with publications and push/pull subscriptions. Now listen the server was stolen and I need to restore (I got the all the...more >>

Hi, I am trying to create custom merge profile for merge replication between SLQ2000 and MSDE2000. The link between the two is usually 33,6 kb/s. I have checked parameters for 'Slow link profile', but there is only one parameter different comparing to the default profile (UploadGenerationsPer...more >>

In Enterprise Manager (EM), if you go to: [Replication Monitor -> Agents -> Merge Agents] you'll see a list of Merge Agents to the right. I'd like to be able to select one of the items, right-click, and select "Agent Properties". When I do this, I get a dialog box that appears. The title of...more >>

I need to copy 10 Databases (150GB) to another SQL machine. Now I need the destination machine to be updated every 24 hours. Transcational replication is not helping me - cause it doesn't copy tables without primary keys. Snapshot replication is not helping me either - cause i can't transfer e...more >>

Hi, We have a standby server that is located at the remote site connected by a leased line. We have a log shipping that is currently running from our primary server located at hq to the standby server. Everyday there will be a transaction logs and the full database restore been done on the ...more >>

Hi I can't go forward, I have the same error... Paul Ibison was helping but maybe he is busy... please help. Error 18483: could not connect to server 'serverName' because 'distributor_admin' is not defined as a remote login at the server. a) I'm using Named pipes and TCP/IP with not alias becau...more >>

We currently have two machines in a workgroup environment and both are running WIndows XP Pro SP1 and MSDE Sp3. The problem we have is with the Merge Replication. The publisher writes snapshot data to the snapshot folder, but the subscriber is unable to open this file across the network. We...more >>

Hello: I get this number of errors when I'm trying to merge replicate over GPRS. It occurs only some times: error 80072EE7 with native 28562 error 80072EFD with native 28562 and after those errors I get 80004005 with 28557. What about are these errors? why the database gets unstable? h...more >>

We have a setup where SQL Server A servers as a Master database. SQL Server B is installed in another country and replicates key master data from server A. MSDE Instance C replicates with Server B to receive this master data as well as merge data that is shared only between B and C. We recentl...more >>

I am Getting Timeout Problem when the meta data CleanUp Process Related to Merge Replication is running I just want to know a) What event triggers this job to run. b) What does this job does. c) What happens if the job does not run d) whether i can modify the job to run only on Sundays whe...more >>