Tempdb Demo

Tempdb Demo

step1: To check tempdb startup
sp_readerrorlog 0,1,'tempdb'

step2: Creating one table in MSDB
use msdb
go
create table emps1(empid int,ename varchar(40))

step3:
select * into #emps1_temp from emps1

step4: sp_help #emps1_temp --Error

step5: Checking in tempdb

use tempdb
go
sp_help #emps1_temp

step6: Take new query

step7: kill 58

step8: Check the same table
use tempdb
go
sp_help #emps1_temp --Error