Read-Only Cell

Read-Only Cell

• Bosko

  test, plz ignore wrote in message news:d2f7089a-0e12-4dfe-ad40-5bc5e6ca4cf4@discussions.microsoft.com... > Hi, > > When I create a new xml column using SQL server 2005 the column by > default is set to "read-only cell". I've looked around at the > properties and don't see anything to change this behavior. Anyone know > what I need to do so that I can write to this cell useing the SQL > browser. I'm able to update the cell programatically, BTW. Any help > greatly appriciated. > > - Pardner > >
  

• trun_gup

  You should be able to change this field as it is not a read-only field. SQL Server Management Studio should be able achieve this.

  
  
  

• Gerdsen

  Hmm,

  Maybe I need more information to get a response I went to the table from the SQL Server GUI and did a script table as to list the SQL for the table creation as listed below. As mentioned, if I look at the xml field (xmlPlanProvisions) in the SQL Server browser it lists the field as "read-only". This is a problem, I need to be able to edit the field without using code to update it. Am I out of luck ... any feedback appriciated.

  USE [PlanProvisions]

  GO

  /****** Object: Table [dbo].[PlanProvs] Script Date: 05/30/2006 10:52:11 ******/

  SET ANSI_NULLS ON

  GO

  SET QUOTED_IDENTIFIER ON

  GO

  CREATE TABLE [dbo].[PlanProvs](

  [PlanID] [int] NOT NULL,

  [EnrollID] [int] NOT NULL,

  [WorkingVersion] [bit] NULL,

  [WebVersion] [bit] NULL,

  [Version] [float] NOT NULL,

  [XmlPlanProvisions] [xml] NOT NULL

  ) ON [PRIMARY]

  
  
• Read-Only Cell