Changed value in this cell was not recognized as valid.

Asked By William D Hampton 0 points N/A Posted on - 03/08/2013

 

A few days ago I installed Microsoft SQL Server Management Studio. But from now I am not able to continue working on it due to this error which you can see at below attached image. Does anybody's idea what is this and how can I remove this? I need your assistance. Thanks in advance

Microsoft SQL Server Management Studio

Invalid value for cell (row1, column 3)

The changed value in this cell was not recognized as valid.

.Net framework Data Type: Int64

Error message: Input string was not in correct format.

Type a value appropriate for the data type or press ESC to cancel the change.

OK

• Status: Open
• Question Views: 4552
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Misc Databases

Answered By Drake Vivian 30 points N/A #173921

Changed value in this cell was not recognized as valid.

Hi there William D Hampton,



Unfortunately, you didn't give us enough information about your problem to give you the proper solution. However, I will give you a few hints what and where to look to troubleshoot the problem.



The error says that SQL Server cannot read the value in the table you've set. The problematic one is in the first row, third column. Since it's talking about the first row, it's most likely you've misconfigured the whole column data type. Open the table you were working on and check for the column properties. It should match the data type you're trying to store in that column. If that is correct, click on the mentioned field (first in the column) and edit it. Check for any spaces, strange characters, letters if this is a number field, and any inputs that shouldn't be there. Remove them and confirm the save of the changes in the field. That should fix the problem.



Best regards,

Drake Vivian

About Drake Vivian

Questions
0

Answers
820

Best Answers
186

• Vote Up 0 Vote Down

• Posted on - 04/02/2013
• Question Category: Misc Databases