To ensure that a temporary table name is unique for the current session, Adaptive Server:
Truncates the table name to 13 characters, including the pound sign (#)
Pads shorter names to 13 characters, using underscores (_)
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 #temptable___00000050010721973:
use pubs2
go
create table #temptable (task char(30))
go
use tempdb
go
select name from sysobjects where name like
"#temptable%"
go
name ------------------------------ #temptable___00000050010721973 (1 row affected)
