quote:

---

Originally posted by gbritton

Operations on ... table variables ... are logged

---

CREATE TABLE #TempTable
(
   Foo varchar(10)
)

DECLARE @TableVar TABLE
(
   Bar varchar(10)
)

BEGIN TRANSACTION

    INSERT INTO #TempTable
    SELECT 'aaa'
    UNION ALL SELECT 'bbb'

    INSERT INTO @TableVar
    SELECT *
    FROM #TempTable

ROLLBACK

PRINT '#TempTable:'
SELECT *
FROM	#TempTable

PRINT '@TableVar:'
SELECT *
FROM	@TableVar

DROP TABLE #TempTable

#TempTable:
Foo        
---------- 

(0 row(s) affected)

@TableVar:
Bar        
---------- 
aaa
bbb

(2 row(s) affected)

quote:

---

Originally posted by gbrittonTemporary tables and stored procedures are dropped automatically on disconnect

---

quote:

---

Operations on ... [and] table-valued functions are logged.

---

quote:

---

Since log contention can become a contention point in a heavily loaded system with a small log file, make the tempdb log file large enough to avoid truncating logs frequently. For example, if 50 MB of the log file can be generated per second in the system, the log size should be at least 500 MB so that a log truncation is performed about every 10 seconds.

---