Thanks SA_from_CA.  Your experience is my fear come true.  Think I'll wait and see if MS makes any progress with the next SP before making the switch.

griffin43 wrote: "The one glaring problem I see is that the Database Design GUI does not work...This change is no problem in SQL2000..."

Not meaning to hijack the topic, but like griffin43, I'd...

I'm probably one of the most technologically challenged IT professionals out there. 

For example, I own a $20/month cellphone that I keep in my car in case I run out...

David asked about business justifications for moving to SQL Server 2005.  As Steve mentioned in his article, support for SQL Server 2000 will eventually wane (both from Microsoft and the...

I once read the following quote that always stuck with me:

"If you do a good job for the sake of doing a good job, then you'll always be working for yourself."

I'm afraid that I'm unable to take the content of this CNN/Forbes article seriously.  This fluff piece reads more like paid advertising to me. 

Thanks to both of you.  Very helpful!

It occurred to me that my question might be a little easier to follow if I provide some sample data.

Examples of ReligiousAffiliationDescription values would be: Jewish, Christian, Muslim, Buddhist, Hindu.

Examples...

Sorry, I mixed the table name with the field name in my example.  I should have written WHERE ommemo LIKE '%W034%'.

After submitting my post, I read that you're using the LIKE clause. ...

Somebody can correct me if I'm wrong, but I'm afraid that FTS might not be a good approach for your tracking numbers.  First, FTS is meant to be a word...

You're right.  I should've been modifying the .enu file.  It's always the little things.

Thanks a lot!!!

"A no brainer"?  "Limiting the discussion to DRI...isn't much of a debate"?  "If you participate in these forums...you enforce foreign keys in the database"?

Jeffrey, did you read the...

Alright...moving beyond foreign key constraints.

When the alternatives are either to enforce data integrity in the business layer of an application or in an underlying database via any kind of constraint (primary key,...

The topic of this discussion is DRI.  By definition, DRI is implemented via foreign key contraints.  Enforcing referential integrity with triggers is not DRI. 

The business layer vs. trigger debate...

I don't think the issue is whether or not a rule is a "business" rule. 

When determining whether or not to enforce a business rule via the database, the issue is,...