Brian's Blog

items I see across my tribes

Refresher: SQL Server 2000 Limitations

January 20
by briancarter 20. January 2010 17:30

Limitations of SQL Server 2000

·         Varchar 8,000 characters

·         NVarchar 4,000 characters

·         Row max characters = 8,000 for all columns, NVarchar count for 2 each char

 

(This is not an issue with SQL 2005 & 2008 - limit is 2GB.)

 

Categories: Development

Comments

Add comment




  Country flag

biuquote
  • Comment
  • Preview
Loading




 Questions or Feedback, my contact information is located on my About page.


The opinions, thoughts, and comments made in these blog posts are solely my own (unless otherwise stated). They do not reflect the opinions, thoughts or practices of my employer, my universities, my family, or anyone else. Also, I retain the right to change my mind about anything I publish here without having to go back and edit posts that occurred in the past. 

These are my opinions, or just as likely, someone else's opinions that I leveraged for my own.