Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 266
  • Last Modified:

Data results being truncated in query analyzer using SQL server 2000

Hi,

I am using SQL Server 2000. I'm running a query in query analyzer, but it's truncating one of my comment fields in the results. Is there anything I can do to see the full length of the field? Any help would be appreciated.
0
savache27
Asked:
savache27
1 Solution
 
Aneesh RetnakaranDatabase AdministratorCommented:
Go under Tools -options-> results -> you have to change the size of result column from 255 to say 8091
0
 
savache27Author Commented:
That is AWESOME! Thank you SO much!!!
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now