Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
phrankbooth
Posting Yak Master
162 Posts |
 Posted - 2012-08-30 : 21:50:26
|
| Hi,I have a dynamic SQL SP, there is one big piece of dynamic sql code which I have assigned to a Varchar(max) variable. However, when I print this the code is incomplete, the code is truncated after a certain spot. And I'm just printing it. I have tried breaking it up into pieces, using varchar(max) for the smaller pieces, then concatenating the variables in the print statement but still it truncates.I read somewhere that varchar(max) is gigs worth of storage on sql2008 which I use. So then why would truncation be happening? If there's is an error in the code would Print be sensitive to that and fail?--PhB |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2012-08-30 : 21:59:52
|
It is the print. Check the Tools - Option - Query Result in SSMS
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
|
|
|
Dynamic sql being truncated with varchar(max)