You can observe that the query compiler will use a constraint as it would an index.  As pointed out above, a UQ is enforced by creating an index.  If you script out...

What ShekharNaidu said.  Also, the notion of a avoiding writing to the transaction log, even if it were possible, is out.  Transactional replication uses the transaction log to create commands...

OK now what type of replication?

Hi Nikie,

I think it would be unwise to do a "repair allow data loss" on a subscribed table. 

In my opinion you should figure out if the problem is in an index,...

Hi Igor,

I don't think that a dropped packet should cause that kind of behavior, because the client wouldn't know that the packet got dropped until after TCP quits asking IP...

I would look for everything to/from the client.  You might discover that the client isn't always talking to the server like you think it should be.

"I'm assuming it would be enough to just go through the functionality of the program "

That's pretty much it.   Actually you would want to test for anything that you couldn't...

Hi Igor,

You might want to check out a network trace or two.  The default timeout is probably longer than "very quickly"

I use something...

I would spend all my time testing the upgrade to 2005, rather than going from RTM to SP4 on the current box, assuming that the "next few months" timeframe is...

I would suspect that for some reason the client is not reaching an alternate DC to get authenticated within the ConnectionTimeout period.  I can't find any information on what the...

"...This causes a short disconnect between SQL and the DC it was talking to..and causes the DTS to fail..."

I'm curious as to how you were able to make this determination. ...

Hi Seth,

I think there is still some work that needs to happen on the configuration of the DTC on your remote server.Try looking at this http://support.microsoft.com/kb/817064/

Indeed.  Here's the single agreeable point made in this entire discussion, and it was gleefully overlooked by all but one.

Ok, now two.  Whenever you have to consider the potentially dangerous...

What is a BOL?    heh

jg

Hi Larry,

The expression evaluates to Unknown.  It is neither true nor false.

Try this

If NULL = NULL    Print 'True'

If NOT (NULL = NULL)  Print 'False'

The problem with the question is that...