Transaction Replication (SQL 7.0 sp3)

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Import/Export (DTS) and Replication (2000)

Transaction Replication (SQL 7.0 sp3)

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-02-04 : 09:54:01

Kamal writes "Hi,

Currently we have setup/configured transaction replication and it has been working reasonably fine.

Now we have new requirement, We have to FILTER the data (horizontal partioning) so I have added/defined two seperate publications (each has Filter cluase joining to a view etc.)

When I publish the first publication (publication 1) the appropriate agents get started and the script/data applied to subscriber. But when I publish the second publication (publication 2) it starte with Snapshot agent and it seems like it go thru creating the script BUT WHEN WHEN IT TRIES TO BULK COPY THE DATA IT GET STUCK ON "LOCKING TABLES ....." and after few attempts it goes in cycle to regenerate the scheema....

I know it is tough one but any help would be appreciated.

Thanks,

Kamal Hassan
Database Consultant
MD Robotics
(905) 790-2800 ext. 4849 or 1-800-891-7727 ext. 4849"

dooncomputer
Starting Member

2 Posts

Posted - 2002-02-07 : 11:46:23

quote:

Kamal writes "Hi,

Currently we have setup/configured transaction replication and it has been working reasonably fine.

Now we have new requirement, We have to FILTER the data (horizontal partioning) so I have added/defined two seperate publications (each has Filter cluase joining to a view etc.)

When I publish the first publication (publication 1) the appropriate agents get started and the script/data applied to subscriber. But when I publish the second publication (publication 2) it starte with Snapshot agent and it seems like it go thru creating the script BUT WHEN WHEN IT TRIES TO BULK COPY THE DATA IT GET STUCK ON "LOCKING TABLES ....." and after few attempts it goes in cycle to regenerate the scheema....

I know it is tough one but any help would be appreciated.

Thanks,

Kamal Hassan
Database Consultant
MD Robotics
(905) 790-2800 ext. 4849 or 1-800-891-7727 ext. 4849"

dooncomputer
Starting Member

2 Posts

Posted - 2002-02-07 : 11:47:45

So far no one responded, I guess I have to contact Microsoft.....

Thanks.

Kamal

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources