quote:

---

...when I tested the column for an update with a date earlier than the CHECK condition, I found that the constraint was...

I have trouble with blanket statements such as "Stay away from public." In some, perhaps many cases, that is true. But sometimes it's not.

Public is used...

Here are a few things we do which no one has mentioned:

Regarding the id field, we use ID when its an autonumber which will be meaningless to users (eg intCallID);...

Good article. I too am amazed by how many people are willing to forgo primary keys on small tables. Data integrity always preceeds performance (esp such a slight...

I agree this is a great tool. We ran a lot of tests and simulated several disasters, all of which we recovered from. The interface is not entirely...

Two issues on the above statement:

I would write the commit trans statement as

IF @@transcount>0 COMMIT TRANS

Also, you are returning a value of 0, which indicates no error. Use RETURN(-1)...