Guys I have an updateable transactional Replication. It works fine from Publisher to Subscriber but when I try to update a table on the Subscriber I get the following error: Server: Msg 8501, Level 16, State 1, Line 5 MSDTC on server 'SERVERNAME\INSTANCE' is unavailable. Server: Msg 7391...more >>

Say i want to setup trans replication of DB1 on ServerA to subscriber DB2 on ServerB I already have a publication with a few articles being published now. I want to create 2 new tables with millions of rows and want to replicate those. Instead of adding it to the same publication and havin...more >>

Hi guys I currently trying to setup transactional updatable replication between a server in Australia and one in France. All goes according to plan until I begin pushing the subscription to the France server. After awhile (Say 30 min or so) I get the following message: Implicit conversion...more >>

Hi I have a old database A which need to be exported, made changes like including some columns/delete columns etc and imported again (basically changing MetaDB) as database B. Question is what will happen to the Auto number generated fields? Database A has Auto fields ID starting at 134,...more >>

An invalid datetime value was encountered. Value exceeds the year 9999. I'm running SQL Server 2000 Transaction Replication. The replication has been running without issue for 377 days. This morning I got the following: Error Message: The process could not execute 'sp_replcmds' on 'server...more >>

What's the best automated way to setup a disaster recovery environment in our situation? We have a production sql 2000 database receiving orders. If the machine crashes, we would like to use another server box to function ASAP (about 0.5 to 1 hr latency is tolerable). Shall we setup a rep...more >>

Dear All, I want to implement replication with centralized subscriber topology (1 subscriber at HO with 5 publishers in 5 cities), I had problem with 2 cities (A & B), currenty they have not on-line network connection to HO, I thought I want to setup dial in connection for each server (A & ...more >>

Can anybody tell me if it is possible to make a snapshot (not a log shipping or replication snapshot. The new 2005 snapshot) of a mirrored database even though the mirror ends up is held in a 'continually restoring state?' ...more >>

The tables in the publication and subscription dbs are identical. This seems like an old bcp 'unreadable' characters problem... Anybody help? Error messages: The process could not bulk copy into table '"dbo"."eh_RetailSales"'. (Source: MSSQL_REPL, Error number: MSSQL_REPL20037) Get help: ...more >>

Hi all, I am in the process of migrating to a new server for my production. I have a few tables that I replicate to another server from this server. Should I restore my Distribution DB over as well as all of my other DB's? I will be renaming this new server to the old servers name and chan...more >>

Hi, In my SQL Server Log the following message occurs: "Error: 14150, Severity: 10, State: 1" This occurs every time the distribution agents runs and there are no replicated transactions available. I know it's an informational error, but it annoys me. The strange thing about it is that the...more >>

...more >>

...more >>

Hi experts, I am currently using SQL Server 2000. My system uses replication is synchronize the data between HQ and the branches. Can SQL Server 2K support a partial replication of the columns in a published table? Partial replication means to replicate only some of the columns in a table ...more >>

Hello. I will construct client application with MSDE. I face with a difficult question. It's in sync with SQL2000 Server and MSDE. Client number is 5000. I fall in a dilemma. Which do i use, Replication or to make DB Sync application ? Thank you jongwoo ...more >>

Hi all, I have set up 10 subscribers each with merge pull subscriptions. the polling interval is 60 seconds and the StartQueueTimeout 120 seconds. I have limited the number of concurrent merge processes to 5 however the problem is that it seems the 5 that queue up never get a look in even e...more >>

Hi All , I read from BOL abt this NOT FOR REPLICATION is uses primarily for identity values. I have the following situation I am creating a trigger that actually updates/insert records into tblA in DB_A but this tblA is involved in replication to tblA in DB_B so should the "NOT FOR RE...more >>

Dear All, Our system is built-in SQL 7.0. I had one publisher and 3 subscription in 3 different location. And recently one of the subscription got the erorr "The merge process could not retrieve generation information at the Subscriber." sometimes. Can anybody advise how I can do ? An...more >>

I have a system where certain data for a given record can be updated by either the Server or the Mobile Device. Upon replication we get a conflict. The data that can be updated is in different columns. ' I have tried to use column level tracking but it does not appear smart enough to "me...more >>

Pull Subscription, Remote Distributor (on the Subscriber), not Immidate Updating, Tranascactioal Replication with both boxes SQL2K SP4. I have no idea what to do here. I highlight Log Reader Agent and all of them simply say "The step did not generate any output. The step failed". I RClick and ...more >>

Hi, I've added a couple new fields to a table. There are 10 subscriptions on this publication. Only 1 has problems synchronizing since. First error is: The merge process could not clean up the subscription to 'SERVER':'SERVER:'PUB'. (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147200965)...more >>

We have laptops using MSDE to synch with SQL 2000. We plan to move to 2005 and Express. We are using Merge replication and the laptops are anonymous subscribers. In 2000 we setup the anonymous subscribers from Windows Synchronization Manager by specifying the publication and subscription ...more >>

I have a complex query I use to populate reports. I need to move the reporting environment from actual production database that gets updated frequently. I have converted the reporting query into a view that pulls information from many tables with complex joins In my reporting databases, i have...more >>

Hi everyone! I am a computer engineer and have recently upgraded to .net 2005. With new data components available, I have decided to write a simple database application in order to get familiar with the new aspects of ..net 2005. Here is my problem : When I try to update a record on an sql ...more >>

I have a few subscribers that are complaining of dropped data in one of the main tables that users update on the subscriber machines. When they replicate, the agent history indicates there were conflicts, but when I go to the conflict viewer, no conflicts show up. The dropped data does not...more >>

Hello, I have two SQL Server 2000 using Transactional Replication over a VPN tunnel. From time to time, the VPN tunnel is dropped and reestablished, which made the Distribution Agent fail sometimes. I would like to increate the retry times, could someone please tell me how to do that? Th...more >>

I'm thinking of dropping the polling interval to 30 seconds. What is the behaviour of the merge agent if it takes longer than 30 seconds to synchronize enumerated changes fo a session? ...more >>

Any known Issues ? ...more >>

Do you recognize the process below? Some sql housecleaning or what? In my Sql log of my publisher/distributor, I get set of entries like: Starting up repl_sub_restore_5014D8E0-86F8-437F-80A3-DD6C12EFE5E5' Bypassing recovery for database 'repl_sub_restore_5014D8E0-86F8-437F-80A3-DD6C12...more >>

Hello I want to ask about the best security scenario that i can follow in Merger Replication. I have a server with a static ip , a virtual directory there and a merge replication on an SQL server 2005. I am thinking of opening the 80 port only on my firewall and also open a range of acceptab...more >>

I have changed Paul Ibison's stored proc a little bit. This proc should wok for both Central and Branch database and lists for all replicated articles, so parameter is optional. Also it eliminates duplication. Let me know if there is any flaw. CREATE PROC PBS_sp_ShowPendingMergeChanges (@...more >>

After applying service pack 1 to SQL Server 2005, I can no longer set up publications. Here's what I'm attempting: Under the Object Explorer of SQL Server Management Studio, I'm right-clicking on [INSTANCE]/Replication/Local Publications and selecting "New Publication..." After clicking o...more >>

Looking for some answers about Microsoft SQL Server 2005's new mirroring technology. 1) When using a witness what happens if the witness crashes? 2) What happens if the Principal crashes and the mirror never becomes the Principal? 3) What happens if you try to insert records into the m...more >>

Hi, I have setup my mirroring model to 'High safety with automatic failover'. Accordingly to article: http://msdn2.microsoft.com/en-us/library/ms366348(SQL.90).aspx my web application should work without resetting web.config. My Connection string is: user id=<webUser>; Network=dbmssocn; ...more >>

Hi My disribution DB is automatically set and the databse size is about 800 MB. now i am planning to set distribution database to fixed size as microsoft recommends Can anyone tell how much can i set upto.... and that should not degrade performance wise. Your help will be appreciated Th...more >>

Hi, Using SQL Server 2000, when choosing the "Microsoft SQL Server Additive Conflict Resolver" resolver using the sp_addmergearticle, I get the following error: "The resolver information should be specified while using the 'Microsoft SQL Server Additive Conflict Resolver' resolver." If I ...more >>

We are using SQL 2K with SP4 and push transactional replicaton with continuous syn. Recently we have a need to publish the second database on the same SQL server where our first published database is on. My question is, the process for publishing a second or third etc is no difference th...more >>

Manual Snapshot - Transactional Replication - SQL Server 2000 Sp3a What is the best way to handle the snapshot process of transactional replication under the following conditions? 1) Manual synchronization (semi-large database - 200GB) 2) Without locking publisher tables during snapshot (sem...more >>

Does running the sp_ChangeMergeArticle to change an article's conflict resolver require a reinitialization of the subscription? I performed a test and it seemed to NOT cause a reinit - I changed from the default, to Subscriber always wins, and then back to default, but I wanted to get some ...more >>

Hello - I'm preparing for a migration from SQL 2000 and SQL 2005 x64. We currently use transactional replication, but I think P-P is the right choice moving forward. I'm setting up a test environment and have run into a roadblock. Config: Server A: SQL Developer x64 (no SPs) Serv...more >>

I run into a problem with a Replicated table: An "Insert into" ( in Main DB ) on the replicated table turned out in the Replicated DB as an "Update" ( sp_MSupd ) on the replicated table. Does anyone encountered this problem ? Any suggestions ?...more >>

I currently have 2 scenarios that I need help with. Scenario 1: A column was added to a table using the standard ALTER command by mistake (should have been sp_repladdcolumn) and now I want to publish that column. Am I able to do this without dropping the column or forcing a reinit of the s...more >>

Hi, I have a transactional publication in SQL 2000. I need to GRANT some SELECT permissions in the subscriber. I have the articles set to drop and recreate tables when applying a snapshot, so I would like to use the @post_snapshot_script parameter/option of sp_addpublication to run a p...more >>

We are using Merge publication, SQL 2000 and MSDE (on laptops). I need to remove a table from the Publication articles. 1. Will the laptop users need to do anything when they synch or will they just be informed that their subscriptions need to be renewed? 2. Will any updates on the laptops be...more >>

i had a long discussion with my developer team & they were not convince with sp_repladdcolumn & they decided with traditional way & then to re-initialize SNAPSHOT. As it is not in my control so they gave me script to add new columns for 4-5 tables/articles. Alter table xyz add col1 varchar(5...more >>

I need to reboot server which is pull subscriber. What is the right procedure for doing this? ...more >>

I try to create transaction replication and have problem with moving tables. Snapshot agent generate schema for tables without file group, so on subscriber the tables will be placed on primary file group. But I want it to be placed on same filegroup as on publisher. Is any simple solution for ...more >>

Hi, I am trying to restore a database (subscriber) that is used for replication. When i trie it, I received this error: Exclusive access could not be obtained because the database is in use. RESTORE DATABASE is terminating abnormally. Can anyone help me out ? Lara ...more >>

Hi Is it possible to reliably sync an access db with its equivalent sql server db using the built-in facilities of sql server and access? Thanks Regards ...more >>

We're in the process of setting up a high availability system in two separate geographic locations using SQL Server 2000. One will be used as primary production site, the other replicated to be used in two ways: 1) hot backup site in the event 1st site is unavailable, and 2) for purposes of acti...more >>