February 3, 2008 at 4:27 am
I have a table which has a primary key, and three ntext field storing text data of lenght ranging from 1000 - 6000 characters. When i copy and paste text in two of the ntext fields, it works well, as soon as i enter or copy/paste text from notepad to the third field of type ntext, it display message like "can't edit this cell".
the text data contain simple a-z, 0-9, and some special characters like @, (, ), ., /, \, #, {, }.
Can someone guide me what i have to do to store a text of around 5000 characters or more in different fields.
Is there any limitation of using ntext or text fields in a table (1, 2, 3 or ?).
What special setting it need? can someone guide me?
best regards,
Rashid
February 3, 2008 at 6:22 am
What tool are you using to edit the contents of the table? SSMS? There shouldn't be any particular limit on the number of ntext columns in a table.
February 3, 2008 at 9:13 am
The problem isn't with the number of columns, but the size of the data you're trying to paste. I suspect you're running into a limitation on column editing in SSMS. You should find that it works fine through other methods. Can you confirm?
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
February 3, 2008 at 10:17 am
Can you test what happens if you alter the colums to nvarchar(max)?
This datatype is prefered in sql2005.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
February 4, 2008 at 9:33 pm
Thanks alot for your kind support. I changed it to nvarchar and it worked. I am using SQL Server 2000 Enterprise.
Once again thanks for your kind support
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply