Here's a rewrite of your query.  You should be able to see how to easily extend it to include the other values.

SELECT DISTINCT
     caseid

It could be the Greek character thing.  Try this:

EXEC master.sys.xp_dirtree N'\\MNG01\Scans\05083-???????S?\ALL\',1,1; 

John

Yes.  Usually applying a CU or service pack causes at least one restart of the SQL Server services.

John

This should work, provided you make the new int columns not nullable.  I recommend you do this at a time when there's no activity on the tables in question.

Sounds like your backup file isn't a valid backup file.  Are there any backups you can restore from?  Do you verify your backups when you make them, or use the CHECKSUM...

Cat

What statement are you using to attempt your restore?  What do you get if you run this:

RESTORE HEADERONLY FROM DISK = 'Z:\Backups\VSSQL2\Backupfile.bak'

John

Presumably Name1 and Name2 aren't unique in their respective tables?  What happens if you pass in a value of Name1 or Name2 that returns more than one value of ID? ...

What do you get if you run this?

SELECT
    entity_name
,   subentity_name
,   permission_name
FROM fn_my_permissions ( TableName , 'OBJECT' )

John

You only need one CASE expression:
CASE
    WHEN FEB_CREDITS <> 0 THEN FEB_CREDITS
    WHEN JAN_CREDITS <> 0 THEN JAN_CREDITS
    WHEN DEC_CREDITS <> 0 THEN DEC_CREDITS
    WHEN NOV_CREDITS <>...

We need the actual execution plan, please - you've posted the estimated plan.  How many rows are in your temp tables?

John

Ben

Are there any indexed views, indexes on computed columns , filtered indexes, query notifications, XML...

Nic

I don't think there's a setting whereby you can turn it on or off.  All members of the public role have access to the stored procedure, according to...