Congrats Gail... Party Time.. 🙂

For the type of replication you have in mind, the administration cost is higher. Set up is also difficult. But rest of them I do not agree. If you are...

happycat59 (8/18/2009)

---

With SQL 2005, it is quite easy to have schema changes replicated. When you create the publication (using stored procedure sp_addpublication), use "@replicate_ddl = 1" to enable replication...

The only thing I can think about is the field separator. If there is a tab character in one your data field, that could cause issues like this. Tab separator...

Does this table that is being snapshot have a Identity column? What is set up in the publisher table for that column? Or it could be a timestamp. Both of...

If you want Bi directional updates, then you should look at Merge replication. Replication can work with FTP. If you are connected over VPN, then it makes it easier. You...

There are only some things that you can change. For instance, your Publisher has char column, you can make the subscriber a varchar but it has to have same length....

Thank you. The old data will be cleared automatically. You do not have to worry about that. Just keep in mind that the more transactions you have (update, insert and...

Jeff Moden (8/17/2009)

---

Roy Ernest (8/17/2009)

---

Thank God that I dont write blogs... At least meaning full blogs. I have only moaned on my blog and no technical stuff... I am clever,...

Thank God that I dont write blogs... At least meaning full blogs. I have only moaned on my blog and no technical stuff... I am clever, keep away from techinical...

The error says that there is a problem with your install. You should re install it / repair it.

Thanks Gianluca for clarifying it. 🙂

Does the try catch work for all cases? For instance if the error is a deadlock, doesnt itjust fail the batch completly and not go to Try Catch? Just out...

No one has done anything with my articles either... But I know why...:-) I havent written anything that is worth plagiarizing 😛

Maybe the next article if I write any, I...

I have seen latency about 5 min to 10 min max. In our envirnment, 3 seconds is the max I have seen, but one day is bit too strange. Thats...