How can I change a field in a SQL server database that's set to "Read Only Cell"?

Question

I have a SQL database that has a table with a field set to "Read Only" when I look at it through Microsoft SQL Server Management Studio Express.

I need to change some data within that field manually but I can't see any properties that I can change that will let me override this.

Will I need to write a sql script on the table to do this or is there something that I am missing ?

Answer 1

What is the datatype of the field? You may not be able to "type" into it if its of an ntext or image datatype and management studio can't handle the size of it.

In that case you might have no option but to perform an update as follows.

UPDATE TableName SET ColumnName = 'NewValue' WHERE PrimaryKeyId = PrimaryKeyValue

Answer 2

The field is most likely "read-only" because it contains a calculated value.

If that's the case, you would have to change calculation in the table definition to change it's value.