1) Try this.

SELECT LEFT((CASE

WHEN DxAge >= '0' AND DxAge <= '10' THEN 'a 0 to 10'

WHEN DxAge >= '11' AND DxAge <= '20' THEN 'b 11 to 20'

WHEN DxAge...

Did you look at the log file generated during the install process and stored in temp? You might be able to work up from there to figure out it's issue.

Do you attach by a specific name via QA

If so check in the client configuration tool and make sure the name you are using isn't defined pointing at the other...

Unless I missed something no if they need to connect to SQL Server only and you have a per processer license then you are fine. If however they need to...

No nothing really any slicker.

The reason you are getting this is that the user I assume existed on the production system and already was granted access to the database. When you restore to another...

Most commonly people don't realize they don't have enough hard drive space. I would start there however here are the system reqs for 2K5 Dev

http://www.microsoft.com/sql/editions/developer/sysreqs.mspx

To my knwoledge you can not do anything about this (at least not without a possible reg hack).

I think there is a misconception. Per BOL Simple Recovery Model

"After the log space is no longer needed for recovery from server failure, it is reused."

This doesn't mean the file...

I think there is a misconception. Per BOL Simple Recovery Model

"After the log space is no longer needed for recovery from server failure, it is reused."

This doesn't mean the file...

What OS are you running BTW? Windows XP will limit you to 4GB of which 2GB can be used by SQL Instances. So yes your OS can impact what you...

First off I have not done anything with GPS. Not knowing your goals and what you have access to I cannot tell you anything more....

Depends on the server they connect to and the licensing model you have setup. ODBC itself is not licensed perse.

Yesit can explain the slowdown. Consider tempDb to be a scratch pad. If the database can't expand then more work has to be done in memory. I am surpirsed you...

Trying using DTS with Active Scripting. Then you can have a command object but set via code effectively.