SQL Server 2008 debugger

Using the SQL Server 2008 debugger, how can I see the contents of a local table-valued variable in a stored procedure? In the locals window its value is listed as "(table)", but I can't see the contents. I saw some references to an "Immediate" window at http://www.sqlservercentral.com/articles/SQL+Server+2008/64354/ (note registration required to see this article) but I c开发者_如何学Goouldn't find how to open it.

Any ideas? Thanks!

first you register in that site you can see the article . If you register only you can see :)

Hope below diagram will help you

alt text http://img25.imageshack.us/img25/8548/20928548.jpg

alt text http://img129.imageshack.us/img129/2998/57154571.jpg

alt text http://img129.imageshack.us/img129/935/74405379.jpg

alt text http://img17.imageshack.us/img17/4213/98916248.jpg

You can debug same as visual studio.

alt text http://img203.imageshack.us/img203/9083/48169595.jpg

Read this one too

https://web.archive.org/web/20210510024057/https://aspnet.4guysfromrolla.com/articles/051607-1.aspx