My first college experience was a Bachelor of Arts in Dramatic Arts, followed by a near-Bachelor Degree in History (just 1 term paper / class short when I moved out...

Unfortunately, only one of my servers is 2005 (the destination). The other server (the source) is 2000 and we can't upgrade yet because of an app that currently doesn't...

I agree that if you're using databases on the same server that a view definitely seems to be the way to go, but...

Even if you use a view to query...

Gregg,

You might want to re-read the article. Step 1. It actually does say "If the user is not a member of the local Administrators group, add the user...

IMHO, If datatypes are used correctly, no one should ever have to SUM() on a bit datatype. After all, it's supposed to be indicative of a true/false status, right?

For...

We've actually already started the re-write and we've gotten complete buy in from upper management on the issue. Especially when we told them what we were going to be...

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...