>Is the server running with a case-sensitive sort order?
>
>Also, becareful with this pattern. Referencing temp tables outside of the stored procedure that created them can cause performance issues due to recompilations:


The server is using a different collation, with a binary sort order but that is the only difference that I currently know of. Could that make a difference?

Morgan