Why do I only get 255 characters back in a column in Query Analyzer?

Neil Pike

October 7, 1999

1 Min Read
ITPro Today logo in a gray background | ITPro Today

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.

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.

You May Also Like