Sure, and I get that, it's just me perhaps being a bit over paranoid, but it comes down to what you said at the end of your editorial, I wouldn't...

So they're using SATA drives to create these arrays. Right? Here's my beef with this technology and I'm sure they have some way of dealing with it, but...

Also, If you're using linked tables remember that the entire table is brought back to access before any join procedures can occur, so when you do it all on one...

Thanks for the input guys. I really appreciate it.

-Luke.

As was mentioned by a few others... You have to trust someone, somehow to do certain things. If it's not the DBA and Sys Admins, and/or auditors, then who...

I used to work between 60 and 80 hours each week, but then I moved, got married and found a new job where I worked between 40 and 50 and...

Also check out the section in BOl about GetExecutionErrorInfo Method

I'm not sure if DTSStepScriptResult_DontExecuteTask is supposed to raise an error or just tell the package to skip that particular task? BOL is somewhat vague on the subject. ...

Do you have the c:\...\users.txt hardcoded, or is it passed into the data load from your activex script once the activeX script finds the file?

Any chance you could post...

This is what I'd suggest also, particularly if you a decent amount of free space on your local machine. If you do you SQL backups to disk first, you...

Just a quick thought... I know you said you can't normalize the table, but is that because of restrictions placed on you by the application that interacts with it? ...

The easiest way I've solved this problem has been with a product called ServersAlive. http://www.woodstone.nu/salive/

You can setup 10 checks for free(non expiring trial), or pay a nominal fee for...

Thanks for the insights guys.

-Luke.

I've not used it, but I was just reading te below link yesterday.

Perhaps it could be of use...

http://googleblog.blogspot.com/2007/06/google-and-open-source-ocr.html

but I already have a unique column, ID as the primary Key as there was really no good way to come up with a natural PK in this instance. ...