Lynn Pettis (8/27/2012)

---

Rod at work (8/27/2012)

---

Oh, really? I got the impression, from the Connect article, that UPDATE FROM wasn't a part of the ANSI standard. That MERGE...

Oh, really? I got the impression, from the Connect article, that UPDATE FROM wasn't a part of the ANSI standard. That MERGE was to be favored; and...

For me, it is overwhelmingly in favor of "Fix".

Thanks.

IowaTechBear (8/3/2012)

---

We have a few hundred databases spread across our state in multiple data centers. Our standard backup policy (to Tivoli TSM) is a weekly full backup, nightly differentials and...

1 production

1 developer/test, which is a copy of the production

Steve Jones - SSC Editor (8/2/2012)

---

We have "Newbies" forums in all areas, or most of them. This...

ralph.bacon (8/1/2012)

---

So true. I'm a "solutions provider" / "developer" / "current vogue name" writing SQL-based intranet (dot net) solutions.

Whilst I have a rough idea of what is going on behind...

cksid (7/31/2012)

---

I'm not a true DBA admin. I work with the SQL tables and such. I would like to learn how to set this up. Can someone...

I've never heard of this. Probably because I'm an accidental DBA. I think it is a brilliant idea! I'm going to be watching this thread with great...

That is really cool, Grant, thank you!

I'm afraid that unless it is free, my management won't consider it, so SQL Prompt is out, as is anything else that costs.

Ah, programming. Definitely where I feel most "at home", as I am a programmer first, and then an accidental DBA second. However, I've been programming for a long...

I think you nailed it, David. I just disabled that update trigger, and I can now update values in the Providers table fine. Man, that's irritating! I've...

I wasn't the one who wrote that rather convoluted code. I'm wondering if it could be done better, or differently, now?

I hadn't thought of triggers. There are 2 triggers on the Providers table. The first one written back in 1999, for INSERT only, is this:

/*

* PREVENT NULL...