The movie is great. If you don't like it, you owe me 1000$ per post I answered for you :P.

Floppy? whats' that :w00t:?

Ya that too. If you post the table DDL, then maybe we can have a look an point you out in the right direction... assuming there's something wrong with...

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