Hi all

 

Is there any way to view the records in the temp tables created by stored procs(SQL created this tables in tempdb)

 

Thanks

Dyanesh

it depends if their names begin with  "#"  or with "##". It's all in the documentation of sqlserver , under temp tables.

---

Hey , sysadm , leave the users alone
They are nothing more
than another brick in the firewall

It is possible to query temp tables.  You can create temp tables as simple as select * into #foo2 from foo where foobar = 'xxx'.  Now your temp table #foo2 contains only foobar's = 'xxx'.  ##Tablename are global.  I will leave it to you to figure out how long a temp table persists.

 

Jason

I give a little example here of how to do it.

http://www.simple-talk.com/community/blogs/philfactor/archive/2007/07/13/33494.aspx