Hello, I've a problem using merge replication on sql server 2005 SP1 with sql mobile 3.0 users and dynamic partitions and dynamic filtering using SUSER_SNAME(). We have initilized something about 30 (dynamicly filtered) database for our mobile users without any problem. When trying to ini...more >>

Hi, I am trying to find a way to update tables on SQL Express. I have replicated a database to a local database from a remote database using linked servers but i want to be able to update the local database with any changes from the remote database. That is i want to add new records and updat...more >>

I am trying to deploy web synchronisation between server and client. Some basic setting up are as following: 1. Server -- SQL 2005 Standard Edition 2. Client -- SQL 2005 Express Edition 3. Sync Type -- Merge Sync 4. Subscription Type -- Pull Subscription 5. A publication (called CarolPub) is ...more >>

Just wondering if anyone can lend a hand on the below error. This is a SQL 2005 box. And to troubleshoot, I have doen the following: 1) Added the account in question to the local Administrator group 2) Assigned it to the sysadmin SQL Server server role Even though the account seems to ha...more >>

Hi all, Here is my question, hope you can help or shed some light. I have a replication setup like following: ServerA replicating to ServerB with filtered columns, ServerB then replicating to ServerC without column filtering. Table1 on ServerA has columns: col1, col2,col3, col4,col5. bu...more >>

Background: 2 servers identically configured running server 2003 ent 64 bit edition. Both DBS are MS SQL 2005 standard 64 bit. Publication and distribution running on same server. Type of replication is merge replication. Snap-shot folder is in a shared folder. VPN set up over Internet...more >>

I would like to know what file or files does the windows synchronize (i.e. mobsync.exe) read to load the user settings. I have made a mistake under Microsoft SQL Server 2000 the listing shows the following entries To create a subscription: select... :0 This is the mistake Now I am not able to...more >>

Hi, We have setup WinServer 2003, SQL 2005 filtered merge replication. We couldn't get Replication Monitor work at our new testing server. It didn't show the publication we had created. Finally we realized it was because we had different collations at server level and at user database/dist...more >>

Hi, I have setup merge replication on SQL 2k with sp4. There are 2 pull subscriptions (one in LAN and the other over the internet). The one on the internet is giving the below error everytime we try to sync. The process could not enumerate changes at the 'Publisher'. The process could not...more >>

Hi. I'm tryng replying a SQL Server 2000 database vs SQL Server Mobile 2005 database I belive that I need is: 1) SQL Server 2000 (Publisher and distributer) with the publication created (OK) 2) IIS with web sincronization configured (OK). I have Configured Virtual Directory for th...more >>

Hi, I am using SQL Server 2000 SP4, running merge replication with one subscriber. We were previously using transactional replication but encountered a number of problems with the queue reader, and we think merge replication may suit our situation better and be more reliable. When we had tr...more >>

Hi, I have a environment where 4 sql server databases on 4 boxes are subscribers to a central publisher. Replication is implemented as a Merge publication with 4 push subscriptions. What I'm wondering about is: Is there any way that I can synchronize one of the subscribers with the central p...more >>

hello i have to merge data to sql server via gprs in my application developed in vb 6.0. can any one help me how can i send data to sl server via gprs Thx a lot ...more >>

Hello, I've got Publisher, Distributor and Subscriber running on SQL Server 2000. Is it possible in this case to use MergeSynchronizationAgent class to synchronize databases? I'm, asking because executing subscription.SynchronizationAgent.Synchronize(); gives me an error "Procedure or functi...more >>

We're just wondering where you put your filters when using a republishing topology. Currently we have the primary publisher with two republishing servers. On the front end we are using IIS for Web Synchronization. Thanks for the help in advance......more >>

I have used the GUI to set up transactional replication with the publisher on one server and the subscriber on another server. The user that I used to start the sql Sever agent is the same on both server and have permissions on both server. The snapshot and the logreader agents are ok. The syn...more >>

Is there a way I can modify system table data in MSSMS 2005 w/o a query?? When I right click on the table, 'Open Table' is greyed. I know it is not a good idea to mess with this data, but ya know there are times it is necessary. TIA, Larry... ...more >>

Hello all, I have database (SQL2k). The database is under quite big OLTP load - several hundreds transactions per second, finance area, 24/5. To reduce load on main database and to solve locks problems, was created transactional replication from the database to query database. So, main data...more >>

Does anyone know the exact answer to the following: - We have a publisher/distributor that replicates a database to many locations using merge replication (pull subscriptions). - I add a remote distributor. - I create now the new subsrciption at the subscriber side to point to the new distribu...more >>

Which of the following option is best if i want that publisher only appends updated data at the subscriber rather than dropping existing table and recreate it. . Keep the existing table unchanged . Delete data in the existing table that matches the row filter statement and ho...more >>