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 ...
Any thoughts mch appreciated.
Greg.
Sybase tells me the table is owned by dbo, so I've tried all of the following ...
Code:
select * from tempdb.dbo.#usertable
select * from tempdb.guest.#usertable
select * from tempdb.<userid>.#usertable
Greg.