SQL variable longer than 256 characters in VS.NET Debugger.

I

IC

Hello,

When debugging a SQL sproc in VS.NET, is there a way to get the debugger to
retrieve the full value of a SQL variable if its content is longer than 256
characters?

I currently have a SQL variable of type TEXT, its content is roughly 1000
characters. When stepping through the sproc in the debugger only 256
character are displayed in the watch windows and same thing with the
Immediate Command Window.

--IC
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

String variable is limited to 256 characters 5
EXCEL validation drop down boxes. 256 limit 1
Look at value of global variabls in debugger? 1
Non-ascii characters in VS.NET service 10
SQL string longer than 255 characters 4
256 character limitation 1
Trimming a cell down to 256 Characters 2
Sql Server / VS.net 2005 debugger transaction lock problem 2

Top