471,075 Members | 1,276 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,075 software developers and data experts.

Store procedure's debug

While I debugging a SP, I try to catch the value of local variable ( DECLARE
@ls_where VARIANT(8000) ) but I see that is not completely, but truncate.

The SP works correctly ... how can I catch the completely value of the local
variable ?

I have The same result if I Print the variable.
Thx
Jul 20 '05 #1
1 1407
saimon (sa**********@supereva.it) writes:
While I debugging a SP, I try to catch the value of local variable (
DECLARE @ls_where VARIANT(8000) ) but I see that is not completely, but
truncate.

The SP works correctly ... how can I catch the completely value of the
local variable ?


It seems that in the SQL debugger, you only get 255 chars.

But for result sets you can change the max width in Query Analyzer under
Tools->Options->Results.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
Jul 20 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

10 posts views Thread by Scott Brady Drummonds | last post: by
reply views Thread by serge calderara | last post: by
1 post views Thread by esmith2112 | last post: by
5 posts views Thread by jiangyh | last post: by
3 posts views Thread by kd | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.