Scott,

No mourning the 'Wings?

I'll be doing some fencing in addition to the scooping. At least if I can get the telephone people to mark the underground wires.

MySQL scales and I actually like the architecture. Different storage engines can be swapped in. I'd never run without the transaction and PK/FK checks, but maybe you'd want them. What...

Whoops, sorry. As much as I'd like to use B in a few cases, it's really C. I moved the answers and corrected points.

Girish, that is not the case in logical operations. With an AND, only one operand is required to be false to give false. So if one side is false, it...

Miles,

Great comments and the risk issue is a big one that people forget about. I have some friends that are whizzes with open source, especially the LAMP stack and they'd...

For TRUE, you need (TRUE) and (TRUE). (TRUE) and (Unknown) means you don't know if you have 2 trues or one of each, so the answer is Unknown.

Wayne,

I was tempted to go with a Mac as well. We got one for the kids, but one thing I've noticed with them each having non-admin accounts, is that some...

Good luck and congrats on the job.

Typically in this case I've moved data into some staging table to hold it there. Then I'd do an update, joining the staging table...

It doesn't in SS2000. Possibly in ss2k5, but the easy way is to build a table and add a line of code to the stored proc to log each run....

Good luck and let us know how you do!

The code was obfuscated in previous versions and there were some procs to decrypt the code. I'm not sure if this applies in SQL Server 2005.

http://www.sql-shield.com/decrypt-stored-procedure.html

Please don't cross post. Answered in another thread.

AND evaluates two expressions.

(exp 1) and (exp 2)

If exp1 evaluates to false, it doesn't matter if exp 2 is true, false, or unknown. The entire expression is false. It's basic...

Will, when massaging out issues, are you working the entire table at a time? I could still see the need for a PK, even a surrogate one to allow you...

These can be hard to troubleshoot. It's an issue with the service account running SQL Server not being able to validate credentials. The service might not have an SPN in...