Hi,

Thanks for sharing this idea.

I'm confused about one point, and have a design question on another.

As for the confusion, it appears that you've disabled the security feature if someone inserts...

Jeff Moden (4/5/2010)

---

Interesting idea but reality gets in...

I NEVER communicate IT options to management in IT terminology.

I always translate it into terms of money, time, business risk and business benefits.

If I do, I generally get very good...

Can't help you with finding that info in the registry or via wmi.

But it's easily available with the following query. Pick the value that best fits your need:

select @@Version...

True...

PaulB-TheOneAndOnly (4/4/2010)

---

david_wendelken (4/4/2010)

---

I start with the premise that the data is supposed to be valid. That's, on occasion, NOT a business requirement at all. (Sometimes the business requirement...

Paul White NZ (4/4/2010)

---

One part of the argument revolves around where integrity enforcement conceptually belongs.

...

In the real world, we have to compromise, and there is a whole spectrum...

Steve Jones - Editor (4/3/2010)

---

I'd argue that a large CRM/ERP application without FKs is just poorly designed. There are all sorts of support/administrative contracts in place to prevent you from...

I think that's why the...

I think the problem was caused by a two-step algorithm with interleaved processes.

Process stream A:

a1. Check for duplicate

a2. Insert new record.

Process stream B:

b1. Check for duplicate.

b2. Insert new record.

Now, let's...

Plus primary and unique key constraints, check constraints, non-unique indexes, default values, column and table definitions, and maybe even triggers. Plus database roles and privileges, clearly defined up front.

Yes, you definitely should.

But...

I'm not saying this to be mean, so please don't take it this way.

If you're asking "why should I do this?", you probably don't have the skills...

Some linked servers are set up to only work for a given set of windows authentications.

So, the job needs to be set up to run as one of those users.

There...

You're returning "navigation data" with 9 million rows in it?

Is that for a menu of choices?

Because if I understood that correctly, the solution is probably "don't do that". 🙂

I'm guessing...

That's ok. The odds are 99...