SQL Server 2005 : define a transactional replication where delete
instructions are not replicated
Wed, 23 Jul 2008 17:47:55 +0200
Hello,
Did anyone perform a transactional replication where delete instructions
are not replicated ?
Advises would be very appreciate.
Regards ...
|
Missing owner specification in replication of schema changes
Wed, 23 Jul 2008 07:50:32 -0700
I have a problem with replicatin schema changes via ALTER TRIGGER.
Wondering why they are transferred correctly, but not executed I found
the problem in the exists clause which preceeds the statement.
Here is the excerpt from the sysmergeschemachange of the subscriber:
if object_id(N'[Trigger_Karteikarten_Er ...
|
Which account on SQL 2005 web sync via https
Wed, 23 Jul 2008 07:02:04 -0700 (PDT)
Hi, environment is SQL2005 [wkg_sql] non domain & IIS6 [wkg_iis] non
domain.
My steps are same as the steps in the following three articles:
How to: Configure a Publication to Allow for Web Synchronization (SQL
Server Management Studio)
http://technet.microsoft.com/en-us/library/ms345211(SQL.90).aspx
How t ...
|
RE: Error 20026. The Publication does not exist.
Wed, 23 Jul 2008 13:39:57 GMT
I need to clarify my earlier explanation - I restored again, this time not using the 'keep_replication options' for the restore. Seem to correct the problem!
From http://www.developmentnow.com/g/114_2008_7_0_0_442369/Error-20026-The-Publication-does-not-exist-.htm
Posted via DevelopmentNow.com Groups
http://w ...
|
RE: Error 20026. The Publication does not exist.
Wed, 23 Jul 2008 13:34:56 GMT
I restored the database in question and did not use the 'retain replication settings' on the restore panel. I refreshed the publications, and the replications references were gone!!! I did not find any reference to the publications in any of the distibution databases. Restore the database without the replication set ...
|
Merge Replication Error
Wed, 23 Jul 2008 04:29:00 -0700
Hello NG,
we encounter (not always but in 0,5% of all cases) the following phenomenon
in a merge replication environment.
The following states of a datarow can be observed on the publisher
1) State A (Creation of the rowdata on the publisher)
--> sent to subscribers via replication
2) State A->B
after ...
|
Merge Replication problem
Tue, 22 Jul 2008 12:26:05 -0700
I have created a publisher on one SQL Server 2000 box for a merge
replication. When I create the subscription, I receive the following error:
Message
The schema script '\\NVIS\$SQLDATA$xxxxxxx_1.sch' could not be propagated to
the subscriber. The step failed.
I been looking everywhere for an answer but ...
|
|
|
Web Replication Problem
Tue, 22 Jul 2008 04:05:01 -0700
Hello again, and tg such a place exists.
I have a single publisher SQL2005 Standard to SQL Express one to many
replication topology for established customer info solution that using SMO
and ActiveX in CLR. The code is largely inspired by the AdventureWorks sample.
Replication flavour is subscriber pull usi ...
|
How Sql 2005 to cleanup replication inherited from Sql 2000 migrated table?
Mon, 21 Jul 2008 11:49:17 -0500
Hi all,
I'm trying to modify a table in SQL Server 2005 but I get the following
error:
Cannot drop the table 'dbo.aArtiEmp' because it is being used for
replication
But this table IS NOT participating on any replication. Actually replication
is not configured at all in the server. It is the short histor ...
|
Transactional replications - Distribution agents limit
Mon, 21 Jul 2008 09:09:03 -0700
Hello,
I have 212 publications for push transactional replications on SQL Server
2005 Ent SP2 + WinSrv2003. 190 of them between 2 servers.
And I have issue with Distribution Agents.
LogReader agents are working properly. All publications synchronized.
When Distribution Agents are starting they reach limit in ...
|
