The other element that you must check is the client application. Make sure the client application has not limited the text input length to 100 characters and that it can take all 255 characters. Once you've confirmed that, you're good to go for future data entry.
Dig Deeper on Microsoft SQL Server Performance Monitoring and Tuning
Related Q&A from Kevin Kline, Director of SQL Server Solutions, Quest Software
Monitoring and Administration expert Kevin Kline discusses the obstacles of database administration when a publisher resides on a different domain.continue reading
A common SQL Mail error is addressed by monitoring and administration expert Kevin Kline.continue reading
Monitoring and Administration expert Kevin Kline discusses the installation of SQL Server client tools on Windows XP Pro.continue reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.