Viewing 15 posts - 9,376 through 9,390 (of 9,725 total)
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...
October 10, 2007 at 8:26 am
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...
October 8, 2007 at 4:26 am
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...
October 5, 2007 at 1:28 pm
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...
October 5, 2007 at 12:59 pm
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...
October 5, 2007 at 12:40 pm
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...
October 5, 2007 at 9:44 am
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...
October 5, 2007 at 8:28 am
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...
October 5, 2007 at 8:25 am
HA!
The twinkie comment just made my day. @=)
October 5, 2007 at 6:16 am
They must have made it out of the same material as the Great Pyramids of Giza. @=)
October 4, 2007 at 9:07 am
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...
October 4, 2007 at 5:25 am
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...
October 4, 2007 at 5:19 am
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...
October 3, 2007 at 7:37 am
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...
October 3, 2007 at 4:03 am
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...
September 28, 2007 at 10:39 am
Viewing 15 posts - 9,376 through 9,390 (of 9,725 total)