True, no field in a primary key can be nullable.

CEWII

So let me see if I understand this, the last row has a number and then all the other "fields" are null/blank?

If that is true AND that NEVER happens on...

An impact would be that you can't test for an a NULL with = NULL you have to use IS NULL. NULLs are usually excluded from most aggregates.

NULL values...

Must have been a different post.. Either way identifying the last record is a big problem, especially if the structure is different.

CEWII

They are not mutually exclusive.

A primary key represents a unique key for a record. A clustered index is an index that also controls HOW the data is stored. ...

I am usually against manual solutions. I have to say that having to card the data accross town is a deal breaker for me.

CEWII

That has already been suggested and discussed..

CEWII

Database mirroring where you guarantee delivery requires two phase commit, which even on a local network is expensive, you need to be REALLY careful with that.

CEWII

Named instance on the same box. Can't do it. Names MUST be unique even among different versions.

Better question, WHY would you do this?

CEWII

Getting the resultset out to a variable is the easy part. I can explain that, the problem is that there are only a few components (one I can think...

I'm a little leary of log shipping in this case.. What maintenance do you do on this data? Re-indexes and such?

I think you might be looking at "Sync...

Todd, I think that sounds good.

CEWII

How many tables are we talking about here. 3% is about 18GB, does that sound right?

CEWII

No, sorry.

CEWII

Good luck, there is a LOT to it..

CEWII