tags:

views:

56

answers:

1
Q: 

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 couldn't find how to open it.

Any ideas? Thanks!

+1  A: 
anishmarokey  2009-10-07 16:30:25
Sorry didn't realise it was register required, I have a cookie on that site. Thanks for the info, but you didn't answer the specific question: how do I get the value of a table variable when debugging a stored procedure. I can do all the bit that you've said so far (albeit in SSMS 2008, your article relates to SQL Server 2005, which is quite different).
Simon D  2009-10-07 18:06:56
what you mean by value of table variable ? all the values in a particular column of a table ?
anishmarokey  2009-10-07 18:33:03
I want to see what I would see if I type "select * from @tablevariable"
Simon D  2009-10-07 19:49:14

related questions

How can I set breakpoints in an external JS script in Firebug
How to remove debug statements from production code in Java
How to make the process of debugging ASP.NET Sharepoint applications less time consuming?
Visual Studio 2008 debugging issue...
Attaching to a foreign executable in Visual C++ 2003
Remote debugging accross domains
.NET Compiler -- DEBUG vs. RELEASE
How do I change the locations of source files in a symbols file (pdb)
Remote Debugging PHP Command Line Scripts with Zend?
Debugging asp.net with firefox and visual studio.net - very slow compared to IE
TCL development: debug environment
Standalone tools for debugging stored procedures
How do you configure VS2008 to only open one webserver in a solution with multiple projects?
Getting the subversion repository number into code...
In Visual Studio you must be a member of Debug Users or Administrators to start debugging. What if you are but it doesn't work?
IL level code debugger
MSVC6: Breakpoint stops program - WTF?
How do I debug Javascript in Visual Studio 2005?
Firebug for IE
I can't get my debugger to stop breaking on first-chance exceptions
Debugging: IE6 + SSL + AJAX + post form = 404 error
Best Debugging Tools for JavaScript/xulrunner Development
Visual Studio 2008 debugger already attached work-around
Heap corruption under Win32; how to locate?
How do you debug PHP scripts?