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 |
|
atomicbomb
Starting Member
1 Post |
 Posted - 2006-03-19 : 22:48:48
|
| Hi.I have a table which has an NText column.This column contains XML data.For some reason, some of the rows data does not appear when viewed in Enterprise Manager. If I run a select statement in query analyser the data appears (truncated), so it is there, but took me a while to realise this.Any idea why this is so?My guess is that there is something in some of the xml files that is causing the value to disappear. Could it possibly be that these xml files that don't show have the word "password" in them? When I did a trace to watch if the data was being inserted, the trace wouldn't show the contents of the SP call becuase the word "password" was found in the text. Could this be the same for viewing data???Any ideas would be appreciated.CheersChris Coppin |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2006-03-20 : 00:35:54
|
| Enterprise Manager isn't really designed for viewing lots of data so it will hide large text columns. You're best off building the viewing of data into your application if you need it.Damian"A foolish consistency is the hobgoblin of little minds." - Emerson |
 |
|
|
|
|
|
NText data not showing in Enterprise manager