Replication monitor shows duplicate merge subscription
Fri, 19 Sep 2008 07:55:10 -0700 (PDT)
I had a merge replication subscriber where I had to recreate a push
subscription but it wouldn't create, saying the subscription already
existed. I ran sp_dropmergesubscription on the publisher and then ran
sp_helpmergesubscription and verified there was no record for that
subscriber in the output. I recreated ...
|
removing a linked server
Fri, 19 Sep 2008 04:51:00 -0700
I need to remove a linked server and I am getting an error code 20854
indicating the publisher cannot drop the server because it is used as a
subscriber. Is there a reference document anyone knows of that can explain
the proper process for removing linked servers. I have tried to do this with
the servers d ...
|
Log shipping and compression
Fri, 19 Sep 2008 03:39:01 -0700
Here's the scenario....
I have a one-off database script that after completion results in the
production of some large transaction log backups for log shipping on SQL
Server 2005. In order that these backups do not take forever to copy from
primary to secondary, I wondered if it is possible to compress them ( ...
|
Cannot configure distribution database
Thu, 18 Sep 2008 12:08:01 -0700
Can someone help?
I had setup transactional replication and it was working great, but I had to
remove it due to some issues with the application/schema. Unfortunately, I
did not use the Wizard to remove the publisher/distributor and now when I try
to reconfigure replication I get this error message: ...
|
Cannot configure distribution database
Thu, 18 Sep 2008 12:01:01 -0700
HELP!
I had setup transactional replication and it was working great, but I had to
remove it due to some issues with the application/schema. Unfortunately, I
did not use the Wizard to remove the publisher/distributor and now when I try
to reconfigure replication it bombs out on me when configuring the
di ...
|
Is it possible to send binary data using RDA SubmitSQL method?
Thu, 18 Sep 2008 11:38:42 -0500
I have an application and I need to do an insert into the database but part
of the data is an image stored in the compact database. As long as I'm
inserting text data everyting is fine, however when I add the binary data to
my sql statement it ends up looking like the following:
"INSERT INTO eWorksheetSign ...
|
strange merge replication issue
Wed, 17 Sep 2008 23:39:01 -0700
We have a table(TAB1) with 3 triggers(UPDATE,INSERT & DELETE).
On any update on TAB1 the trigger updates same columns with the inserted
data in TAB2.
The triggers are : "NOT FOR REPLICATION"
TAB1 & TAB2 are in merge publication(same one)
Recently we had a strange scenario:
Update of TAB1(COL A)-> the update ...
|
|
|
SQL 2005 Merge Replication - Drops identity range constraint after
insert.
Wed, 17 Sep 2008 09:41:36 -0700 (PDT)
Hi All,
I have setup merge replication with sql 2005. I am trying to a add a
new table with a primary key (with NOT FOR REPLICATION set ) to the
replicated environment.
When I include the new table in the articles to be published i accept
the default table properties with regards to Indentity Range
Managem ...
|
Transactional replication fails with connection refused error
Wed, 17 Sep 2008 08:32:01 -0700
Hi,
I've setup transactional replication on 4 SQL Server 2005 clustered servers.
I have three different publications all configured as push with the
distributor running on the server with the publications. it looks like this:
Cluster 1 has 2 databases that have 3 publications -distributor is here
Clus ...
|
Merge Replication Fails with LOB Columns
Tue, 16 Sep 2008 15:51:01 -0700
We are having a problem with merge replication via the web. We usually get
the following message:
The merge process could not replicate one or more INSERT statements to the
'Subscriber'. A stored procedure failed to execute. Troubleshoot by using SQL
Profiler.
Occasionaly we get out of memory errors.
...
|
