| Groups | Blog | Home |
|
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 |
Filter by week: 1 2 3 4 5 MSmerge_tombstone confusion Posted by redav at 9/30/2005 1:49:18 PM We have merge replication set up between a SQL Enterprise server and an
MSDE instance. We modify both databases through an inhouse app.
Things were great until after one synch a whole bunch of rows
mysteryously disapeared from the server. The kicker was that MSDE
instance had no changes made t...more >>
Replication - Identity Value problem Posted by Karthik at 9/30/2005 2:59:02 AM Hi,
I have a table with a tinyint (identity column). The current value in the
table is 2. And if I check with IDENT_CURRENT the next value is displayed as
3.
This table is an article in a merge replication. In EM if I check this
article the next value is shown as 127. And this is leading...more >>
HELP! The merge process could not retrieve identity range resource Posted by Buzz at 9/29/2005 9:08:02 PM Of course I get the error AFTER I start rolling into production!!!!
SQL Server 2000 SP4 and laptops with MSDE SP4 using MERGE with PULL.
There must be a bug in creating articles:
-- ****************** Table Contact with Int16 Identity field on primary key
PRINT 'Table Contact with Int16 Iden...more >>
number of records is larger in subscriber Posted by tosca at 9/29/2005 10:28:03 AM Hi!
Anyone knows howcome i end up with more records in the subscriber than in
the publisher? I'm using transactional replication, and the subscriber is a
standby server, no inserts are done in this server.
Any suggestions?
Thx!...more >>
best way to keep updated database copy on same server Posted by AF at 9/29/2005 10:13:05 AM Hi,
I was hoping to get some advise on my SQL 2000 server: I would like an
automatically updated copy of the main database kept on the same server. Any
changes made to this copy would NOT be synchronized to the main database,
however, changes made to the main database need to be immediatel...more >>
Replication Deadlock Posted by Robert Lie at 9/29/2005 10:09:49 AM Dear All,
I'm just configured transactional replication.
I have 2 DB Servers, OLTP Server and Reporting Server.
I uses transactional replication to replicate the data from OLTP Server
to Reporting Server.
I configured the replcation to use Push Subcription.
I set the schedule every 3 minute...more >>
confused about pull Posted by Darin at 9/29/2005 8:48:03 AM I have setup multiple merge replications that are continuously updating.
Now, we need to have laptops in the field that connect occasionally that
will merge. Because of that, I assume it needs merge PULL subscription.
I have had tons of problems and it has never worked. Right now it seems
to a...more >>
Merge Rpl. Pull from subscriber access denied problem Posted by SteveInBeloit at 9/29/2005 5:42:02 AM Hi,
I have set up one laptop as the Distributer/Publisher. Went through the
wizard and set up a Publication also, used Pubs. Then registered another
remote laptop that I can see via the network, and it can see me. I went
through the wizard again and set up a Push to that laptop. Said it r...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Replication - SQL Server 2000 - Service Pack 4 Posted by Nina at 9/29/2005 4:17:02 AM Hi,
I am considering upgrading to SQL Server service pack 4 and would just like
to clarify.
In the readme file for SP 4 if find the following:
“Note If an instance of SQL Server is not part of a replication topology,
you can back up a user database and restore it on any other rele...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |