Dead lock.

Took longer than the connection time out.

Hard to tell. I might suggest you script those changes out so that you can run them manually and have more control...

I don't see what you mean by repeat...

All I can say to you is that QA has the ability to generate the insert query templates. You can use that...

I wish I could answer that one without testing but I can't say for sure.

One thing I can confirm is that would not be surprised at all to see this...

No offense, but you can create a sp, why can't you use that statement to directly exec the sp_defaultdb procedure and skip the first step?

Something like that. Don't you hate that when you have to ask your mommy to go to a conference like PASS :hehe:?

My access trick always worked... maybe the fact that no GUI interferes with the code sent the server helps a lot in that case. Something to be said about...

How about something simple like adding a ident column into a table? Insert into that table. Fetch scope_identity() and user for filename. Delete the row.

I doubt you'll get...

Thanks...

In this case : Where MyCol < 'whatever' OR MyCol = 0

One implies a range seek and the other one an index seek (rid lookup). I don't see how...

Does that work in QA as well (I don't have it installed here... I can't check for myself, and I'm guessing it can help someone else as well)?

What I did to get myself out of this one is this :

Open up access (or anything where you feel good about coding a bit). Create a connection object....

Now that's a blow below the belt... of course I was not even born when that program was created so I don't have much arguments for it either ;).

Doesn't the or in the end kill any change of an index seek?

Because of decimal (x,2), you lose the last digit from the value. Then the convert to int kills the rest of the decimals, this is not what is asked...

I had never thaught of that for you Loner... but it's an awesome idea. You should definitly go on as a freelancer. It may not always be as...