You all go french, I will go malayalam. (My language) ... 🙂

Merry and Mary... Not much difference... 🙂

I got a good laugh with all the messages... 🙂 I will make sure to Drink , dance and be MERRY and not mary... :hehe:

it is carnival weekend here. From tonight onwards it is "Drink, Dance and Be merry" here. 🙂 I think I will not be sober till Wednesday.. :hehe:

You have to run the Service accounts under Domain User. You can use SQL User to set up rest of the replication but it is recommended to use Windows Authentication

We are also thinking of this as well.

We have come up with a plan but we have not tested it yet.

ServerA - Old Server

ServerB - New Server

Restore the DB...

Bru, Just one correction....

You said that

You cannot replicate only Insert / Update transaction is Transactional Replication, you cannot avoid one type (delete) of DML Statements.

Actually it is possible to say...

I got the 2009 Pass Summit Session Recording DVDs... Yea..!!!!

Did you check the execution plans? It is most probably different.

Just a question, Do you have any Deny VIEW DEFINITION or CONTROL permissions for that user?

That was a very explanatory posting that you put up there. You explained all the points. I am sure the OP will change his ways from thinking Cursors are fast...:-)...

Ah Sorry. I thought you were asking about SQL 2008. I did not look which forum it was. My apologies.

I do not know any other way other than database...

That article is going to be a good read I think. I will be looking forward to it. I have never done Database mirroring. And I know nothing about it.

I think in this case Lynn is going to...

I think for this the best way would be to use Policy Based management. With this you can set it up to prevent or notify.

Just my 2 cents

Here is something that I have seen happen that has raised the undistributed commands.

1. When ever there is a network hiccup this raises its ugly head. And after that the...