Post reply

See Contents of Temp Table in SSMS 2008 Debug Mode

  • June 28, 2010 at 2:04 pm

    #226260

    Is there a way to see the contents of a temp table while in the middle of SSMS debugging mode?

  • June 29, 2010 at 11:58 am

    #1186580

    Just change the temptable from "local" # to global ##

    then from a different connection read it without nay locking like: "select * from ##debugtable with (nolock)"


    * Noel

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

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