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 |
|
thakur_amit
Starting Member
6 Posts |
 Posted - 2006-04-25 : 15:03:31
|
| Hi ,I am facing problem related to ntext or text .(Using SQL 2000)Actually I have sequence_master , I have few columns which have datatype NTEXT.For these columns I want to insert string of different length.For this I have first run this exec sp_tableoption 'sequence_master','text in row','7000'After this when I execute insert query and one column have 10000 characters (which have data type ntext)It gives me message ---(1 row(s) affected)But when I fire select query It only have around 264 characters.so please help me, how solve above.Waiting for your answersAmit |
|
|
rfrancisco
Yak Posting Veteran
95 Posts |
Posted - 2006-04-25 : 15:25:01
|
| If you are referring to the result in Query Analyzer, make sure that under the Results tab in the Options menu (under Tools), the Maximum characters per columns is set to 8192 (the maximum it can display). It looks like that it is set to the default value of 256.Hope this helps.Ronald Franciscohttp://www.sql-server-helper.com |
 |
|
|
thakur_amit
Starting Member
6 Posts |
Posted - 2006-04-26 : 17:35:56
|
Thanks That exactly the case,Amitquote:
Originally posted by rfrancisco
If you are referring to the result in Query Analyzer, make sure that under the Results tab in the Options menu (under Tools), the Maximum characters per columns is set to 8192 (the maximum it can display). It looks like that it is set to the default value of 256.Hope this helps.Ronald Franciscohttp://www.sql-server-helper.com
|
|
|
|
|
|
|
problem with ntext/text