Thanks again.

Thanks for the information all. I have changed one criterion. I no longer need an editable environment. Therefore, since Transaction Replication seems to be more conducive to...

From what you were telling me, Transactional Replicaton is always one-way. I assumed it was or could be both ways; the publisher updates the subscriber, and the subscriber in...

So, when using log shipping, as the log updates the data base, users are kicked out, or is it that when the log is updated?

What I am looking for is...

Chris Morris-439714 (3/4/2010)

---

Haven't you looked to see what you're updating?

Apparently not, but thanks for the advise.

That was it. The nulls are not null values, but 'Null'... I didn't see that one comming. I imported this from Access, mabe that is where the...

First, I'd like to say I like the Doberman. That is my breed, and I lost my best friend almost 3 years ago. She was 7, loyal, very...

Thanks David, I'll give it a shot. Do you use Merge instead of upate for all "updates"?

edit: You're correct. Thanks.

Now a problem with null values. The concatenation will not work with null in the comments2 field. How do I make this work?

In...