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

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.