To ensure that a temporary table name is unique for the current session, Adaptive Server:
Truncates the table name to 238 bytes, including the pound sign (#)—if necessary
Appends a 17-digit numeric suffix that is unique for an Adaptive Server session
The following example shows a table created as #temptable and stored as #temptable00000050010721973:
use pubs2 go create table #temptable (task char(30)) go use tempdb go select name from sysobjects where name like "#temptable%" go
name ------------------------------ #temptable00000050010721973 (1 row affected)
