So... Let me tell you a story...
My application is installed at about 100 sites. Places ranging from connecticut, to california (and lots of places in between).
When we installed in Canada, we ran in to a problem. First with the date format (had I known then what I know now). Then, later with temp tables. Let me explain.
Temp tables are actually stored in the TempDB. As such, the default collation for string columns is the same as the default collation for the database, which is the same as the default collation for the server. The problem was the the collation for the database I put on their server was not the same. Who cares, right? Well, for some queries, I was loading a temp table and then later using values from the temp table. I started running in to collation problems. Once I switched them over to table variables, the problem went away completely.
Now, don't mistake this story as reason to NOT use temp tables. With any luck, you'll never have the same problem I did. And if it ever happens to you, at least you'll be a little more prepared for it.
-George
Strong and bitter words indicate a weak cause. - Fortune cookie wisdom