VERY STRONG SUGGESTION!

Set compatibility mode to 80 in 2005 and find a way to make it work.  Your options for going back are few and all are painful. 

Same concept, but after reading again, this is closer to what I think you want.

USE

[master]

GO

SET

ANSI_NULLS ON

GO

I am going to assume that you are passing the DB name or are changing it.  Because of many issues and usually the need for dynamic sql.  This is the...

If you do the updates, I would have to assume that there would NOT be any reorganizing of the indexes except for new locations.  Which is why I think that...

FYI, pivot (not near SQL Server, to can't test syntax)

However because you are grouping some together as 1 like 705 north and south it won't work as you did it,

but...

Whats wrong with you that you didn't understand what I was thinking  

Create a new user.  Grant the appropriate privs to that user...

All the good points have been made, so simply "Ditto".

And if all else fails, we have "CLR" BUT ONLY AS A LAST RESORT!

So... Not Old Fashioned, Right!

Your not backing up transaction logs.  Not sure why, but you apparently don't need them. Just change the DB to "Simple" recovery.  As for the error, you are...

Actually the number I use is 1 file per CPU, all the same size (fixed) and there is also a trace value that is supposed to be set (if you...

Talk about being between a rock and a hard place.   I would love to say.  If you want us to buy, fix this. ...

Another option is to create a procedure that returns the data you need.  Set the procedure to run as whatever rights it needs (such as server state) then grant execute...

Quick and easy.  Visio does a pretty good job.  All of the Designer tools Erwin etc do it.

You have no field in between the WHERE and the IN. 

where in (

There is also a problem with your subselect you an only...

Perhaps that explains the loan crisis

I had one of those too   Although it was a psych test.  Thinks like.  "If you had to kill one, but only one,...