Please suggest me a query to find temp database tables.
It works thanks a lot.
Simhadri
2010-09-15 14:58:30
+1
A:
All temp tables created are stored in the tempdb available on sql server. So run this query in tempdb, you will find available temp tables on the server -
select * from sysobjects where "xtype" = 'u'
Hope this will help you
Sachin Shanbhag
2010-09-15 14:16:03
It also works good but Martin's solution is better I feel.Thanks for your time.
Simhadri
2010-09-15 14:59:17