July 1, 2008 at 9:54 am
Hello room,
I setup a transaction replication with a local distributor.
1.Sql 2000 is the publisher and local distributor
2.Sql 2005 is the subscriber.
I run into an error of:
Command attempted:
select * from "table_A" where 1 = 2
(Transaction sequence number: 0x00000F0A00004E68000500000001, Command ID: 129)
Error messages:
.ScopeChannel2_SD'. (Source: MSSQLServer, Error number: 7339)
Get help: http://help/7339
after the initial snapshot was completed.
Please advise and help.
Regards,
TJ
July 1, 2008 at 10:42 am
are you sure the initial snapshot was delivered successfully ?
* Noel
July 1, 2008 at 11:02 am
Not sure. However, it indicated completed.
The Snapshot agent’s status is completed.
The Log Reader’s latency is zero (0).
The Push agent’s latency is zero (0)
How to figure the initial snapshot was push completed?
Note: I did not have any problems with the others database replication setup.
July 1, 2008 at 3:04 pm
look in "View details" menue of the snapshot agent.
* Noel
July 1, 2008 at 8:36 pm
The snapshot agent did not generate any errors.
Action message displayed:
-- A snapshot of 42 articles was generated.
-- Posting snapshot command into the distribution database.
-- Buld copied snapshot data for article Table_A (571000 rows)
etc.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply