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 |
|
RichardSteele
Posting Yak Master
160 Posts |
 Posted - 2003-12-20 : 16:44:39
|
| When I look at data brought up by a select statement in enterprise manager, some, but not all of the rows in a text datatype column appear with the "Long Text" descriptor instead of the actual text. If I then update the record with some simple character data, it shows the characters, instead of the "Long Text" descriptor. What causes this? |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2003-12-21 : 08:47:34
|
Simple.Enterprise Manager isn't designed as a data viewing and data entry tool. It doesn't evaluate Text fields when you open a table.If you open up Internet Services Manager, you don't expect it to browse webpages for you  Damian |
 |
|
|
|
|
|
Text datatypes