Alright, I would then ask them to install the software on your domain and see if it works.  If it does then accept the contract, if not then return it...

I would be extremely surprised to learn that.  However it may be the case if they are using more advanced services like the integration services.  I would ask them which...

Have you tested if there were any difference between a deterministic function and the same function with the option "with schemabinding" which then becomes deterministic to the eyes of the...

Since when did temp table stop accepting indexes. This is a real table. The fact that it resides in tempdb doesn't change it's nature. You can add...

I always wondered about this. What is the cost of calling a deterministic function in a query (executing on every row low exists) compared to using the code directly...

Yes looks for the "implicit_convert" keyword in the query plan. Might not seem like a problem but it often can become one.

Not sure if you know this...the return value of a stored proc must be an integer. Any other datatypes have to be returned via output params.

Can't comment on this... I just started developping on 2005 .

Still forces a scan...

As I said to him in PV.  Sometimes you're stuck with it !.

I'm not expert on that matter.  All I can propose is that you search this site on "change management".  You should find some answers there.

Hmmm yup that's it (confirmed by a coworker).

I don't have the install file here.  Can you list me all the main componant options?

LOL, this is what you get for not being clear.  I was expecting a cute story like a DBA woops but it  looks like it'll have to wait.

In very short yes.  Except maybe that you need to have a backup of the production and test databases (before/after) and also you need to have a script to test...

Do you have installed the client access tools (did I name this right) on the pc you want to use to connect on the server?

Restart the sql server 2005 installation and...