Link to home
Avatar of mgbecker
mgbeckerFlag for United States of America

asked on

Max number of global temp tables in MS SQL Server 2005

How many temp tables are allowed in MS SQL Server 2005?
ASKER CERTIFIED SOLUTION
Avatar of BrandonGalderisi
BrandonGalderisi
Flag of United States of America image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
"As many as will fit in tempdb"

Meaning you can't add any more if your tempdb database is full.