|
|
|
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 Replication failing: Could not find stored procedure '' Posted by Tim (MDS) at 1/31/2006 10:21:27 PM We have a replicated environment with hundreds of subscribers (SQL2000 SP3a).
Our server (EMOCADB..MDS) subscribes to a 'LoanProduct' subscription which
publishes 'LoanProducts' and 'UserData' to a dozen sub databases on the same
server.
These sub databases then publish 'LoanProducts' and ...more >>
FK for tables out of the publication. Posted by ×יל ×©×¤×™×¨× at 1/31/2006 9:55:27 PM Hi ,
I would like to know what is the base approach for FK for tables out of the
publication.
I have several situations that I would like to add FK from tables out of
publication ( tables that do not replicate at all – historical tables or
replicate by different publication) to a...more >>
Need advice Posted by Chris at 1/31/2006 9:55:26 PM Hi,
I have a few offices accross the country running MSDE and my HQ SQL 2000. I
need to port the data nightly to the HQ. Should I consider Replication?
Whatever is done on the MSDE at the offices are not needed after copied to
the HQ. I was thinking of creating an app (running at all offices)...more >>
Turning Server service off for MSDE Posted by Duncan Tilley at 1/31/2006 9:13:48 PM Hi All,
Sorry if this has been asked before...
I've installed MSDE to act as a merge subscriber, started the Server
service to get it installed, then disaled the service. One way
replication appears to work fine - is there any reason I can't leave
the service disabled (may need to use a bidi...more >>
VPN and REPLICATION Posted by Jose Fernandez at 1/31/2006 8:45:38 PM Hello.
I'm trying unsuccesfully to replicate thru computers in a VPN.
What's my CSI? ;)
I have multiple computers all over the country. All of them with no real
IPs. Only one of them has real ip. I have Kerio Router Firewall with VPN
server. It works fine. everybody can connect from each ci...more >>
Merge Replication Problem Missing rows on subscriber Posted by Davec at 1/31/2006 5:22:14 PM I have set up Mege replication where a publishing subscriber
subscribes to a central publisher. The publishing subscriber publishes
to other regional subscribers. All Subscriptions are set up as pull
subscriptions using dynamic snapshots. The problem however is that
when the associated appl...more >>
Forcing resynchronization Posted by lewism NO[at]SPAM bitroads.com at 1/31/2006 12:08:58 PM I am doing testing on a database between a SQL Server and a laptop
usingmerge replication. I can see that each system is missing a record
in each system. When i run the validation process the system
identifies that the table are not in sync. Regardless of the
resynchronization method I use th...more >>
Question about snapshot replication and monitoring of msrepl_transactions in the dist.db Posted by combfilter at 1/31/2006 11:01:16 AM OK.
We have this 1 publisher db that is pushing out to two separate
subscribers (one is transactional the other is snapshot). In the
distribution db the publisher_database_id is going to be the same. We
monitor this transaction count by publisher id with the following (
Select count(1) ...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
DTS Import/Export Wizard - OMNIS & SQL server 2000 Posted by Wendy Parry at 1/31/2006 12:00:00 AM Hi,
I'm trying to use the DTS wizard to subscribe to tables located in an
OMNIS datafile. I have the ODBC drivers installed (manu stamp: raining
data), but I constanty get a "Exception_Access_Violation" error.
I'm newish to SQL server and am not quite sure where to start in order
to resolv...more >>
Can SQLCE dsf subcribe to 2 publications from the same server database? Posted by Dickson at 1/31/2006 12:00:00 AM Is it possible for a sqlce database to subscribe to 2 publications publish
from the same server database?
I have the sqlce sdf file created from synchronize with the 1st publication
with the "AddOption.CreateDatabase".
Then later i created a 2nd publication from the same database in the server
...more >>
MSreplication_queue getting dropped in SQL 2005 Posted by Pranil at 1/30/2006 7:47:29 PM I have set up an Updateable Subscriber replication between databases A and B.
This creates and uses the MSreplication_queue system table in the destination
(B) database.
I have lot of other tables being replicated from A to B, all standard
Transactional replication. e.g. Table C is replicat...more >>
Replication for reporting Posted by Jerry Brenner at 1/30/2006 4:52:27 PM We're trying to create a replication scheme for a simple data warehouse for
reporting. I've been looking at the Books Online for SQL Server 2005 and
feel like I've been going around in circles. Here's a simple case that we
are having problems with. The prototype for the reporting was done ...more >>
A simple question regarding SQL 2000 Transactional Replication Posted by Greg at 1/30/2006 4:31:27 PM We have a database that we would like to replicate to another server.
Am i correct to asume that the database that is updated would be the
publisher and that the subscriber database would be the replicated copy? ...more >>
No sync subscriptions Posted by Stephanie Williams at 1/30/2006 11:40:40 AM I have a 70 GB merge-replicated production database on which I need to
perform some maintenance. This maintenance will require the removal of my
subscription. I am trying to minimize downtime, obviously, and wonder about
the ramifications, if any, of setting up a no-sync subscription after m...more >>
Steps on configuring Peer to Peer Replication between two SQL 2005 Posted by Mehul at 1/30/2006 10:24:27 AM Hi,
I need to configure Peer-to-Peer Replication for a database between two SQL
2005 hosts. However I have few newbie questions on doing so:
1. Is it required to have both the SQL servers part of a domain or can this
be achieved with them being in Workgroup mode?
2. I came across this art...more >>
Deletes occurring at publisher Posted by marshallae NO[at]SPAM bowater.com at 1/30/2006 8:01:46 AM I'm using Merge replication on a table with an autoidentity field. All
users are entering data at the publisher (no records are ever deleted),
and at the subscribers the data is read-only. I'm having a problem
with records being deleted at the publisher. I'm assuming it has to do
with a subsc...more >>
replication over HTTPS Posted by MC at 1/30/2006 12:00:00 AM I'm not certain if synch over the https is possible for transactional
replication? I did see the setup for merge, but there is no mention of
transactional. Now, is it possible or not? If not, why not?
Second, initialization (access to snapshot) over https? Possible or not?
MC
...more >>
Synchronisation manager SA Password rouble Posted by asd at 1/29/2006 6:37:16 PM Hello everyone.
We have a bit of a problem with Windows Synchronisation Manager.
Basically, we have two domain servers (not the same domain) that have a db
on a SQL 2000 SP3a server. Those servers have a merge replication and
everything works as it should until we set the Syncronisation Ma...more >>
Transactional replication between SQL 2000 and SQL 2005 Posted by Dejan Markic at 1/29/2006 12:00:00 AM Hello all!
Did anyone successfuly created transactional replication between 2005 and
2000 SQL? Any problems, suggesstions?
Thank you and kind regards,
Dejan
...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |