I write an application in pocket pc.Customers make sync(Merge) with sqlserver. The sync time 26-40 sec generally.The number of rows doesnt effect the time.I send 200 data to mobile device it takes 15 sec.Mobile device send 1 row to sqlserver it takes 15 sec.. How can I reduce the time? I want...more >>

I'm getting this, after upgrading from 2000 to 2005. Replication-Replication Distribution Subsystem: agent (null) failed. The subscription to publication '(null)' has expired or does not exist. The only suggestions I've seen are to dump all subscriptions. Since we have several dozen public...more >>

My question is similar to "Simplest way to move an entire database". I have to move a central publisher (win2K server) to a new physical server with no down time. The current setup is a standalone that houses it's own domain, web, database and application. I need to migrate this to a dat...more >>

I need to move a database from one SQL server to another. Is there an easy way to move everything (tables, data, views, stored_procedures....)? Thanks, ...more >>

How can i get the unc path to the default snapshot folder using TSQL? I am using Transactional replication on SQLServer 2005. I have used sp_helppublication but that only tells me whether my publication uses the default snapshot folder or not. My publication does use the default snapshot fol...more >>

Hi all, The shotshot agent is generating a snapshot, I got the error ' Attempted to read or write protected memory. This is often an indication that other memory is corrupt'. Then, the agent failed. I tried to restart the agent and generate a snapshot again. This time, it run normally....more >>

Hi, I got a new application with Access front end and sql server back-end. This application has replication features where users can directly upload their changes on the main server. I have no knowledge about replication. However, I need to maintain this sytem. Is there any article or book th...more >>

Hilary, I was wondering if you could lend your expertise to somewhat a newbie question. I am just now in the process of swithing my application / database environment to sql server 2005. I have an application environment that you have actually helped me with in the past that includes...more >>

Hi, I've some tables where I can only use an ID and auto identity range. But in some other tables I can have the primary key as [Subscriber_code] + ID. Then I don't need to use auto identity range. The Subscriber_code it's stored in the INI file of the application that uses the database so ...more >>

Hello World, I have two merge publications on my server: 1) Size on disk is about 23-24MiB, contains 72 articles 2) Size on disk about 70MiB, contains 80 articles Both are configured identically Then I have to subscriptions from my workstation, one subscribes to 1) and the other subscribe...more >>

Hello, I add an article to a live publisher. The table to be added has foreign key relations. At publisher, under "action if there is already an object": Drop existing object and create a new one. The subscriber database was restored from the publisher a while ago. When I sync them (Replica...more >>

We're having intermittent performance problems on a SQL 2005 SP1 system that we suspect is related to transactional replication. There may be overlap with Jack Griffith's thread "Replication system disk performance severly degrades after 1 month", but I'm not sure...... While troubleshooti...more >>

Hi, I am using merge replication with two servers that are typically in an active/passive scenario, but sometimes the servers will receive updates simultaneously. I have set up merge with continuous (3 minutes) repication for almost any table in the DB and that has worked just fine in the las...more >>

HI I created clustered index on 115 million records which runs 6 hours after i created index now it is running for 16 minutes which is fine. if i run that query statement(update statement) 1st time it will take 16 minutes and second time it will take 50 minutes and third time it will take...more >>

I need to setup a way to manage auto_inc keys on MSSQL without the distributor handling it. I am using MSSQL 2005 transactional replication with updateable subscriptions. I have done this with MySQL using auto_increment_offset see article: http://www.onlamp.com/pub/a/onlamp/2006/04/20/adva...more >>

I have Publisher, distributer and subscriber which is SQL 2000. I have built a new Subscriber with Win2003 and SQL 2005 and wanted to replace the old subscriber which was SQL 2000. I would like to avoid doing a snapshot to the new server. My question can I tell SQL 2000 to DO not do a snaps...more >>

Where can I find a good document detailing how to setup replication from ms sql 2005 to Sybase? ...more >>

Hi, In SQL 05, when I look at the history of Snapshot Agent, it shows me all the details about what were transferred and what were not like the foreign key constraint (by the way, i think this is a great feature) for last 12 times. However, when I look at the history of Log Reader Agent ...more >>

Hi-- I am using SQL2005. I created a publication on one SQL Server and am trying to do a pull Subscription from another SQL Server. It all sets up fine. I create the snapshot. Then I create the subscription to pull. The Synchronization is failing. This is the message in the history log....more >>

Hi, Both the publisher and subscriber are SQL 2005 SP2. I am trying to set up a new subscriber to a push replication. I have other subscribers that are working fine. When I try to add a new subscriber I am specifying the computers name as the 'Server Name'. When the wizzard attempts to co...more >>