Oooohhhh.... I might be in trouble... I've got buckets full of things that look...

So! Did it work? Enquiring minds want to know! 😛

Holy moly... you are a very patient human... 470 hours... 19.58 days. And to think I get ticked...

I think he's just a friggin' troll... I've seen ID-TEN-TEE's like that before. I...

I am certainly looking forward to that....

DUDE! Those are the best groomed pork chops on a stick that I've ever seen!

Heh... I realize it's probably a little late now, but I'd get another vendor or write the stuff myself. That code and database design sound just absolutely horrid and...

J (1/13/2009)

---

As far as a server option to make a WHERE clause required, I can see some benefit, but it really is to protect idiots from themselves.

If you type:

[font="Courier New"]DELETE...

GSquared (1/13/2009)

---

So, two mistakes, neither of which would have mattered all that much by itself, but together made a problem that mattered, which could have been prevented with a...

Michael Earl (1/13/2009)

---

As far as the join style - Jeff, you are crazy. The JOIN keyword is much more readable. Ok, you are not crazy, it is all...

Cool... thanks for the feedback, Jason.

Felix! Are you all set?

Steve Jones - Editor (1/13/2009)

---

Jeff,

I agree, he's probably not going to get the job, and probably shouldn't, but given the people I've interviewed and talked with others about, maybe he...

Lookup DBCC SHOWCONTIG in Books Online. Example "E" is what you're looking for if you don't mind using cursors. I personally won't use a cursor (including the monster...

...or just dump it into some dynamic SQL. Or, if the tables change every month, have some dynamic SQL build a proc for you. You can even build...

The RAISERROR with the NOWAIT clause is certainly a way to do it... and then, you have nothing but something printed on the screen. No way to do any...