|
|
|
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 SQL 2005 Merge w/ different domains Posted by Darin at 10/28/2007 1:14:08 PM I have a publisher/distributor on one domain, and the subscriber is on a
different domain. Both use administrator, but have different passwords.
There is an SQL security account setup that I can use to access the
servers via Server Management studio on both machines (both machines can
access bot...more >>
How to create a suscription? Posted by Juan Manuel Porras Gálvez at 10/28/2007 12:38:01 PM Hello, after fighting to SQL Server replication, I'd like to know how to
create a suscriptor on a machine "B" for a publication make on a machine "A".
Distributor is placing on the machine "A".
The problem is the new suscriptor on the machine "B" cannot view the "A"
machine publication. Som...more >>
Replication Wizard - Connectivity Issues? Posted by voidptr78 at 10/28/2007 4:51:00 AM Hi,
I've got two servers to be a subscriber and publisher resp. The server
machines are in a secured environ. and I usually use my own laptop with SQL
Server 2005 on XP SP2 to connect to these machines either through Man. Studio
over TCP/IP or sometimes I connect using mstsc (remote desktop c...more >>
How do I create and sync a local table from a subscription? Posted by Steve Mahon at 10/26/2007 12:21:03 PM How do I create and sync a local table from a subscription?
I imagine I'm missing something simple. I currently have a sales order
processing Access/SQL 2005 applicaiton we run on our SBS2003 lan. I'd like to
run it disconnected from other locations and sync the changes. Reading trough
the ...more >>
3rd party software Posted by Kolitha at 10/25/2007 11:48:01 PM HI,
Any ercomendations for a good 3rd party S/W for sql 2000 replication using
minimum bandwidth over a WAN?
Thanks....more >>
Newbie replication advise Posted by John at 10/24/2007 7:08:17 PM Hi
We have a Microsoft Access app which uses Access replication to allow laptop
users to disconnect from LAN and be able to work offline. The data gets
synched between laptop and server Access databases once users are connected
back to LAN.
We need to port this Access application to sql ...more >>
2 publishers/1 subscriber Posted by Janet at 10/24/2007 5:58:01 PM I have the following scenario:
Server A; database = databaseA
Server B; database = databaseB
Server C; database = subscriberAB
Database A and B have the same tables; table name, structure.
I need to replicate all changes from databaseA and databaseB to subscriberAB.
Question: Can this be d...more >>
Master / Republisher Model Posted by Greg J at 10/24/2007 3:37:12 PM I'll give this a shot.
We are attempting to setup a master republisher model for horizontal
scaling of our mobile devices. We currently have what will be the
republisher with CE's connected to it. The goal being I do not want
to cause re-inits and data loss from the CE's to the republisher w...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Applying a snapshot to subscriber fron CAB file Posted by PhilD at 10/24/2007 5:51:02 AM I have replication running from SQL2005 to SQL2000, The amount of data has
grown so large that when a new snapshot is generated it takes a very long
time to send to the subscriber. I am using push transactional replication.
The distributor and publisher are on the same server in Germany and th...more >>
why the problem arises when we replicate it? Posted by SBR at 10/24/2007 12:42:01 AM Hi,
I'm setting up Transaction Replication b/w SQL Server 2K and SQL Server 2K5.
I have published Tables, Views and SPs as articles.
One of the views has more than 300 columns. So when i try to replicate it,
I'm encountering the
following error Message.
"Error 20068: The article cann...more >>
Is there any way to just reinitialize only the changed article? Posted by SBR at 10/24/2007 12:38:00 AM Hi,
I'm setting up Transaction Replication b/w SQL Server 2K and SQL Server 2K5.
I have published Tables, Views and SPs as articles.
When I try to modify the published Stored procedure, the changes are not
replicated.
When I Reinitialize the Subscription and start the Snapshot agent, it is...more >>
Replication or Mirroring Posted by nas at 10/24/2007 12:07:03 AM I'm facing some problems with the Snapshot Replication with error "StartIndex
cannot be less then zero" and unable to find a solution for this. I'm
seriously looking at Mirroring instead as an alternative solution.
The question is since I'm having 5 databases (one around 60GB) used for HR,
...more >>
Login failed for user '' in a Transactional Replication Posted by Fernando Lascala at 10/23/2007 8:26:00 PM Hi!
I need to subscribe a server in some publications to synchronize data from
my host server (server1) to my back end server (server2) that work in
diferent environments.
When I subscribe the server2 in a replication it returns the following
message:
Error messages:
Login failed for u...more >>
http://support.microsoft.com/kb/938671/ Posted by Ganesh at 10/22/2007 3:36:01 PM FIX: The Distribution Agent may skip some rows when you configure a
transactional replication that uses the "-SkipErrors" parameter in SQL Server
2005
Can some one please confirm is this applies only to
Publisher,Distributor,Subscriber Computers or applies to all.
Please confirm.
Than...more >>
questions on recovery (zero day for me, wrapping up recovery) Posted by David at 10/22/2007 2:37:55 PM I lost a whole server (was windows 2000 sp4 with sql server 2000 sp3).
Restored from backup on new server hardware (new idently as far as domain
goes also, did not bring back old server's identity).
Luckily I had a full backup from just the day before. I setup new server
(w2k3 r2 sp2) and i...more >>
timeout while replicating over a 4 mb internet connection Posted by G. Scheeres at 10/22/2007 2:27:02 PM hi,
we are trying to setup replication over a 4m sdsl line.
the size of the database is about 8Gb.
there are about 150 to 200 tables.
we first made a snapshot that went ok, but if we push it over the internet
to another server we get a bulk copy error on big tables (>35000 records)
it retr...more >>
Help with replication error Posted by Giorgio at 10/22/2007 8:23:03 AM I am getting this error:
The row was not found at the Subscriber when applying the replicated command.
I have a transactional replication with row filters with UDFs on some tables
and we are replicating data from internal sql server db to web sql server db.
We have an internal system that s...more >>
Exclude delete statements Posted by Rajeshaz09 at 10/22/2007 12:00:01 AM Hi,
I am using sql server 2000. In my replication program i need to exclude
delete statements. I want to replicate only insert and update statements. Can
any one help me......more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |