Perhaps, but the biggest "term" we have is 7 years. Plus, we already have plans to get off the current system in the next five years anyway.

And...

Ha! I think I found it. Looks like a SUM( ) was probably the issue. And SQL Server didn't implictly convert it up to a smallint or...

I have so many mathmatical expressions in this one particular query, each of which use the tinyint, that I'm not sure which one set off the problem. I'm using...

And to follow up Andras's post, Yes, you need SQL Server (or at least the client tools which connect back to the main server) installed on every machine that you...

Aaron,

Your problem is your WHERE clause.

If you're using an OUTER JOIN and then you use a WHERE clause to define something in the "inner" table (in this case your...

HA!

The twinkie comment just made my day. @=)

They must have made it out of the same material as the Great Pyramids of Giza. @=)

Ah, yes, interpretation is key with SOX, especially as the law itself is so vague.

This is one of the reasons I recommend checking with other departments within your company or...

Oh, DUH! Ninja, you're right. I do have dates outside of that range. And here I thought it was the stupid millisecond thing.

Although, how anyone came up...

Liliya,

That actually might be one of those little things that differs from auditor to auditor.

None of the local department ITS support groups in my workplace have actually been...

To be honest, we don't have an Administrative DBA. We just have a small team of 3 DBAs who do it all, Operational, Development and Administration. Yes, a...

Megan,

In the text file, I don't see anywhere where @PO is being declared or set. that might be part of your problem. Not sure if that's the sum...

Actually, I found an easier way. Apparently Access 2003 DOES allow upsizing the table structures only.

Last time I upsized a DB, it was Access 97. Talk about behind...

Really? Because when I took the 70-431 exam, the sims were timed differently from the rest of the exam.

There are new datatypes in 2k5, and text / ntext / image datatypes are due to be depreciated in the next couple of versions, but I don't think they actually...