In the replication scenario I am dealing with, a mobile device (PDA) uses SQL Server Mobile to synchronize data with a SQL Server database located on some server. The mobile user can enter new data on the PDA. Data replicated from the server to the PDA cannot be modified. However, after a long p...more >>

I am working on a script to run in Query Analyzer to run all of my SnapShot agents manually rather than wait for the schedule to do it. I am using sp_start_job to run each agent such as: exec msdb.dbo.sp_start_job @Job_Name='SQLSERVER-SomeSnapshotAgent-167' waitfor delay '00:30:00' --some fi...more >>

Publisher: - Windows 2000 SP4 - SQL Server 2005 Standard Edition SP2 Subscriber: - Tablet XP SP2 - SQL Express SP2 - VS 2005, .NET 2.0, SMO & RMO coded in C# Hi, We have a publication that uses parameterized filters. I followed the steps listed in the RMO documentation and coded a ...more >>

We have a SQL2005 merge replication database with 8 subscribers. Three of the subscribers have not successfully replicated. We would appreciate any additional ideas for correcting this. So far we have some inconsistencies. For example, the "View Synchronization Status" displays: "Downloaded 1...more >>

Hello, I have a several PPC app that use replication on seperate IIS and SQL (2000) boxes with great success. We recently set up our first 2005 SQL install. It happens to be on a x64 machine. I am trying to use the same IIS set up and just have it replicate with the same database that has been m...more >>

We want to publish a row filtered table where each subscriber can have one or more of the row partitions. We'd prefer not to have separate databases or tables for each partition at the subscriber. We've look at various scenarios, transactional repl with DTS filter, merge replication with dynamic...more >>

Hi, MS SQL Server 2005 RTM. Could anyone please point me to a good source describing how the automatic identity range management works for merge repliaction or explain it? In particular, how the options of Publisher/Subscriber identity range size in Managemen Studio work, preferrably with e...more >>

SQL Server 2005 SP2 Windows 2000 SP4 Merge replication with client pull subscriptions Hi, Questions about replication agent jobs: 1) We changed a password on the user account that we run our agent jobs under. In management studio I clicked on the "Change Replication Passwords" butt...more >>

22 of my 36 distribution agents currently show a total of 400,000+ undistributed commands in MSdistribution_status, but if I look a the agents individually in SQL Server 2005 Replication Monitor they all show 0 undistributed commands. And if I use sp_browsereplcmds to get a specific insert ...more >>

I've deleted the publication and even disabled publishing completely, yet one particular table still thinks it is replicating. Things I've already tried: sp_dboption databasename, published, false sp_removedbreplication 'mydatabase' sp_msunmarkreplinfo 'mytable' The replinfo value for thi...more >>

Hi: Latency is very high in replication monitor even though I don't see any commands to be applied in sp_browsereplcmds. Do you know from where it gets the latency number from in distribution database because it is misleading? Thanks...more >>

I'm using the "SQL Server Update Wizard" to migrate SQL Server 6.5 databases to SQL Server 2000. When I try to connect to export server (SQL 6.5) i get the following error: "Unable to connect to the Export server. Please verify that you are an NT Administrator on that machine." Both servers u...more >>

Hi NG, I have a question regarding foreign keys and replication order in a merge replication. In our database (SQL Server 2000) are about 60 tables and 90 views. I created 2 merge replications on our server, it's now configured as a publisher and a distributor. The destination server do...more >>

Hi all, I want to know whether I can capture the SQL statements occuring when a replication is taking place. (Eg : Database A, Table1 is updated in a replication. If I run the profiler will it give the update statements used in it ?) Best Regards, RJ ...more >>

Hi All, I'm trying to use the Windows Synchronization Manager to handle the data synchronization in an anonymous Pull Subscription for a Merge Replication. I have set all the details and properties for the sync and it all works. Problem is, the only retained properties for the Login details...more >>

Should I use the domain administrator for the mssqlserver and sqlserveragent services log on account if I am setting a transactional replication on a remote server? Also, How do I restart the distribution agent if it fails? I can see the status of it but cannot find the restart property. ...more >>

In a transactional replication scenario, should i consider rebuilding indexes on the subscriber articles? Does that place a lock on the subscriber? most of those tables are used only for select queries. Thanks. ...more >>

Some problem happen from Appliction side & it was brought to my attention that i have to restore the production database & same production Database is used for transactional replication. i am not sure if i restore the database it will break the replication or what is better way to RESTORE. any h...more >>

Hi, We have a requirement to update a sub set of data to multiple databases over the world using SQL 2005 Standard (Each SQL server may have more than one DB that needs updating). We could use a push (or pull) filtered snapshot replication to each database achieve this. However, some of the ...more >>

I set up replication on a database and the next day a colleague restored it using a copy prior to replication. I now have an unpublished database that SQL Server is convinced is replicated. In Replication Monitor I have a red cross against the two publications on this database. I have no it...more >>

Hello, We have a mixed replication environment with SQL Server transactional replication and Datamirror replication (with DB2). Yesterday we upgraded to SQL Server 2005 and the transactional replication does not work. The log reader message is "Logscan in progress. Approximately 4254920 l...more >>

I have a 5 computer system been replicated to a server with MS SQL 2000 server. The database is called Lab2 and the space in disk became too short to work. I asked my assistant to delete some part of the data. I do not what he did, but now the database does not exist, and the publication is sti...more >>

I want to implement transactional replication for failover purposes. I need to replicate data from a primary database to a secondary one that will be used if the primary goes down. In the event of a primary failure I need to switch the applications to run off the secondary. When the primary is...more >>

While trying to configure replication from and to SQL Server 2000 boxes, I encountered the following error, which I was not able to get past. The error is encountered after completing the "Push Subscription Wizard" which is set to create the database and initialize the schema and data. The dat...more >>

sql2005 standard edition In replication monitor, under Publication tab, the Current Average Performance and Current Worst Performance show "Poor" for one publication, and this has been like this for a few days. The publisher server is not under heavy load at all. In Perfmon I checked Del...more >>

Hi, MS SQL Server Standart 2005 RTM, MS Windows Server 2003 SP1. Is it possible to combine, mix, or have a static and a parameterized filter on the same article simultaneously? Thanks, Oskar....more >>

Hi, We are running SQL 2005 Express on our office server and on our remotely located web server. Is database replication possible with Express? If not, any suggestions as to how we can syncronise the two databases? Thanks Andrew Ellinas...more >>

I have a SQL 2K <-> SQL 2K, transactional replication, updatable subscriber scheme setup. I have a table with an IDENTITY/PK column that will use automatic range management and is set as NOT FOR REPLICATION on both pulisher and subscriber. Can INSERTs occur on both ends? If so, is there anyt...more >>

Hi all, We got some problems with the replication of a current publication. the first snapshot replication between SQL 2005 Enterprise and SQL Express 2005 works fine, but after adding a new UDF to the article-list, the replication runs into an error. Error: The process could not read fi...more >>

Hi, I want to ask about SQL Merge replication between 40 MSDE2000 as Publishers and SQL 2005 as Subscriber. I received an error message while configuring the replication saying "For Merge publications, The version of the subscriber must not exceed the version of the publisher" Is there ...more >>

error Message:- The merge process could not clean up the subscription to 'WWW':'MSA:'MSA'. Error Details:- The merge process could not clean up the subscription to 'WWW':'MSA:'MSA'. (Source: Merge Replication Provider (Agent); Error number: -2147200965) -------------------------------------...more >>

sometimes because of heavy traffic in distribution database, sp_RebrowseRepCmds takes long time to return records. Is there anyother way to see commands which are replicating. Command column in MSRepl_Commands column is in binary format and it does not show the actual commands. Please let...more >>

Publisher/Distributor: Windows 2000 SP4 SQL Server 2005 Standard Edition SP2 Subscribers: Windows XP Tablet Edition SP2 SQL Express 2005 SP2 - on clients Replication topology: Merge replication with client subscriptions Most articles replicate both ways but we have a few ...more >>

I have a 22 gig database that I want to setup for transactional replication on a remote server. After the initial snapshot is created, would there be any reason why I would need to schedule the snapshot agent to run afterwards? If I do schedule to run a later date, will the snapshot overwr...more >>

On a SQL 2005 distributor we are seeing very high I/O levels and high cpu when the distribution clean up job runs. The MSrepl_commands table has some 8+ million rows. The MSrepl_transactions table has very old dates in it and I'm wondering if the clean up job isn't doing what it's supposed t...more >>

I have two instances of SQL Server 2005 Enterprise edition and I am trying to replicate a table to a subscriber that has a different table name and column names but same data types (columns are in same order). We developed one of our internal applications from scratch with slilghtly different ...more >>

I have successfully replicated ORACLE tables to a SQL Server, however I don't see ORACLE views listed in the "Articles" dialog when I open the ORACLE publication properties. Is this because it is not possible to replicate ORACLE views or am i missing something? TIA ...more >>

SQL2K SP4 on both Publisher and Subscriber. Remote Distributor (on the Subscriber). NOT immediate-updating. Transactional. Continuous. I've had replication set up for a long time now (over a year) and this message is suddenly showing up on several of the Log Reader Agents. Whats really stra...more >>