The process could not deliver dummy update
Tue, 8 Jul 2008 11:53:00 -0430
Hi everyone,
We have a merge replication, pull. With around 20 servers. We have 11
publications.
SQL2005 everywhere.
We recently configured web sync for some publications.
It seemed to work fine for a few days.
However, now the agents never end.We tried changing those agents back to
regular sync ( ...
|
Character,decimal,and binary parameter cannot have a precision of
Tue, 8 Jul 2008 08:05:01 -0700
We have transactional replication from SQL 2000 to sybase and
I had the following error in the distribution agent log as one of the fields
(varchar) that's part of the key was empty string:
Character, decimal, and binary parameters cannot have a precision of zero.
Error in parameter 3.
We had to delete this ...
|
Merge Replication Deadlocks
Tue, 8 Jul 2008 04:11:00 -0700
On our servers that participate in the same merge replication various
deadlocks happen. Below some examples. Iâ??ve done some research but have not
come up with a solution so far. What is the best way to prevent these
deadlocks from happening?
1) sp_MSupdategenhistory conflicts with sp_MSmakegeneration
2) ...
|
PULL Subscription in SQL 2005
Mon, 7 Jul 2008 11:25:00 -0700
Hi ,
I have couple of questions and appreciate if some body can answer
1. In case of SQL 2000 once we click on replication thru EM ,it shows all 3
agents on right side and shows it is PULL or PUSH ,but where i can find the
same in SQL 2005 to see if the subscription is PULL or PUSH?
2. for PUSH subscrip ...
|
Can you have transactional replication of blobs?
Mon, 7 Jul 2008 10:44:52 -0700 (PDT)
I am having an issue using transactional replication on a SQL 2005 SP2
system when trying to replicate an Image data type. The data won't
write to the Prod system, let alone replicate. However, when I remove
the table from the publication everything works fine. I show no error
in the log, but the app may be h ...
|
hard time to find the hotfix described in article ID:932674
Mon, 7 Jul 2008 09:04:01 -0700
I have the exact problem described in the following article, but it seems
that the hotfix is not available for download
(http://support.microsoft.com/kb/932674); the build version associated to
that hotfix is 2242
Is there a reason for why the hotfix is not available for download? ...
|
adding new subscriber to existing replication
Mon, 7 Jul 2008 01:07:39 -0700 (PDT)
We have replication setup already (bi-directional).
How can I add JUST a "subscriber" to the replication?
I want to do this with T-SQL.
There does not seem to be any documentation that says "here are the
steps to just add a subscriber in an existing replication
environment". The steps are more geared towa ...
|
|
|
What can be the source for replication?
Mon, 7 Jul 2008 13:59:44 +1000
Hi,
Is SQL Server limited to replicating only from Oracle and another SQL Server
or I can somehow replicate from some other ODBC database?
//Misha
...
|
Time out error synchronizing in one merge push subscriber
Thu, 3 Jul 2008 18:54:58 +0200
Hello!!
I've a Merge Replication with SQL Server 2005. I've one publisher and 12
subscribers, using push subscriptions. All the subscribers are sync fine,
except the last one that I subscribe. This one had no error while applying
the snapshot, but I'm not 100% that first syncs where fine. Some days ago I
s ...
|
Connecting to subscriber instance via business logic handler...
Wed, 2 Jul 2008 12:42:53 -0700 (PDT)
Hello,
I have a customer resolver for replication where I am trying to open
up a connection to the subscriber to execute stored procedures when
synchronizing the data.
This seems to work well with a LAN configuration, but when it is
configured for a web synchronization, the Open fails for the database
conn ...
|
