temp tables, global and local

[Billy Cormic]

Can anyone tell me or post a link that says how many global temp
tables can exist SQL Server 2000? Also, is there a limit to the
number of local temp tables that can exist?

Thanks,
Billy

[John Bell]

Hi

I don't know of any specific limit for this, although tempdb will have the
maximum number of possible objects limit of 2,147,483,647.

Excessive use of temporary tables may result in contention issues, such as
on the system tables in tempdb, you may also want to consider the structure
and location of tempdb which could be the cause of some performance issues.

John

"Billy Cormic" <bi**********@hotmail.com> wrote in message
news:dd**************************@posting.google.c om...

Can anyone tell me or post a link that says how many global temp
tables can exist SQL Server 2000? Also, is there a limit to the
number of local temp tables that can exist?

Thanks,
Bill