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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 modification to varchar field length in systypes system table...

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-10-28 : 16:40:29
sreekanth s r writes "for a perticulear database i need one field of a table to hold 20,000 characters ( but on an average holdss 6000 characters...). the varchar supports 8000 only.
I am told that text and ntext put a lot of overhead on the sqlserver. Can I modifi the varchar field length is systpes table to get mare space in varchar datatype. Will this affect the server in any way?"
   

- Advertisement -