tempdbdemo

--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