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.
| Author |
Topic |
|
vedjha
Posting Yak Master
228 Posts |
 Posted - 2009-08-04 : 06:08:28
|
| Hello Sir, I have created a procedure using a temporary table ie, #Tempi seem that data is full. please tell me where #temp table stores.it is not showing me on in Database->table-> #temp (not avilable)where #temp table creates .please help meVed Prakash Jha |
|
|
rajdaksha
Aged Yak Warrior
595 Posts |
Posted - 2009-08-04 : 07:23:31
|
| HiCheck with tempdb..............-------------------------R..http://code.msdn.microsoft.com/SQLExamples/http://msdn.microsoft.com/hi-in/library/bb500155(en-us).aspx |
 |
|
|
rajdaksha
Aged Yak Warrior
595 Posts |
Posted - 2009-08-04 : 07:25:17
|
| Temporary tables are created in tempdb.Refer:-http://www.sqlteam.com/article/temporary-tables-------------------------R..http://code.msdn.microsoft.com/SQLExamples/http://msdn.microsoft.com/hi-in/library/bb500155(en-us).aspx |
|
|
|
|
|
|
Processing Slow