>>>I assume the number sign (pound sign, etc "#") is NOT any kind of keyword?
>>
>>Well it is - it means that the table is temporary and to be dropped when you disconnect. Internally, these names translate into something 32 or 127 characters long, with some sort of connection ID appended and filled with underscores - you can see that if you look at the tmptables database (or something like that) with query analyzer or some other tool while you had these created in the first connection.
>
>The reason I asked the question was that I found precious little by way of explanation in the SQL BOL for SQL Server 2005. Using it's "search" function I found a measly 5 entries, none of which particularly informative as regards the implications of "#Temp".
>
>Anyway, I'm pleased to learn about this.

I don't remember how I found this - it was a few years ago - but I can say the BOL can be quite frustrating, just like any other M$'s help file. Accidentally, "bol" in Serbian means "pain", quite fitting.

The nice thing about SQL server is that it has a command window. It's called Query Analyzer, but hey - when was the last time M$ used a common name for anything?