April 18, 2008 at 7:57 am
Hello,
I have a column defined as a Varchar(5000) containing rows with 1354 characters.
When my collegue selects from the table he gets the entire output.
When I run the same select all of my outputs are limited to 1000 characters.
I've also experimented with creating other >1000 character outputs and they are also limited to 1000.
I've searched Help and Googled but can't work out what is limiting my outputs.
Any suggestions?
.....please???
April 18, 2008 at 8:07 am
Is this only in Management Studio or in your application? I thought there was a max char returned setting in SSMS.
April 18, 2008 at 8:17 am
Hello!
Both queries are in the Management Studio
April 18, 2008 at 8:29 am
Look in Tools -> Options
You can configure a limit to the number of characters returned in Management Studio.
April 18, 2008 at 8:31 am
Check your settings in
Tools/Options->Query Results/Sql Server
Maybe you have 1000 set there?
HTH
Piotr
...and your only reply is slàinte mhath
April 18, 2008 at 8:34 am
Tools->Options->Query Results->SQL Server->Results To Grid
Look for Maximum Characters Retrieved -> Non XML data
Change the value as you see fit.
Or if you're spitting the results to Text
Tools->Options->Query Results->SQL Server->Results To Text
Look for Maximum Number of characters displayed in each column
Thanks,
jim
April 18, 2008 at 8:36 am
Hello again,
Your response inspired me with some new search strings to try in Google.
It is because I was sending my results to Text - so they got chopped at 1000 characters.
My collegue was outputting results to Grid - and gets all 1354!!
Mystery solved!
I shall stop obscessing and move on with my life now!
Thank you,
Helen
😀
April 18, 2008 at 8:41 am
Sorry Guys,
I didn't spot your replies before I responded!
I've checked and changed my Query Output Options and all is right with the world again.
Thank you all VERY much,
Helen
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply