Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Temp Tables

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-01-14 : 22:48:15
Akhilesh writes "How much of a resource crunch do you think it is to use temporary tables in MS SQL. I really do not consider them to slow a SP to an extent that i would worry about

also when i create temp tables does the sysobjects get locked..i think it is like a transaction and the sysobjects do get locked when you do a create ...anything..

Could someone clarify this for me"
   

- Advertisement -