Aaron,
> also I would use smalldatetime for orderdate, since I don't need fragments of seconds...
The year range span is far more important the the milliseconds, with smalldatetime you are making the system vulnerable to the next "Y2K" problem that will happen in 2079.