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 |
|
pelegk2
Aged Yak Warrior
723 Posts |
 Posted - 2006-10-31 : 05:50:18
|
| when i create a temp table in a Stored Procedure like #table1as i understand this table is created in the tempdb(or am i wrong)?if so say my Stored Procedure runs for 30 seconds, and i have 3 users aat the same time access the same Stored Procedure - will each table will over run other tables?or is maybe a table with a unique i is created?2)does this temp tables are being created virtually on the disk - or i can actually at run time see the table created in the tempDB DB?thjnaks in advancepelegIsrael -the best place to live in aftr heaven 9but no one wan't to go there so fast -:) |
|
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
Posted - 2006-10-31 : 06:07:15
|
| Well, yeah they are created in the Tempdb. which temp table you are using local temp table or global temp table. if you are using the local temp table then it wont have any affect on the normal users accessing that procedure. But if you are using the global temp table then and if the user's are accessing the procedure with the same connection then it will give you error. about the viewing of temp table, its depends on the scope of our connection.Chiraghttp://chirikworld.blogspot.com/ |
 |
|
|
|
|
|
temp tables on tempdb