| 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 How to duplicate table structure in Transactional replication? Posted by gzwangyang at 6/7/2007 8:45:00 PM Dear all:
After I create a new publication and its subscription by Transactional
replication in SQL server 2000,I want to add a column or alter a column
length in publication table and hope that the column can be duplicated to
subscription table.However,I find that Transactional replication...more >>
Replication via email Posted by Dieter Menne at 6/7/2007 8:05:37 PM Hello,
we are planning for a remote application running SQLServer (CE, for
example) that can connect to the master (SQLServer) database via Email
only, because the connection is very unstable (dial up in the jungle).
We are thinking along the lines using XML packages for data exchange.
W...more >>
Simple Question... How to access .mdf on different server Posted by Noncentz303 at 6/7/2007 12:22:01 PM I am running a SBS and currently have a blackberry server running on it. I
need to access the database files for the blackberry server via SQL Mgmt
Studio. But we already have a SQL server 2003 on our domain.
What I would like to do is attach those DB files to my SQL box.... is this
possibl...more >>
Best Practice & Other Posted by simon NO[at]SPAM otr-tech.com at 6/7/2007 10:44:38 AM Hi All
I have the following replication setup:
Replication Type: Transactional
Database Size: Circa 35gb
Articles: All articles are published and are required to be at the
subscriber.
Server1: Publisher, SQL 2000 Sp3 (W2k3 sp1)
Server2: Distributor, SQL 2000 Sp4 (W2k3 R2 sp1)
Server3: ...more >>
SQL Server replication performance: More than 3000 subscribers Posted by narasimha.gm NO[at]SPAM gmail.com at 6/7/2007 2:00:24 AM Hi All,
We are developing a system which will have to support more than 3000
subscribers. We will have to support both Transactional replication
and Merge replication.
I checked the following document about SQL 2005 replication <http://
www.microsoft.com/technet/prodtechnol/sql/2005/mergrep...more >>
Basic Question - Push & Pull subscription Posted by mj at 6/6/2007 1:41:01 PM Paul/Hillary;
Scenario:
servers in the same domain:
Create the publisher/distributor
Create publication "MyPublication"
Create push subscription to Server B "PushToB"
Logon onto Server B
Create Pull Subscription "PullFromA"
Cannot create Pull Subscription....
A quick google search...more >>
where is Distribution Agent Posted by Ed at 6/6/2007 10:15:00 AM Hi,
In SQL 05 Replication Monitor, I don't see Distribution Agent (DA). The
only place I can re-schedule the job to run DA is under SQL Agent --> Job.
Is that true?
Thanks
Ed...more >>
SQL 2005 Web Sync - Proxy Auto-configuration URL was not found. Posted by David at 6/6/2007 6:16:00 AM We are new to the https/web sync feature in 2005 and hope someone can point
us in the right direction here. We have read the technet article "How to:
Configure a Subscription to Use Web Synchronization (Replication Transact-SQL
Programming)".
We have a working merge publication on one serv...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Need references for .Net app replicating SQL2005 database to the laptops Posted by Earl at 6/6/2007 2:35:30 AM Can anyone point me to some good references for coding a Winforms app to
trigger replication (merge preferably) on SQL2005? I'm setting up a scenario
where I want my app to allow multiple laptops to synchronize to the
distribution SQL2005 database and I'd like to do it either automatically or ...more >>
SQL 2005 web sync via https Posted by David at 6/5/2007 5:26:01 PM We are new to the web sync features in 2005 and have tried to create a merge
publication (on Server/Enterprise Edition) available to a pull-subscriber via
https (running 2005 Std Edition). The subscriber can only access the
publisher via https. The publisher's server has a valid SSL certific...more >>
never ending merge replication Posted by jaylou at 6/5/2007 7:11:01 AM HI all,
I have a merge replication setup between SQL 2005 and SQL express. I am
running this for a few different locations and I have not had many issues
with any of them. The other day one of my publications started to hang. I
cancelled the job and set verboselevel 2 and had it write to a...more >>
Multiple distribution agent sessions for one subscriber ? Posted by SteveH at 6/5/2007 1:23:01 AM I'm running SQL 2000 service pack 4 - on my publisher, my distribution and
subscriptions servers are SQL 2005 service pack 1....
Using replication monitor - I look at 'distributor to subscriber' history
and I see 3 distribution agent sessions running on one subscription...
select * from d...more >>
Using Custom Stored Procedures for Transactional Replication Posted by dinnebier at 6/4/2007 3:21:02 AM We are using transactional replication in SQL Server 2005 (publisher and
subscriber). We wish to use custom stored procedures for statement delivery
to perform data transformations during replication to enable data to be
duplicated to extra tables which are not in the source schema. We have
...more >>
The process could not connect to Distributor Posted by mj at 6/1/2007 12:40:01 PM Category:AGENT
Source: Merge Process
Number: 20084
Message: The process could not connect to Distributor 'xxxxxxxxxx'.
Environment:
Replication between 2 servers over the internet
Actions on Publisher:
Publisher creates a user account
User account is listed as system admin
User accoun...more >>
suscription could not be created-mismatch between replication meta Posted by John Luo at 6/1/2007 7:58:00 AM I got the following error:
The suscription could not be created.
Verify that a valid username and password were provided
Additional Infomation:
The merge process failed because it detected a mismatch between the
replication metadata of the two replicas, such that some changes could be
lo...more >>
How to duplicate Identity Column in SQL Server 2000? Posted by gzwangyang at 6/1/2007 4:52:00 AM Dear All:
The table for subscription is the same as the table for publication.
create table zt_company(company_id int identity(1,1) not for replication
primary key,companyname varchar(200),create_date datetime,modify_date
datetime)
If I use "not for replication" option when creating tab...more >>
Configure web synchronization wizard error Posted by JDS at 6/1/2007 2:37:05 AM I am trying to confugure SQL Server 2005 (wrokgroup edition) for merge
replication with web synchronisation. The server will be publisher and
distributor and the remote client will be running SQL Server 2005
Express.
I have set up two directories under Inetpub on the server. The access
direct...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |