Archived Months
April 2003
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007


all groups > sql server replication > april 2007 > threads for april 22 - 28, 2007

Filter by week: 1 2 3 4 5

Monitor transactional replication.
Posted by Chen at 4/27/2007 11:58:00 AM
Hi, I want via email to monitor transactional replication status such as still running, have some problem during retry, or re-initialize, etc. instead of login to Microsoft SQL Server Management Studio in SQL Server 2005 (SP1). I think those information should get from msdb, does anyone done ...more >>

SQL 2000 Replication: Could not bulk copy out of table
Posted by Mark Alejandro at 4/26/2007 8:44:03 AM
we are running sql200 and i am trying to do a transactional replication, i recieve the following error message during snapshot creattion The process could not bulk copy out of table '[dbo].[syncobj_0x4336423045343434]'. The error detail follows: I/O error (torn page) detected during rea...more >>

How to set up replication from SQL Server 2005 to MySQL through ODBC
Posted by ronald.debruin NO[at]SPAM ecorys.com at 4/26/2007 6:57:28 AM
Hi, Can anyone please provide me with a step-by-step explanation on how to replicate data (snapshot replication) from a table in a SQL Server 2005 database to a table in a MySQL database through an ODBC connection? I have already created a publication, but have not succeeded in successfully ...more >>

RowGuid as primary key
Posted by Brian at 4/25/2007 6:52:00 PM
I'm developing on SQL Server 2005 and our application needs to be 'replicable'. I can see how this is done using a RowGuid and marking to be used for replication, no problem. My question, however, is if I should make this rowguid column the primary key in the tables in our database. Will it...more >>

synchronization between latops and a central server
Posted by Pete at 4/25/2007 4:57:57 PM
Hi Guys, Am very new to replication and would like to request some advice about solving the following problem. I have a main database running on Sql Server 2005 Standard. A copy of this database is also running on Sql Server 2005 Express on 3 laptops used by reps in the field. The reps make...more >>

Help please! Ran out of all options on this error
Posted by Tony at 4/25/2007 2:32:03 PM
Hi, We are in the process of configuration replication for our 64-bit clustered sql 2000 environment. We run into this very common error, in the first step itself ('Cofnigure publisher, subscribers and distribution from EM'). At this point we didn't even select any subscribers. Just conf...more >>

Can the distribution database be moved from once SQL server to another ?
Posted by Yoganarasimha Prasad at 4/25/2007 1:57:10 PM
Hello, We are decommissioning a cluster and moving all the databases to a new cluster. The issue is, the distribution database. Is it possible to move the distribution database without dropping the publications and subscriptions ? If it is possible, please let me know how to do it. Thank...more >>

Replicating very large articles but need to avoid locks from snap-
Posted by Cqlboy at 4/25/2007 10:04:04 AM
I have a very large and very active table which I want to replicate to another server. How can I set-up a Publication for this table and avoid the locking during the initial snap-shot in SQL 2005? SQL 2000 allowed configuring replication without generating a snap-shot - assumed data was al...more >>



Web Synchronization for Merge Replication: No Access to Snapshot Folder
Posted by Urs Laubli at 4/25/2007 12:00:00 AM
Hi I get the error: "A failure occurred when accessing 'tabelle1_2.sch' due to an operating system error [53=''] during Web synchronization. Ensure that the -InternetLogin user when using basic authentication and the user running the merge when using Windows integrated authentication has...more >>

Replication Options
Posted by Mrpush at 4/24/2007 12:12:02 PM
Hello, New to SQL Replication. Have SQL 2000 and wanted to replicate my business & core databases to a server at another site to increase availability. Is SQL replication able to keep my business application running without end users ever knowing that one of the serves went down or are ...more >>

performance for Replication and trigger
Posted by Iter at 4/24/2007 11:54:02 AM
Hi guys, I have issue related transaction replication and trigger. In my company, we have transaction replication and then there are some triggers in the tables in subscriber server. When the data replicated into table, then fired the trigger. Recently, it causes performance issue when data b...more >>

Agent is suspect
Posted by mj at 4/24/2007 5:40:00 AM
Any suggests on Agent is suspect error? MJ...more >>

Cannot find the identity range allocation entry for the Subscriber
Posted by M. M. Ansari at 4/23/2007 11:38:01 PM
Dear All, When I am synchronizing the merge push subscription, receiving following error Cannot find the identity range allocation entry for the Subscriber in the MSmerge_identity_range table. Reinitialize the subscription. What could be the cause of message, and is there some way so I can ...more >>

merge replication generation problem
Posted by johng NO[at]SPAM garrisonenterprises.net at 4/23/2007 3:17:39 PM
Merge Replication Web Sync - Pull subscriptions publisher and distributor: SQL Server 2005 X64 build 2221 clients are SQL Express builld 2047 We have 3 of our clients that received the following error at the end of a merge. SessionStatistics: ============================ UploadInserts:...more >>

Moving replicated databases
Posted by stevekelley4 NO[at]SPAM gmail.com at 4/23/2007 3:08:36 PM
I have to move a SQL Server 2000 database from drive to another on the same server because we are running out of space. I know the easiest way to accomplish this is to detach the database, move the .mdf & .ldf files, and reattach the database. However, this database is being replicated, which ...more >>

Replication over Dev Server
Posted by Franck at 4/23/2007 8:37:05 AM
I got 2 servers running, Dev and Production The Production one is the one that the users run on and it's working with a Access adp project The Dev one is the migration project that evolve and use VB as interface. So my test are made on the Dev version but, the way it work now is i copy m...more >>

Snapshot or Transaction which would be faster?
Posted by Greg Larsen at 4/22/2007 9:42:02 AM
I am wondering how to set up replication. Say you have a very slow connection to a subscriber, so you want to minimize the amount of data piped across the network. The subscribers only need the data updated once a day. The publisher and distributor are on the same server, but the subscribe...more >>


DevelopmentNow Blog