What are the implications of having a SQL Server 2000 instance named "database"? It's the only instance on the server, but must replicate (publish & distribute) data to remote servers (subscribers) that may be default instance names or named instances. Thanks for any input, Tom ...more >>

Hi when i execute sp_addmergepullsubscription, i get the following error. Warning: The table 'MSsubscription_properties' has been created but its maximum row size (8361) exceeds the maximum number of bytes per row (8060). INSERT or UPDATE of a row in this table will fail if the resulting ...more >>

I'm getting the following output from one of my subscribers. The really odd thing is that I pushed this publication to another subscriber yesterday and it went through correctly with no problems. Any ideas? I've already removed the subscription and re-pushed it to the subscriber. Should I ju...more >>

I am getting this message when running the snapshot agent: Last Action: "The process could not bulk copy out of table '[dbo].[syncobj_0x3230414139344244]'." Error Descr: "ODBCBCP/Driver version mismatch" Both servers are running SQL V7, sP3 and MDAC v2.6RTM Any suggestions? Regards,...more >>

Hi We are using Dynamic Merge Replication and we seem to have a problem with the intial snapshot. When trying to apply the snapshot, the process expects the published tables to exist on the subscriber. I thought it should simply create them if they don't exist? Also I have tried to create ...more >>

Hello ! I=B4ve now successfully set up a merge-replication between=20 different SQL Server2K. Now, I want to start the=20 replication on users demand from inside an application.=20 What do I have to do ? Must I create a job and then start=20 this job ?=20 Thanx=20 Morgie...more >>

The distribution agent seems to have failed with the following error message Last command{call sp_MSget_repl_commands(46, ?, 0, 7500000)} Error Message Violation of PRIMARY KEY constraint 'PK__@snapshot_seqnos__053E7DEC'. Cannot insert duplicate key in object '#044A59B3'. Error details Vi...more >>

Help, My dist and Pub DB is on DB1, and subscriber on DB2. On my publication database, once the Log reader initializes, I get an error: category: ODBC source: ODBC SQL Server driver Number: 0 Full message: Timeout expired any ideas would highly really appreciated... Thanks!! ...more >>

Can I control the order of tables in data loading of snapshot creation? I need the data loading will start with foreign key tables and finish with primary key table, so the foreign key tables will not contain new records that their key not exist in the primary key table. Any help is appr...more >>

I have a SQL7 server that is the publisher. Two SQL 2000 servers have pull subscriptions defined. One is a clustered server, the other is not. If I reboot the SQL7 server, the non-clustered server re-establishes connections and everything is fine. The clustered server always shows as "Agent ...more >>

I have a pull subscription set but every morning when I check on it I have the status "Agent is suspect. No response within the last 10 minutes". This should not really be a problem if the replications was still running but it is not. I have to start the pull subscription again manually. Isn't...more >>

My replication publication fails on a table, because it has more than 255 columns. It there a limit I'm crossing somewhere? Thanks for any help -Travis ...more >>

Hello all, The replication contains several large tables related by foreign keys. Data continue to be inserted during the snapshot creation, which leads to foreign key failure while the snapshot is applied to the Subscriber. Before I manipulate the choice of records using filters, is the...more >>

I just disabled replication on my server. The conflict tables are still in my DB though. Is there a way to get rid of them? My Access front end chokes on the amount of tables it links to. Thanks, Joe...more >>

Is it possible, first to store excel .xls attachments in a column in SQL Server 2000. If it so, is it then possible to replicate the changes if the excel sheet changes? Thanks, Anjelina ...more >>

I have a problem with a connection!!! From my W2k with SQLServer in Enterprise Manager, I can't add a computer with WinXP + MSDE SP3a. It says: "SQLServer not found or you don't have access" If the computer has W2k + msde there is no problem. Any idea??? Thanks...more >>

Hello Has anyone an example in VisualBasic (6) to run merge replication in a portable computer with MSDE and a SQLServer?? What is better DB_AUTHENTICATION or NT_AUTHENTICATION?? Thanks in advance ByLoCK...more >>

Hello all - I am attempting to send and receive data with a SQL server over a wireless connection with a PocketPC 2002 device. I have tried SQL Merge replication, but I hit a brick wall with it. When I try to run an INITIALIZE / CREATE_DATABASE I am getting the error 80070005. From what I'...more >>

Hello, I have two sql servers which are not in a domain. One is my production server and one is a backup. I would like to begin replicating my live database to my backup server as a snapshot on a steady basis. I began to setup the distrib and was told that I needed to use something ot...more >>

Is there a way or script that I may be able to run so that it will uncheck the "Enforce Relationship for Replication" checkbox for each table that I specify? Thanks. - Nilay...more >>

Update, One of these is now working, didn't make any changes. It's still failing for our biggest database (1.6gb). I tried copying the backup file across manually and it started complaining the path was too long after about 10 minutes. Which was rubbish as it was only about 40 characters. Steve...more >>

Here's a real softball for someone but, I think this will stump many. Physically (meaning: which dll or stored procedure or whatever), physically, what is the "SQL Server Reconciler"??? SQL Server CE Books Online claims: "Both the SQL Server Reconciler and SQL Server CE Replication Provider...more >>