I know that what I am suggesting is not a query optimization method. You stated that the results never change. It is a static table. Why not just load it...

Silverfox (11/26/2009)

Yeah welcome back.

Just wanted to say Happy Thanksgiving to...

Actually I like the idea of replication. But instead of an updatable replication topology, it could be a Non updatable transactional replication. Once it is time to pull the plug,...

Ian, I am not sure about it. Merge replication is my weakest point in Replication. I have never done it. You have a good point

First set the output for the Query analyzer to the max it will allow and then run sp_scriptpublicationcustomprocs 'publicationname' on the publisher. Once that is done copy the text that...

Just like the error states, you have some network issue between your Laptop and your SQL Server. Are you able to ping the DB Server? Does your Laptop have a...

Merge should be possible in your scenario. Check in Books Online for Merge replication.

The only thing that could keep it big then is that there are some commands that are that has not been replicated yet. What is your retention period?

Welcome back Barry... Lots of concerned people around here.... 🙂 Glad to see you back

Happy Thanks giving to everyone who celebrates it... 🙂

I will make sure that I wont give bad advice to anyone.... (By not giving any advice...) 😀

Back up restore with No initialization is the fasted method. Just make sure that you check the tables in the subscriber for Identity columns.

Alvin Ramard (11/25/2009)

........ and the winner is ... (drum roll) ... Oh,...

Is it failing? The distribution agent clean up Job?

Try running the the clean up job from the SSMS under your Account and see if it is giving any error or...

You can see that in the replication monitor. You just have to choose the Agents tab and from the drop down box, select the Log reader

Setting up transactional replication is quite easy in SQL 2008. Couple of things to keep in mind is that the Service and agents should run under a domain account and...