Have you checked that you can connect to the sql instance over the network. Can you ping the name or IP that you are using in your connection string...

I do not see anything under properties on 2000 and that key does not exist on our 2005/2008 servers.

I cannot even find the utility on 2005/2008 to find out what...

This solution worked great. With one exception. The Total columns it is concatenating the three fields instead of adding them together. I tried to fix, but it...

I do not see where I said SQL is not on the machine.

I have 1000+ pc's with SQL Express 2005. It does not function correctly and the SP2 update...

That is not really an option.

I have 1000+ pc's deployed that are asking for this silly update and they are not on a domain and they are not running WSUS.

This...

Thanks all for the responses. I have decided since it is the end of the year that I will just truncate all data from the three tables and start...

That worked great, thanks.

Hello and thanks for the response.

This database will be based on your explanation an OLTP database. There will be hundreds of thousands of records created each day.

I had originally...