Viewing #temp tables in tempdb

[grega]

Is there any way that I, as user sa, can view a temp table in tempdb created by another user. The tablename is preceded by a # (persists for session only) and the users session is still open.

Sybase tells me the table is owned by dbo, so I've tried all of the following ...

select * from tempdb.dbo.#usertable
select * from tempdb.guest.#usertable
select * from tempdb.<userid>.#usertable

Any thoughts mch appreciated.

Greg.

 

[shailfx9]

to grega
from shailendra gangan

1) login in as sa
2) use tempdb
3) sp_tables
u will be able to view the table
requesting u to pls notify me whether it has helped you or not on shailfx69@netscape.net

thanks

 

[grega]

Thanks shailfx9 .. that shows mw what tables are in tempdb, but I want see the contents of the tables! which I gather cannot be done :-(

Greg.