|
|
|
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 Replicating from hetrogeneous sources to SQL Server Posted by Adam at 5/28/2007 8:10:00 AM I need to use AS400 source as Publisher and SQL Server as subscriber. Can I
accomplish this in SQL 2000 and 2005?...more >>
Queue Reader Agent will not start after network failure Posted by Jonas Larsen at 5/27/2007 4:44:00 PM Senario
I have a SQL Server 2000 SP4 that is Publisher and distributor plus a SQL
Server 2000 SP3a that is a Publisher.
There replicates to 2 SQL Server 2000 SP4 over the company WAN.
After a roughly 10 min long network failure the queue reader agent will not
start.
Any ideas?
Thanks...more >>
Duplicate key row error in sql2000 transactional replication Posted by Suchi at 5/26/2007 6:04:00 AM
HI All,
We have transactional replication(not updatable) between 2 databses on the
same server (sql server2000).
Our requiremnt is to prevent the deletes to go to subscriber db. So, while
setting up transactional replication entered NONE in article commands
properties tab for DELET...more >>
SQL Server 2000 vs 2005 - Replication, Clustering, Double-Take etc. Posted by Spam Catcher at 5/25/2007 7:21:24 PM Hi all,
We're in the process of investigating several HA solutions for SQL
Server. We currently run a small database (couple GBs) but needs to be
available for 99.99% of the time. We can tolerate some downtime... but
preferably none.
A coworker suggested we take a look at Double-Take due...more >>
SQL 2005 Peer to Peer Replication Posted by Stephen at 5/25/2007 1:19:00 AM We have 3 SQL 2005 Servers which are in a peer to peer replication topology
but would also like to use merge replication to some remote clients.
Is it possible to have a database peing published in peer to peer and merge
replication on the same server....more >>
SQL2005 SP2 / Merge replication Posted by José Araujo at 5/24/2007 1:49:52 PM Hi everyone,
In the SQL2005 SP2 readme file says that to install in a replication
topology (merge) it has to be done in the following order:
1.. Distributor
2.. Publisher
3.. Subscribers
I have a single server acting as publisher/distributor and around 19
subscribers (merge replicat...more >>
Replication on SQL 2000 Posted by Big Ern at 5/24/2007 12:22:00 PM I have a question regarding functionality with SQL 2000.
In 2005, there are several sys.dm tables that provide information regarding
the database/OS/Hardware ect... I can use these tables to check the status of
replication amoungst other things.
I know SQL 2000 does not have these tables...more >>
Sync Manager With SQL Express Posted by Ken Hundley at 5/24/2007 9:11:01 AM We are really missing the sql agent that was in SQL 2000 for automating our
replication, but he have created a work around application now.
However, now I have found the sync center in Vista and scheduled a sync.
It started the sync at the correct time, but it asked for the
publisher/di...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Access Database transactional replicated into SQL Server 2000 Posted by freeman642 NO[at]SPAM gmail.com at 5/24/2007 4:03:41 AM I have an access database that I want to transactionally replicate
into SQL Server 2000. Can someone point me in the right direction for
getting the source connection in enterprise manager? Or a brief
example o how to start this? Have looked at SQL to SQL, but not Access
to SQL.
Thanks John
...more >>
Linked Server - Security Problem Posted by I.W Coetzer at 5/24/2007 3:03:01 AM Hi
We have set up Transactional Replication between two servers.
However the linked server that is created at the subscriber does not work be
default.
I therefore selected the last option "Be made using this security context"
and entered the sa username and password.
This solves the pr...more >>
Oracle Rdb -> SQL2005 Posted by David Gray at 5/24/2007 12:00:00 AM
Hi,
Currently our core system runs on OpenVMS with the data stored in
Oracle Rdb (that's not RDBMS).
Rdb includes a product called LogMiner which unloads the days
transactions from the transaction logs (After image journals in Rdb
parlance) into a delimted file, the structure of which ...more >>
SQL 2005 --> Replicate Production DB to Development DB Posted by Terry Wahl at 5/23/2007 5:58:02 AM We are using SQL Server 2005. I would like to replicate our production
database to our development database. The trick here is that I do not want
to delete any new tables in the Development database that have not been
released to production so I can't use a straight database copy. How can I...more >>
Merge doesn't re-propagate changes arrived from Transaccional repl Posted by Alexander Wolff at 5/22/2007 1:05:02 PM I have a the following scenario:
- A transactional publicaction "TRN2000" (in SrvSQLServer2000 server)
- A push subscription to "TRN2000" publication(in SrvSQLServer2005 server)
- A merge publication "Merge2005" defined in SrvSQLServer2005 over the same
Database/tables
that transactional su...more >>
Drop replication Pull job without Subscription publication databas Posted by Jose Milhazes at 5/22/2007 10:33:01 AM Publisher/Distribution job was removed but on Subscriver was not, since then
we are not able to remobe Pull job without Subscription publication database
on Subscriver server, any help how to remove it?...more >>
SQL 2000 Replication Log Posted by ganbade NO[at]SPAM gmail.com at 5/22/2007 7:27:42 AM Hi,
I'm new in SQL 2000 Replication, hope the guru's can help on my
following query.
a) Is the replication produce log file?
b) If the answer is yes, where can i get the log files & what's the
name of the log file
c) Will the log file grow rapidly?
d) What's the recommended book / site to r...more >>
cognos OLAP conversion to ms analysis service Posted by Angie at 5/22/2007 7:15:01 AM Hello All,
I am new to this group. I am looking for a tool that will convert cognos
OLAp cubes into ms OLAP cubes. Anybody has an idea?
Thanks a lot
Angie.....more >>
Replication scenario question...Merge or Transactional? Posted by Dave Stokes at 5/22/2007 3:55:02 AM The situation I am faced with is we have a web application supported by a SQL
2000(sp4) database that resides on a limited bandwidth network. Our
distributed users are constantly complaining of "slow" response times. Our
local users have no such complaints. Some of our leadership has sugges...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |