Oh sorry. Must have hit a sore nerve. Some of us need to not take things so personally. I'll leave the lock out issue to the experts...

Okay, I think I just found the perfect article for tkc to present to this fellow about ANSI SQL 92 standards and the differences of referential integrity in the MS...

So, stax68, maybe this guy is an old SQL 7.0 programmer. You might have hit on the whole problem for tkc.

quote:

---

what I'm saying about SQL 7 is that it doesn't have native support for cascade operations, unlike (as we know) SQL 8...

Hey gang, the guy needs documentation, I'm just giving him what he asked for. If you have some documentation to support triggers over foreign keys as opposed to what...

Here's another one from MSDN (Microsoft Developers Network):

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_da_0777.asp

quote:

---

Constraints

Constraints allow you to define the way Microsoft® SQL Server™ 2000 automatically enforces the integrity...

I'm not sure what you are saying about SQL 7:

quote:

---

...if you want to enforce cascade update/delete operations in SQL 7-, or to...

My thoughts:

Triggers = Psychic Prediction

Foreign Keys = True Referential Integrity

Whatever happened to those ERDs (for Frank, Entity Relationship Diagrams) and UML (Universal Modeling Language) Class Diagrams? Do they just...

Here is an excellent article from DBMS Online that will validate your argument

http://www.dbmsmag.com/9606d17.html

I'm with you. I find triggers to be too loose for enforcing true referential integrity and really...

quote:

---

I'd rather hire someone I like, that fits my team. Can't teach that.

---

To...

quote:

---

If a problem differs from text-book, they stumped. No ability to work things out.

---

Unfortunately, that...

Yeah, sure thing, Frank. However, I don't know anymore good acronyms if that's what you're interested in. Ha! Ha! Just kidding!

Sorry, you have misperceived the intention of my comment. My intention is to get you to understand the importance of backing up the database and...

quote:

---

...my NetAdmin didn't have the tape running on that server because he "didn't know" I meant to have that server backed up...

Well, if you can afford (and well should afford) another server, I definitely AGREE that you should back up to it. Hey, by the way, technically speaking, when you...