Sign up for the ITPro Today newsletter
Stay on top of the IT universe with commentary, news analysis, how-to's, and tips delivered to your inbox daily.
Why do I only get 255 characters back in a column in Query Analyzer?
Neil Pike
October 7, 1999
1 Min Read
A. The 255 limitation is a Query Analyzer option - you can change it - or use OSQL.EXE which won't show this limitation.
Go to Query/Current Connection Options/Advanced and change max chars per column to whatever maximum you desire.
About the Author(s)
You May Also Like
.jpg?width=700&auto=webp&quality=80&disable=upscale)
_(1).png?width=700&auto=webp&quality=80&disable=upscale)
.png?width=700&auto=webp&quality=80&disable=upscale)