Thanks Perry, our developers were hoping that the transaction was instantly available on the sync. secondary. We will adjust expectations accordingly!

After some testing we concluded that this is an ordering issue.

If replication is configured and the distribution agent is initially pushed to the subscriber before foreign keys are created at...

I was able to resolve this by running sp_updatestats on the database before I made the final bak in SQL 2000.

Thanks for the reply, I tried exec sp_removedbreplication but it won't remove the SYNC_ objects from sysobjects. Even weirder, I can't restore any SQL 2000 backup that was backed...