|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Read Only ColumnI found 1 column which is Read-Only and it is not identity field
How can I change it to not Read Only using the SQL Server 2005 Management application Thank you, Samuel There is no such thing as a "read-only" column attribute in SQL Server. Possible reasons why you
cannot modify a column value for a row includes: Permissions Computed column -- Show quoteTibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://www.solidqualitylearning.com/ "Samuel Shulman" <samuel.shul***@ntlworld.com> wrote in message news:u%23Bqv2p0GHA.1568@TK2MSFTNGP03.phx.gbl... > > I found 1 column which is Read-Only and it is not identity field > > How can I change it to not Read Only using the SQL Server 2005 Management application > Thank you, > Samuel > Thank you,
I still can't figure out what was the problem Show quote "Tibor Karaszi" <tibor_please.no.email_kara***@hotmail.nomail.com> wrote in message news:enQbuEy0GHA.1040@TK2MSFTNGP06.phx.gbl... > There is no such thing as a "read-only" column attribute in SQL Server. > Possible reasons why you cannot modify a column value for a row includes: > > Permissions > Computed column > > -- > Tibor Karaszi, SQL Server MVP > http://www.karaszi.com/sqlserver/default.asp > http://www.solidqualitylearning.com/ > > > "Samuel Shulman" <samuel.shul***@ntlworld.com> wrote in message > news:u%23Bqv2p0GHA.1568@TK2MSFTNGP03.phx.gbl... >> >> I found 1 column which is Read-Only and it is not identity field >> >> How can I change it to not Read Only using the SQL Server 2005 Management >> application >> Thank you, >> Samuel >> > If you provide us with the error message from SQL Server, we might be able to get closer to the
reason... -- Show quoteTibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://www.solidqualitylearning.com/ "Samuel Shulman" <samuel.shul***@ntlworld.com> wrote in message news:uUwxA3N1GHA.3464@TK2MSFTNGP03.phx.gbl... > Thank you, > > I still can't figure out what was the problem > > > "Tibor Karaszi" <tibor_please.no.email_kara***@hotmail.nomail.com> wrote in message > news:enQbuEy0GHA.1040@TK2MSFTNGP06.phx.gbl... >> There is no such thing as a "read-only" column attribute in SQL Server. Possible reasons why you >> cannot modify a column value for a row includes: >> >> Permissions >> Computed column >> >> -- >> Tibor Karaszi, SQL Server MVP >> http://www.karaszi.com/sqlserver/default.asp >> http://www.solidqualitylearning.com/ >> >> >> "Samuel Shulman" <samuel.shul***@ntlworld.com> wrote in message >> news:u%23Bqv2p0GHA.1568@TK2MSFTNGP03.phx.gbl... >>> >>> I found 1 column which is Read-Only and it is not identity field >>> >>> How can I change it to not Read Only using the SQL Server 2005 Management application >>> Thank you, >>> Samuel >>> >> > > >> I found 1 column which is Read-Only and it is not identity field << It is probably a computed column or you are using a VIEW. You need toget to the base table and have the proper permissions.  |
|||||||||||||||||||||||
Other interesting topics