The CASE expression doesn't want to return an integer in some rows and a varchar in other rows. 

So, what are you trying to accomplish by converting the locationCode to an Int? ...

The only packages that you can do that with as far as I know are maintenance plans and then you are limited to just a few tasks.

I forgot one thing since you will be using SQL Server 2005, look into Database Mirroring for DR.

I have tried to do the same and it has never worked for me. I even tried converting a multi-column Access report.  I saw another post at http://sandbox.manning.com/thread.jspa?threadID=16181&tstart=0 where the...

Clustering, as far as SQL Server is concerned, is hardware fail over only.  The data is not duplicated and it doesn't help with performance. It's not load balancing. Basically, two physical servers are...

Are the logs located on a clustered resource disk or on a local disk?

The graphic I posted is a portion of the error.

If I do that approach, which is probably one of the few choices I have, I think I'll look into...

SQL Server probably has to use tempdb to process your query. 

First, make sure that network connections are enabled for the named instance. 

Make sure that you can connect remotely to the default instance. Make sure the account you are using has...

Glad to hear that the article helped!

You'll have to set up a separate log backup that runs right after the full backup.  This log backup must have the "Overwrite Existing Media" property checked if you are...

I am really interested in becoming a trainer, so I check out the want ads from time to time.  I recently saw an ad titled "SQL Server Trainer" from one...

What is really bad is that you are advertising "LiteSpeed" in the same newsletter.  Coincidence?

Never mind, another ID10T error.

It worked.  Too bad I didn't realize this sooner.