|
What ports are used by the MS DTC Service ?
Hi,
I have a trouble between 2 SQL Server 2000 with a transactional replication
w/ immediate update subscription.
Both servers are in a diferent network separated with a firewall.
This is the error:
Server: Msg 7391, Level 16, State 1, Line 5
The operation could not be performed because the OLE DB p ...
Thu, 23 Dec 2004 15:25:49 -0300
|
How to Change Subscriber Status in Merge Publication
Tony,
as a bit of background, what is your requirement? What is
ti you need to achieve by trying to change the status, as
there might be other more straightforward ways of
achieving the same ends.
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
...
Thu, 23 Dec 2004 07:59:00 -0800
|
How to Change Subscriber Status in Merge Publication
Hello All,
I am using a Merge Publication and I have a application in which I need
to programatically change the status of a Subscriber for that
publication (active or inactive). Can anyone tell me how to do this?
I'm currently using VB.Net, but any example will do. There is a
sp_changesubstatus system sto ...
Thu, 23 Dec 2004 06:54:24 -0800
|
Secure Replication
I wonder if anyone can help me.
I have been given the job of coming up with a scenario of SQL Server ->
SQL Server replication that is secure.
Both SQL Servers will be behind firewalls at different geographical
locations, and in different domains. I know you can encrypt traffic
using SSL, but will that ...
Thu, 23 Dec 2004 11:34:06 +0000
|
Snapshot Agent doesn't start
Are any errors reported in the agent history?
To enable the publication, you could try running
sp_changepublication to set the status value:
sp_changepublication @publication = 'publication'
, @property = 'status'
, @value = 'active'
To check the permissions issue, have a look at the
...
Thu, 23 Dec 2004 02:02:47 -0800
|
msrepl_transactions
Hassan,
if you have anonymous subscribers or if not all of your
subscribers have synchronized, the commands will stay
there until the cleanup agent runs and the retention
period is reached.
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http:// ...
Thu, 23 Dec 2004 01:48:34 -0800
|
Replication jobs owned by sa
The reason sa is often suggested as the owner of
replication jobs is that when the job runs, there is an
active directory lookup performed of the job owner. This
is the reason sa is used - no AD lookup required. The
jobs themselves are run under the authority of the sql
server agent so trusted/non-trusted ...
Thu, 23 Dec 2004 01:46:15 -0800
|
Validating data between publishers and subscribers
After synchronizing, open replication monitor and drill
down to the publication. Right-click the publication and
select to validate subscriptions.
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
...
Thu, 23 Dec 2004 01:31:17 -0800
|
read from replication tables
To read these commands, execute sp_browsereplcmds.
The contents are cleared by the distribution cleanup
agent which runs every 10 mins by default. The commands
are removed after all subscribers have read them or if
the max distribution retention period is reached. This is
different if you have anonymous su ...
Thu, 23 Dec 2004 01:24:55 -0800
|
Snapshot Agent doesn't start
Hallo,
i'm trying to get my replication started, everything seems to be fine, only
the initial snapshot does not start. The folder where the snapshot is (to
be) saved, provides all rights to everybody - just that folder, of course.
I was told that maybe the snapshot agent doesn't have the right to create ...
Thu, 23 Dec 2004 10:18:39 +0100
|
msrepl_transactions
on one distributor, the min entry_time in the msrepl_transactions for the
publisher isis just a few hrs away from getdate() and then on another
distributor, its 2 days old .. All my subscribers are current in the
transactional replication.. so why are these transactions still there and
also in the msrepl_comman ...
Wed, 22 Dec 2004 21:04:45 -0800
|
Replication jobs owned by sa
Right now my replication jobs for transactional replication are owned by
sa.. What happens if we change the authentication mode on SQL from mixed to
Windows only ? Will the jobs fail ? And do I then need to change the owner
to a Windows account ? Thanks
...
Wed, 22 Dec 2004 19:58:50 -0800
|
Validating data between publishers and subscribers
Using transactional replication and how can we confirm all data is in sync
between publishers and subscribers ?
220 59228 <#v7wkMK6EHA.1596@tk2msftngp13.phx.gbl>
Reply-To: "Hassan"
From: "Hassan"
Subject: Validating data between publishers and subscribers
Date ...
Wed, 22 Dec 2004 19:54:44 -0800
|
read from replication tables
I want to see the commands in msrepl_commands table. Using transactional
replication and want to know whats in this table.
What clears of the contents from this table and when ?
...
Wed, 22 Dec 2004 19:53:45 -0800
|
what is sqlserveradhelper
Hi, I looked at the services running on my machine,
one of service called "sqlserveradhelper" is not running.
Just out of curiocity, what is it for?
...
Wed, 22 Dec 2004 15:50:44 -0500
|