Very true Remi - hmm.  Learn something every day   Still think it's not the smartest, but it is the way it is...  I...

Firewalls on your client or on the SQL Servers?  Can you connect to the server using something simple like OSQL?  Try windows vs SQL auth

osql -u USERNAME -p PASSWORD -S SERVERNAME ...

If you're ever bored, please try it and let us know

I think having them clustered could certainly help if you were after...

Definitely the current SET options can impact on your code and the query plan used - things like CONCAT_NULL, ANSI_NULLS, etc make changes to the way the query engine processes...

SQLServer won't be helping you with the decompression - what client side development environment are you using for this?  Is there another column in the table which lets you know...

I don't think it is a difference between standard and enterprise, but probably in the various SET options that are enabled or disabled.  Remi is right though, if you are...

It still comes with all of the command line tools, eg "osql"

Server registrations in enterprise manager will not affect, in any way, the actual server itself (ie uninstalling, stopping service, etc).  I can have the same server registered twice - but...

Beware that your transaction logs on the databases in the full recovery model will grow quite a bit as they won't be truncated.

Personally I thought you always had to have the inner join syntax - nice to know you didn't need it

Out of curiousity, were...

Damn I'm always here too late (Australia time zone!) 

Yeah, the inner join delete is really neat - looks funny the first time you...

I agree, it's odd that you would want to insert into another table's identity column...

If you were doing something with (for example) orders and order details, linking them on

orders.orderID  int  ...

It's a stated rule in BOL - you have to use aliases on table variables to refer to them in where clauses, etc.  I've just tried finding it but I can't...

I haven't look into the error number and what severity level it is, but if the severity level is high enough, it will just terminate whatever you are doing -...

I would be interested to see if that is the case - the main reason I'm still with Crystal is because I can use it with MSDE.