|
|
|
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 schema scrip problem, when i do the replication to the server Posted by zhang_liang_1982 NO[at]SPAM hotmail.com at 8/21/2007 9:34:27 PM Hi there,
When i do the data relication at the client end (use windows
synchronize), the client end use pull subscription to connect to
server. At the server end, we only choose all tables to do the
replication with client.
When I do the synchronization, there is a error poped up, says schema...more >>
windows synchronization manager Posted by joyce at 8/21/2007 6:11:26 AM hi
When I programmatically set up a pull subscription, how do i specify
the password that is always going to be used for the publisher and
distributor?
thanks
...more >>
Merge replication: How to avoid duplicates of records? Posted by yashgt NO[at]SPAM gmail.com at 8/21/2007 5:19:02 AM We have a simple problem:
We have a table Assets[asset_id, title] and a table
Asset_Versions[asset_id, version_no]. In addition, there are columns
added by replication for storing the ROWGUID.
After synchronzation, assume both Node1 and Node2 have
Assets(1,'XYZ') and Assets_Versions(1,1)
Bef...more >>
Primary key selection for transactional replication Posted by Kev at 8/21/2007 3:36:10 AM Hi,
We have a database with very few primary keys defined. In order to implement
transactional replication with updateable subscribers we need to define
primary keys on all tables. I need some advise as to whether it's better to
use natural primary keys or introduce artificial identity colu...more >>
push subscription deleted Posted by Darin at 8/20/2007 6:42:57 PM We have a user with 3 databases and one subscriber setup for merge, push
subscription.
WHen I connected tonight, it seems the push subscriptions have been
removed, but the snapshot agent is still there.
Is there a way to see when the push subscriptions were deleted? if so,
how? In addition,...more >>
Invalid object name tempdb.dbo.MSdistributor_access Posted by Jack at 8/20/2007 10:20:01 AM Hi,
We have a sql server which is being used for replication. A remote user
while trying to sync is now getting the following replication error: Invalid
object name tempdb.dbo.MSdistibutor_access
I have no idea how to troubleshoot this. Any direction/help is highly
helpful. Thanks in adva...more >>
Table access privileges Posted by Jay at 8/20/2007 9:25:19 AM I'm not super familiar with all of the forms of SQL Server replication, so
this is more of a request to get the questions I need, rather than the
answers.
I received the following email this morning:
It looks that we had restarted the replication recently that seemed
to have rese...more >>
Transactional Replication from SQL 2005 to Sybase Posted by dk at 8/20/2007 7:46:02 AM Hi,
I am migrating from SQL 2000, which replicates to Sybase 12.5, to SQL 2005.
I am little confused with the creation of a subscriber and can't get to set
my Sybase server as a subscriber. Any experience on it?
Thanks very much in advance
Regards
DK...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
SQL 2005 64 bits / 32 bits - Merge Replication Posted by José Araujo at 8/19/2007 12:39:58 PM Hi,
We have a merge pull replication environment with SQL2005 (SP1/SP2 - all
standard edition).
We are thinking on moving the publisher to a 64 Bit box. The plan is just to
call the new server the same way the old server and take a backups of the
database (publication database + distribu...more >>
Merge Replication Architecture Question Posted by parchk at 8/17/2007 6:52:02 AM On each of our 40 SQL Server instances (members) an internal management
database has been created to collect various information about each server.
We want to push all of the member server information to a single "master"
database on one of these server instances for reporting purposes. My
...more >>
Merge replicaton: How to customize conflict detection, resolution? Posted by yashgt NO[at]SPAM gmail.com at 8/16/2007 9:43:07 PM We have a simple problem:
We have a table Assets[asset_id, title] and a table
Asset_Versions[asset_id, version_no]. In addition, there are columns
added by replication for storing the ROWGUID.
After synchronzation, assume both Node1 and Node2 have
Assets(1,'XYZ') and Assets_Versions(1,1)
Bef...more >>
URGENT!!! Help please. Constraints disappearing on subscribers. Posted by Tim Greenwood at 8/15/2007 9:48:52 AM I setup replication of a couple dozen tables from our production server back
to our QA department so they could have live data for testing. Immediately
upon the snapshot being restored at the subscriber, all the tables involved
lost all their default constraints!! What the hell could cause t...more >>
Subscriber does not show up Replication monitor Posted by Suchi at 8/15/2007 8:10:07 AM Hi All,
We have TR plain setup betwen two SQL 2000 systems.
From yester day i could not find t3 subscribers info in Replication monitor
under its publication.Distributor agents etc anything.The retension period
set to default (336 hrs)
There is no row for these in msdistributor_agents...more >>
Schema Changes in Transactional Replication Posted by Freddy at 8/15/2007 7:35:07 AM Hi,
We're doing transactional replication. about 150 tables are being
replicated.
The people on our development team do frequent product releases, and as part
of this the schema of some replicated tables almost always changes. Their
procedure is:
1. remove relevant tables from replic...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |