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...

Oh boy, I shutter when I think that may be true. On the other hand, although that app plays a very critical role in our organization, fortunately for me...

Jeff Moden (6/18/2012)

---

Does the application really manage those things? Does the application allow for things like PKs/FKs to be turned off? Does the application require that you specify them...

GSquared (6/18/2012)

---

Jeff Moden (6/16/2012)

---

I'm not so concerned with people that use sharp spoons to chop down the tree. It's the ones that think it's really cool to use six...

Thank you, GSquared.

That's really nice of you, hisakimatama, to be thinking of your parents as you are.

sburcombe (6/1/2012)

---

I'm definitely an 'a.' Love my job, and work with great people. The only drawback is that in this area, qualified people are in very short supply. Good thing...

"C" was mention in the video podcast for this editorial. I watched...

cphite (5/3/2012)

---

Rod,

Based on the above, my understanding is that you can access the reports via the ReportServer URL but not via the Reports URL... is this still the case?

Maybe...

spivey (5/11/2012)

---

Its usually less about time, and more about "brain energy". Its easy to spend the time and energy researching a current problem or reading a quick article. ...

Megistal (5/11/2012)

---

Easy question, none (no hour per whatever period) are officially allowed.

You are granted to read something if it's directly related to the work being done right now (not tomorrow...