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 Administration (2000)
 temp files

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2006-12-01 : 08:37:21
Raj writes "should temp files be deleted from the sql server manually or they are automatically deleted."

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2006-12-01 : 08:39:59
You mean temp tables?

There are two types of temp tables - local and global. Both temp tables are automatically deleted by SQL Server, only the duration for which they exist is different. But it's good practice to delete them when done with them. Read more about temp tables in BOL.

Harsh Athalye
India.
"Nothing is Impossible"
Go to Top of Page
   

- Advertisement -