Publisher: SQL Server 2005 Subscriber: SQL Server Mobile I am getting the following error when I try to perform a merge replication: TITLE: Microsoft SQL Server Management Studio ------------------------------ Internal error: HTTP header information is either corrupted or missing in the...more >>

Do I have to use default newid() for the rowguid? I would prefer to pass a sequential GUID from the client code instead. -- Message posted via SQLMonster.com http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-replication/200701/1 ...more >>

Thanks for your co-operation given before. I am new to Replication. Pls be patient. Now I am coming with the new problem. On a different location one PC is showing following error. What does it mean? Category:SQLSERVER Source: VINOD Number: 50007 Message: xp_execresultset: problem with ...more >>

We are in the planning stages of setting up a redundant failover SQL environment and were wondering if it's possible to integrate Database Mirroring for some our databases (<10) and log shipping for the rest of our databases. All DB's are on a single instance of SQL Thanks Nick ...more >>

Howdy all. I set up Immediate Updating replication on AdventureWorks on 2005 Person.Address and AddressType tables. When this type of replication is created, a replication trigger is created on the Publisher. However, this replication trigger fires off the other (User) trigger on the table whe...more >>

Following commands from VB6 are working with SNAPSHOP and TRANSACTIONAL replication. But it does not work with MERGE. Pls help ! Option Explicit Const DB_AUTHENTICATION = 0 Const NT_AUTHENTICATION = 1 Const TRANSACTIONAL = 1 Const ANONYMOUS = 2 Const PULL = 1 Const FILETRANSF...more >>

When I try to synchronise Merge Pull subscription @ subscribers through windows synchronise in XP it gives me following error. "The remote server does not exist or has not been designated as a valid Publisher." Pls help Sanjay ...more >>

we are frequently running the maintenance tasks on production during that databases are not accessible. to avoid this we want to switch over to the standby server during maintenace and after maintenance has been completed switch back to primary server.During maintenance all data changes need t...more >>

I have Publisher and Subscriber on 2 different locations. Data added on subscriber is getting deleted and overwritten by the publishers data at the time of synchronisation. I want 2 way update. Data can be added on PUBLISHER as well as SUBSCRIBER. Is it possible in Trans Replication ? OR is ...more >>

Merge replication - SQL 2000. I ran some scripts to add a column to a table and to add a new table and view to articles. All went fine. Then I tried to manually start the snapshot agent and it gave me this error "The specified @job_id('guid number...') does not exist." What do I need to ...more >>

Hi, i have SQL2k SP4. My replication topology is: 1 Subscriber central and 4 publisher (no conflic) ok, the subscriber is necesary update inmediate to publicher data, for example: Pub A containt Empresa_id # Sucursal_id # monto ------------ ------------ ------- 1 ...more >>

Our current SAP production environment consists of a window 2000 advanced server and MS SQL 2000 with SAP 4.7. We would like to setup a reporting server which contains an exact copy of the production database which is up-to-date all the time during the day. I started looking into log sh...more >>

SQL 2005 merge replication. I took the defaults on an article for publication - auto identity management and the default ranges. If I attempt to insert >2000 rows (the size of the 2 ranges assigned), I recieve the following error: The insert failed. It conflicted with an identity range chec...more >>

Howdy all. I just set up Transaction, Immediate Updating replication on two 2005 boxes, replicating the adventureWorks DB. One table in particular (Person.AddressType) contains an Update trigger. When I try to Update a value on that table, I get the message "Maximum Stored Proc, function, tr...more >>

Howdy all. I used to frequent this forum and hope all has been well with Paul, Hillary, and any other regulars I may have missed. Anyways, I just set up Transaction, Immediate Updating replication on two 2005 boxes, replicating the adventureWorks DB. One table in particular (Person.AddressTy...more >>

Hi, I have an issue with my replication at the moment. I will try to describe the scenario accurately. I am using MS SQL 2000 SP4 with Merge Replication. Users/Subscribers connect to the publisher to upload/download changes. I have a trigger set up on one table which updates another, her...more >>

SQL 2005 Transactional Repl. Receiving row not found error. In SQL2000 you could view the error details and see the exact sp call sp_MSUpdxxx command that was trying to execute w/ param values. Now in 2005 - this is the most detail I get below: How do I see what row was missing? tia C...more >>

SQL Server 2005: After setting up replication of a database (for initial testing) the size of database and its backup has exploded. Normally the size of the mdf-file is about 54MB, but after implementing replication the size went +450MB. Due to the developing phase the database backup set...more >>

I just want to verify that my plan for making changes to SQL 2000 merge publication and to ask some basic questions. I need to add a new table, modify a view, add a column to a table in existing articles and uncheck the "Enforce relationships for replication" on several tables due to it causi...more >>