sql 2000 sp4 transactional replication issue

[kodaksmile]

We ran into an issue where we rebuilt replication using the same scripts we have always used and when we run the distribution agent it fails saying the process could not bulk copy data into table "x". We only replicate one table and only a few columns of that table. We generated the drop and create scripts (which are identical to the last ones) and ran the process. Any ideas? I saw an issue with sp3 but, both are running sp4.....

 

[mrdenny]

Fire up SQL Profiler and see if any errors are reported on the subscriber.

How many subscribers are there are your distributors?

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog

 

[kodaksmile]

Only 1 subscription

 

[kodaksmile]

When I recreated replication via the gui instead of the script it worked .... go figure.

 

[mrdenny]

Sounds like there is a typo in the script somewhere. At least it's setup and working.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog