I found asolution. You need to add a DWORD "SessTimeout" to HKLM\SYSTEM\CurrentControlSet\Services\LanmanWorkstation\Parameters with a decimal value in seconds. I used 300.

If anyone has something more elegant I'd love...

this does not help if you have nullable fields

I just want to make a note, that if you choose the "OR statement" route with the null conditionals, be sure to do the following:

1. Make sure you hit...

I don't know... ask the authors of Access. I cannot control which identity is returned back...

Thank you for the quick response! Any suggestions to make Access behave?

If it were, what would the solution be? You think the session is expiring between SQL box and AD?

what does this do?

setprec "DTSStep_DTSExecuteSQLTask_2","DTSStep_DTSDataPumpTask_"&tsk

Thank you for the quick reply, I was looking at that property and wasn't exactly sure how to use it. I am going to test this today. I...

NOLOCK is primarily used for (semi) static tables. You are just eliminating unecessary overhead. Pretty much agree with everything you say though.

Are there any articles on this? What is meant by a table scan? You've peeked my interests.

if it's a static table, I'd recommend NOLOCK hints, so that no other resource needs to wait for the read to finnish. If you only expect one row, then...

some example data/query?

We already established that he doesn't care to have an identity field. worse case scenerio, he can add the field before he runs whichever operation he needs.

Warm Feeling-> writing code that compiles and outputs correctly the first time...ahhhh

Anyhow, I feel your pain... been there done that kind of deal... Putting the Identity field wasn't my point....

It gets inserted at the bottom of the table regardless. The clustered key is what would cause the insert to "insert" in the middle of the file (resorting the...