Hugo Kornelis (8/22/2014)

---

It won't be updated.

The reason for the shorter maximum length for temp table names is that SQL Server internally adds some characters to the name. That way, you can create a table #tmp1 and I can create a table #tmp1 on the same server, and we will not be in each other's way.

Can this be changed? Probably. But given how often I have sat behind my keyboard cursing the fact that I was unable to add a 117th character to the name (aka "never"), I have a very long list of things I much rather see the SQL Server development team work on!