Hi David,

Please find the present topology below

Server1 - Publisher - SQL 2000 - SP4 (Test Server/Live server)

Server2 -Distributor - SQL 2005 - (cannot remember sp) DEV server

Server3 - Subscriber...

Hi,

I followed this post http://support.microsoft.com/default.aspx?scid=kb;en-us;324401 and did remove all publication,Subscription and Distributor. Configured SQL 2005 as Distributor/Subscriber and SQL 2000 (test server) as Publisher still getting error 8526....

David/ Bru,

Data model between Live and Development are different. This is the reason , I was asking whether any transformation is possible during publication. I will have to come up...

Steve/David,

Thank you. I will try you (r) suggestion and will report..

Cheers

Hi,

Finally, I have decided to work on another SQL 2000 server and created 2 transactional updatable publication and created subscription on my SQL 2005 server on same database for two...

Hello every one,

Im trying to create a publication on SQL 2000 server and error 8526 is reported. I have set the trace flag (-T8599) and still error seems to be...

David,

On running select * from Syssubscriptions following result is obatained

1-1virtual21Name00x000000000000000000000000000000000x000000000000ABFA0110

10CDCTesting21name00x85D7E4D0E819314A8DAE6B6AC8CEB2190x000000000000ABFC5100MSVRNET01

I was trying to create a first subscription on CDC TEsting database and having the problem . Apology if im not following your instruction properly.

Hi David,

Im not able to add SQL 2005 server as subscriber in SQL 2000 (publisher) Subscriber window.

ta

Hi David,

I have tested it with SQL Server 2005 as publisher and subscriber It works just fine. I think we need to resolve some compactability issue.

ta

Hi David,

Im sorry result is unformatted as I have copied it from remote server.

Publisher output :

Transactional publication of CommerceServer database from Publisher NTPP12.,ShopVariant,3,0,1,0,0x407DE31B265D8F4BB476C52E26825B19,0,0,0,1,1,0,0,0,0,336,0,1,NULL,NULL,NULL,0,NULL,21,NULL,anonymous,NULL,0,0,NULL,14,NULL,NULL,NULL,10

Subscription Output

Msg 208, Level 16, State 1,...

Hi,

Even my first publication is now throwing an error "Error 8526 Level 16: Cannot go remote while the session is enlisted in a distributed transaction that has an active savepoint....

Hi,

I used EM to create publication. I moved Distributor to another server as it might overload my server in real scenario. I will try using SSMS and see how i...

Hi yeh,

yes, I have created second publication with pull subscription. What if I change this subscription to push?

I would like to explain my working scenaraio here.

I created Districbutor on...

There is no option for providing new name for sucscription. Can you help me here. I received error 14040.. My Distributor is running SQL 2005 and Publisher is SQL 2000....