I have some subscribers in cluster. when delete a record in a subscriber side, Publisher accepted the operation.However if try to insert a record with the same rowguid in the same table named "Image",Publisher rejected the operation. After tracing that operations of the table Image,the re...more >>

I have Scene Replication with Central Subscriber with many Publication with same tables. All tables have horizontal partition data about Publisher table to Subscriber tabler. That's ok. So, when I tried to propagated the second Snapshot of the onother publisher, this message appear. I read Paul...more >>

In the enterprise version of SQL there is the facility to do snapshot replication which I have not tried. How does this differ from snapshot replication? ...more >>

Hi All I have a 2 tables Tab1 and Tab2 with the same schema but on two different databases as below: Tab1 Col1 Col2 Col3 1 a a1Z 2 b b2Z Tab2 Col1 Col2 Col3 1 ax a1 2 bx b2 After replication Tab2 Col1 Col2 Col3 1 ax a...more >>

I have an issue in my merge replication setup where a subscriber updates three integer fields (status, competitor1, competitor2). When I check the publisher, only updates to competitor1 & 2 make it in. I have checked the conflict tables and they are empty. No error messages are reported durin...more >>

Howdy. I was reading PromisedOyster's question on "Replication vs. Mirroring" and it got me thinking, what would the benefit to Mirroring be in light of the new Replication enhancements? To be clear, Im referring to Peer to Peer Replication, or continuous Replication with Immediate Updating Su...more >>

Due to a large input on the primary server, one of our tables had grown enormously. With the right commands (delete, dbcc shrinkdatabase), we managed to shrink this primary server down to normal proportions. Is there a way to do this also for the secondary server? ...more >>

Hallo I've created a merge replication where publisher is a sql server 2005 and subscribers are several mobiles. My sql server replica doesn't work very well. Server cpu works at 100%. when a subscriber create a subscription to merge data, the upload appears correct, on the contrary ...more >>

Scenario: Windows Server 2003/SQL Server 2005 SP1 on publisher and subscriber. Transactional Replication (without Updateable subscriptions) with a PUSH publication from server A to server B. Replicate Schema changes are set to TRUE. Issue: We have a number of stored procedures with a leng...more >>

Hi All I have 2 tables with the same structure and data except only the data in one of the columns, NameC. And there are on different databases. Is it possible to replicate Db1..abc table excluding one of the columns, NameC to Db2..abc table on a separate database without inserting anyth...more >>

Hi, SQL 2000 (SP3a) Windows 2003 Getting the following error when running a Snapshot agent which replicates 27 tables (no metadata) to a database on the same server (Tandoori). Cannot use empty object or column names. Use a single space if necessary. (Source: TANDOORI (Data sou...more >>

BOL link: ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/rpldata9/html/23e7e8c1-002f-4e69-8c99-d63e4100de64.htm Howdy all. I was just reading up on this topic and have a question. It says on this page (Topology with two participating databases) that reads will be spread out between the two servers,...more >>

Our clients would like an automated fallover database server as well as a database for reporting purposes. At face value, mirroring would seem the better option. However, it would appear that the users aren't able to run queries against the mirrored database. See statement below from the MSDN ...more >>

Hi, I have a replication topology as follows: sql server 2000 sp4 publisher on one server, sql server 2000 sp4 distributor on another server and sql server 2000 sp4 subscriber on another server. I execute sp_addpullsubscription_agent (on subscriber) and set all the security_mode parameters ...more >>

I have configured transactional replication between 2 SQL Server 2005 servers. Unfortunately, I am experiencing permission issues when try to access configure the pull subscription. They two servers are in a Windows Workgroup, therefore, what are the permission prerequisites I must configu...more >>

Hi, I am using SQL Server 2005 replication. In the Conflict Viewer I have the following message for the conflict being reported. The same row was updated at both '[Publisher]' and '[Subscriber]'. The resolver chose the update from '[Publisher]' as the winner. The table is not filt...more >>

Hi All, I am using a merge pull replication with the problem shown in the scenario below: 1) Organisation 'A' is added to tblOrganisations on the "server" 2) "user" synchronises and does not add these organisations because the filter restricts the subscription to only those oganisations t...more >>

I have an application that uses merge replication to synchronize data between an SQL 2000 server and MSDE 2000 clients that are desktop systems. I have been testing this applicatio for some time while I developed and have had no problems with replication. This week, I have added additional...more >>

Hi, I'm using MSSQL 2005 Mobile subscriber to partitioned publication (with merge replication). In my case the partition is security-related, so it's important to ensure that different subscribers will get only their own data. Since I can't use SUSER_NAME(), and since HOST_NAME() can be ove...more >>

Hi, Has anyone seen a problem like this: when trying to add an article to an existing publication (i.e. running sp_addarticle) I get the following error if I run it from my workstation: [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionCheckForData (CheckforData()). Server: Msg 11, ...more >>

We use MS-SQL replication between multiple servers at various sites but on two independent sites, we are seeing this error message on merge replication. It is returned within seconds of starting the agent. One site was working fine and developed the error while the second is a new installation...more >>

If i add NEW COLUMNS to 2-3 existing Articles\Tables using "sp_repladdcolumn" do i have to re-initialize replication & apply SNAPSHOT or LOG READER will apply all data in that new columns for subscriber. i am trying to understand when i add new columns how columns are getting replicated to SUBS...more >>

Error = Invalid distribution command type. LAST COMMAND = sync -t"TableName" -d"\\SQLSERVERNAME\E$\Program Files\Microsoft SQL Server\MSSQL\ReplData\unc\................................. \TableName_2336.bcp" -hORDER( [Column1],[Column2],[Column3] ASC) Transaction sequence number and command I...more >>

Hi, Does anyone know how to get over this problem in SQL 2000 without removing all replication then adding back in? Could not create a Pull subscription to publication XXX Error 21776 [SQL-DMO] name XXXX not found in Transpublication table. Thanks Dave ...more >>

After creating a successful transactional replication, is there a good way to verify that all the articles have been replicated to the subscriber and that the data is in sync? Thanks, JN ...more >>

Hi, I have a question on how Updatable Subscriptions work. While I understand that triggers are added to the published tables in the subscription database, and when a change is made at the Subscriber, the trigger fires. In light of this, I've been wondering... wouldn't that leave the state...more >>

Hi, I am using SQL 2005 server. If I want to replicate a table from A server to B server, using transactional publication, do I setup a publication in A server with article of the table and then setup a subscription in B server? Am I over-simplifying or there is some thing I n...more >>

Hello, If I want to change the column size of a table under replication on the publisher side, can I do this manually? And then manually change the column size of the corresponding table on the Subscriber side? Or does this require the use of Replication SP's? If so, what Replication SPs...more >>

Hy, we have a recurrent problem on a transactional replication with queue updating, after about 1 month the replication has worked well the queue reader stop with this error: ODBC error invalid sql data type, we have solved this problem in this way: 1 we have tracked the activity of th...more >>

Hi Hilary, Paul..... I have another real problem I hope you can help with. Setup replication now with no problems but one! The database tables fail from the application thats using them because of the ROWQUID column. I noticed that JUST before the articles are created it shows this; ...more >>

I have two identical databases on two different servers connected via LAN running SQL Server 2000 with the latest service packs applied on Windows Server 2003. I have set up merge replication for a few tables on these databases. The process works fine. However, when any change is made to data in...more >>

In SQL 2k, I recently found my replication monitor displays no subscriptions in the tree = Replication Monitor > Server> Publication. Where I could see all 50 + subscribers, now there is only a snapshot agent showing. Yet all subscribers are happily synching away and visible in the Repli...more >>

Hi all, I have designed and implimented my 2K pubs and msde subscribers, anonymous pull. There isn't much docs on maintenance steps and less on the "Validate all users." Does that just show validation stats in the history or will it set the user to reinitialize if something is off or som...more >>

Hi all... I made a backup of our production database, and am trying to copy it over to our test server. About 3/4 into the way of the copy, I get an error message that reads: cannot copy nmhsystem_013107: The process cannot access the file because another process has locked a portion o...more >>

I apologize for the repeated post, but my previous posts were not answered and I'm getting desperate. I have a SQL2005 Standard publisher with 10 SQL2005 Express subscribers using web synchronization (anonymous subscriptions). The identity ranges on the subscribers are not properly updating...more >>

Can MSDE be used as a Publication to another MSDE Subscriber using Merge Replication? Can SQL Server 2005 Express be used as a Publication to another SQL Server 2005 Subscriber using Merge Replication? What is the difference between SQL Server 2005 Express and SQL Server 2005 Compact Edi...more >>

What are the minimum setup requirements to support the following. 2 Remote Laptops running SQL Server 2005 Express databases with the ability to synchronize with each other. Also they should be able to synch with a server hosting a SQL Database whci is accessible from 2 other Desktop PCs. ...more >>

Hi, I'm running SP4 with the latest rollup so everything should be fine.......erm NOPE I'm getting the above error because the subscriber is NOT reading the schema properly. Now I dont why this happens and MS apparently corrected it in SP4 but they have not...... Everytime a do a new ...more >>

Hej Im running 2005 enterprice with logshipping every 15 minutes. I have a maintance plan including the following in this order: - Check integrity - Rebuild indexes - update statistics - Full backup. The backup is the last task in the process so the following logshipping sould only ta...more >>

Hi, >From a publisher I replicate 3 databases to a distributor/subscriber machine. On all of them i have MS SQL 2005. When i delete one of the replications by running publisher => sp_dropsubscription subscriber/distributor=>sp_removedbreplication publisher => sp_removedbreplication subscr...more >>