debugging stored procedure temp table in Query Analyzer

Question

debugging stored procedure temp table in Query Analyzer

deb.k

Old Hand

Points: 354
More actions
December 11, 2008 at 9:40 am

#216398

I build a couple of temp tables in my stored procedure. When I am debuggin, I cannot figure out how to see the contents of the temp table. This is probably easy to do, it just escapes me how to do it...
Thank you for any help you can provide.

Viewing 7 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Greg Snidow SSCoach Points: 16108 More actions · Answer 1

Why can't you run the parts of the procedure up to the point the temp table is created and populated, then do a SELECT * from the temp table?

Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.

deb.k Old Hand Points: 354 More actions · Answer 2

I tried that but it throws a 'Invalid object name '#DistinctEmail'.' with #DistinctEmail being the temp table.

Mike_D Hall of Fame Points: 3295 More actions · Answer 3

Can't believe the rubbish I wrote first time. You need to put the SELECT inside the stored procedure. A temporary table is only visible to its creator and only exists for as long as the creator exists. So a temporary table created by a stored procedure will disappear when the stored procedure terminates.