Temporary tablename Lengths

SQL Server 6.0

You can code a maximum of 20 characters for a temporary #tablename; all 20 characters will be used. If you use more than 20 characters, you will receive an error message.

SQL Server 4.2x

You can code a temporary #tablename longer than 13 characters, but only the first 13 characters are used.