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 2005 Forums
 Replication (2005)
 Transactional Replication

Author  Topic 

sasrook
Starting Member

1 Post

Posted - 2009-07-04 : 18:41:11

i used a script for transactional replication and successfully replicated 3 tables from sql 2000 to sql 2005.
but when i tried the same script for other table it doesn't work.

the table has a primary key and the agent jobs are running continuously.
the snapshot was also applied and it even showed bulk copy of 213 rows in replication monitor.
the log reader agent is also running.
but when i check the table is not created at all..

please help me how to figure it out or troubleshoot it.

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2009-07-10 : 09:48:20
Did all the jobs run? Check Error Log.
Go to Top of Page
   

- Advertisement -