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 |
|
IceDread
Yak Posting Veteran
66 Posts |
 Posted - 2008-02-07 : 08:30:58
|
| Greetigns!I've a simple question that I could not find an answere for.When I do a select in sql server 2000 and 2005 the result from the table I am interrested in get's cut off in lenght so I do not get it all. It also gets cut off when I select the result to a file. The lenght of a row is 8000 and it gets cut of after maybe 100 or so.. but I need the enitre row.Now I belive someone who is not here today made some configuration with exception on a few tables to speed things up.I wonder, where I I add a table to such an exception list? (I was not here when they did it and not even sure if that's how they did it)How do I make a configuration in my sql serve management studio 2005 to not have the result cut off?Thanks a lot for help! :-) |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-02-07 : 08:51:54
|
If you mean "I can't see entire column data" you can easily change the default option to only view the first 256 bytes in Tools -> Option.The data is still stored in the databas as 8000 characters.
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
IceDread
Yak Posting Veteran
66 Posts |
Posted - 2008-02-07 : 09:02:02
|
| I can't belive how I could miss that one, thanks!*I need some coffee* |
|
|
|
|
|
|
The lenght of the result get's cut off