You will need to add your service account to the second machine for Cross domain replication.

If it is Bulk Updates and Inserts, I will agree with David. But since you...

I hope for the company that he did not. If the OP had showed some interest in reading up on the links provided, I wouldnt mind if he got the...

Good news is that you can replicate across domain.

Bad news is you need primary key for transactional replication.

Does the query you run return lots of data back? If so, it could be a network issue. If you dropping packets or if you have bad Network card settings...

I see that everyone has answered the questions perfectly for the guy who had the interview. Perfect ...:-)

From what I see, he wants the answers in a silver platter... 😀

Hi Pramila,

Here is the problem you are going to face when introducing replication from B to C and B is restored. Every time you restore Server B, it will break...

Hey Gail, Congrats. And I read your interview.

I did like the part where you talked about bad advice. And that has always been on my mind when ever I...

Why would people encrypt the stored proc when there are so many tools out there that can decrypt??:blink:

It can be done...Couple of ways to do it. But I do not think it is something that the posters in this forum are going to tell you. You probably...

GSquared... I liked this one.... :hehe:

3. Fragmentation is what grenades do. Defragmentation is what military doctors do after grenades have done it.

Since it is SQL 2000, You will have to you will have to drop it out of Replication and then alter it and then add it back. Psuedo code for...

Barry, You have kept us in the dark about this till now. Time to reveal it..:)

ABCD puppies?

LMNO puppies!

SDR, CMPN?

Replication will still need to synch data. You will need to restore in Server B atleast once. Afteer that you can set up replication with no Snapshot of data. (That...

Take it easy guys.... Take it easy.

There is nothing wrong with using Identity column in your tables. It all depends on the situation and what your needs are.

sp_repladdcolumn in SQL 2000

In Sql 2005 as per BOL.

Adding a column to a replicated table article should be done by executing data definition language (DDL) commands against the published table....