How to view #temp tables in vs.net (stored procedures)

  • Thread starter Thread starter msnews.microsoft.com
  • Start date Start date
M

msnews.microsoft.com

When you step into a stored procedure using vs.net, you get all the debug
variables, except temp tables (like INSERT INTO #list (id) SELECT id FROM
members WHERE...).

Is it possible to view the temp tables?

-Max
 
I am not sure but why dont you try making that #list to be ##list and do a
select * from ##list from isqlw?
 
Back
Top