Zitat von
MSSQL T-SQL Help System:
Global temporary tables are automatically dropped when the session that created the table ends and all other tasks have stopped referencing them. The association between a task and a table is maintained only for the life of a single Transact-
SQL statement. This means that a global temporary table is dropped at the completion of the last Transact-
SQL statement that was actively referencing the table when the creating session ended.
Die globalen Temptabellen können also unter gewissen Umständen verfallen.
Aber zur peristenten Speicherung sind die ja auch nicht gedacht.
