I have set up replication between where I am (Caribbean Isles) to Asia. The one thing that we had was VPN and a pretty good connectivity. We never faced this...

Thanks for the update. Others might find it useful. Glad things went OK.

That peace of code looks like a cross between Insert and an Update... 🙂

You can start them back. It is just like rebooting your servers. Since you publisher is in Full mode (It has to be in full mode since it is replicating)...

Did you try stopping the log reader agent and distribution agent?

You can use Alter database to move it to a different drive. The usual method is to

Run ALTER DATABASE NameOfDB SET OFFLINE.

Move the file to the new location.

Run ALTER DATABASE...

The error "Transport Level error" usually happens when the connection to the DB is disrupted. It could either be the network layer or your DB is disconnecting your session for...

Thanks Vincy. In SQL 2008 there is a command called Merge that does almost the same thing that I discussed. This was written during the SQL 2000/2005 world.

Yes, It is the same for rollback as well. At least from my testing it was that way.

As far as I know, there is no need to change any code. This is set in the Database level. Also keep in mind that the Isolation levels will not...

Actually this is what Gail was talking about. Row level version is set up using Snapshot isolation level.

Anyways here is an article[/url] that I wrote here. But I cant...

When you set up row level version on your Database level, you do not need to give Isolation level for your user individually. But keep in mind that there will...

You have stated that you have SQL 2008 with OS 2008. Here is something for you think about if it will solve the issue. Row Level Version. If you enable...

I do not think that is possible, But I do have a question. Why would you want give that ISOLATION Level? Since you are in SQL 2008 forum, I assume...

GilaMonster (5/6/2010)

---

Grant Fritchey (5/6/2010)

---

Hmmm... They never even asked me how many questions I answered. I think if you took away the number of times I said "do you have an...