|
Merge replication problem
I have one corporate server that acts as both publisher and distributor.
Remote locations all have SQL server loaded and act as subscribers. This
setup has worked great until yesterday. Somehow, and it is still under
investigation, the corporate server "lost" all subscriptions and became
disconnected from the ...
Fri, 14 Jan 2005 10:32:54 -0800
|
Alter column in a table that is being published for replication.
Ever get this wonderful error?
"Cannot alter the table 'XXXX' because it is being published for
replication."
Many of the posts I have seen regarding this subject suggest that you
"trick" the server into thinking that the table is not being replicated
by messing with the system tables. Then change the col ...
14 Jan 2005 10:34:28 -0800
|
Float data not replicated exactly
Why are float values not replicated exactly? For example:
33.333333333333343 -> 33.333333333333336
233.33333333333331 -> 233.33333333333334
I saw a previous post about this, but I'm not satisfied with the answer
"float is an imprecise data type". Note that I don't have this problem with
DTS, let alon ...
Fri, 14 Jan 2005 09:05:04 -0800
|
Queue Reader Aborting
I am using transactional replication with queued updating. The publisher is
located in Norway, with a single subscriber in the US. The Queue Reader
Agent starts successfully, and transactions originating on either side are
properly replicated. However, the Queue Reader agent eventually shuts down
with th ...
Fri, 14 Jan 2005 08:45:07 -0800
|
subscription status set to 'never started' but replication is ok
Hi I've got a win2k and win2k3 server both running sql2k sp3. There
are 5 transactional publications on one and corresponding pull
subscriptions on the other. Replication appears to be working fine
for all 5 but under 'subscriptions', 2 of them are red and their
statuses are set to 'never started'. What on ...
14 Jan 2005 08:19:35 -0800
|
Merge snapshot problem with views and ArticleType property with SQ
I am trying to create a merge publication with a snapshot that includes all
tables, views, procs, and UDFs using SQLDMO. I have no problems creating the
publication with tables only. When I try to add procs using the following
code I get the error
The @schema_option parameter for a procedure or function sc ...
Fri, 14 Jan 2005 07:39:06 -0800
|
Any alert system for Merge Replication Conflicts???
Not as far as I know.
I have a similar situation at one of our managed service
providers who won't allow us to set up alerts. In this
case I use a polling solution.
You probably know this anyway, but you would set up a job
to poll the conflicts table and send an email
(xp_sendmail if you're lucky enough ...
Fri, 14 Jan 2005 06:48:48 -0800
|
Any alert system for Merge Replication Conflicts???
Hello:
Is there a way to set up an alert to DBA (via email and such) when merge
replication encounters conflicts (so DBA doesn't have to check it manually
via Enterprise Manager)?
Thank you.
Chai W.
...
Fri, 14 Jan 2005 08:19:14 -0600
|
Table owner is not dbo.
I am trying to replicate a database where the table owner is not [dbo] but
[docsadm]. When I replicat the database to the subscriber all the tables are
duplicated where one set of tables has [dbo] as owner and the another set of
tables has [docsadm] as owner.
I tried to set the flag 'keep the existing table ...
Thu, 13 Jan 2005 20:27:03 -0800
|
Reason 126?
What does this error mean?
Cannot load the dll xprepl.dll, or one of the dll's it references. Reason:
126(the specified module could not be found).
...
Thu, 13 Jan 2005 09:33:47 -0800
|
Development & Lives databases
Hello all, apologies if i've posted this in the wrong forum!
I have 2 databases development and live. Development has the correct
structure (SP's and tables) and live has the correct data. I would like to
make live match the development database but not to loose any data. Is
replication the best method?
...
Thu, 13 Jan 2005 07:53:05 -0800
|
Error after Windows Update
Hi to all,
i have a win2k machine with sql server 7 on it, that is beeing fed with
data by another one, using replication.
The other machine is an sql server 2k and is the Publisher of the
replication
The machine with sql server 7, needed a windows update and so i did it this
morning.
After the reboo ...
Thu, 13 Jan 2005 12:04:53 +0200
|
Dynamic Filtering How??
Firstly, this only applies to merge replication. It is
possible in transactional, but you'd have to have
transformable subscriptions and separate DTS pachages per
subscriber.
Anyway, in the publication wizard for merge, select 'yes,
I will define filters....', 'Horizontally', 'Enable
dynamic'. On the ne ...
Thu, 13 Jan 2005 01:04:22 -0800
|
Dynamic Filtering How??
Hi
Can anyone guide me, I have following doubts.
I need to filter tables records to my subscribers dependign upon their
area for which I want to implement Dynamic filtering, now problem is
that some where I have read that for dynamic filtering I'll need to
implement Dynamic snapshot I don't know whatz that ...
12 Jan 2005 22:55:28 -0800
|
drop subscriptions
Hi all,
How can I remove a list of subscriptions from the server?
My server acts as PUBLISHER and SUBSCRIBER at the same time, but both
features has been disabled. So, I can't delete the subscriptions list
because I have no PUBLISHER and SUBSCRIBER now.
I've tryied with differents commands like sp_dr ...
Wed, 12 Jan 2005 21:03:07 -0700
|