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 |
|
spinoza
Starting Member
49 Posts |
 Posted - 2006-01-05 : 15:59:46
|
| Hi everyone,I have tranferred my database from Access to SQL. In some cases where there is a very long text in the field of "content" (thats the name of the field) appears the sign <Long Text> while in some other fieldsof the "content" the text appears normally...I have used ntext 16 as a datatype... How can i dissapear this sign from the field...is there any way?? Thank you |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-01-05 : 16:16:12
|
| You are using Enterprise Manager to view this data. That'll happen. Use Query Analyzer instead.Tara Kizeraka tduggan |
 |
|
|
spinoza
Starting Member
49 Posts |
Posted - 2006-01-05 : 16:26:11
|
| Thanks tkizer...Can i use query analyser to see the data from my hosting provider? With EM i registered the database...with query analyser should i do a similar process?? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-01-05 : 16:36:32
|
| You can use Enterprise Manager for all other viewing of data except text. You will need to type in the database server when you open Query Analyzer and prompts for that information.Tara Kizeraka tduggan |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-01-06 : 00:16:59
|
| >>with query analyser should i do a similar process??Select columns from DBName..tableNameMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
<Long Text>