Options
Unable to update data.
Adrian Eaton
Posts: 2
I am getting this error message when trying to update the data from one table between two servers.
There are no updateable columns in the table [dbo].[xSecurityFunctions] even though differences exist these cannot be sychronised.
What does this mean and is there a way to get around the problem.
I am using SQL Packager version 5.2.5.0
This is the Schema of the table.
CREATE TABLE [xSecurityFunctions] (
[FunctionId] [int] NOT NULL ,
[Name] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[Description] [varchar] (1000) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[Hide] [bit] NOT NULL CONSTRAINT [DF_xSecurityFunctions_Hide] DEFAULT (0),
[TimeStamp] [timestamp] NOT NULL ,
[CreatedDate] [datetime] NOT NULL CONSTRAINT [DF_xSecurityFunctions_CreatedDate] DEFAULT (getdate()),
[Createdby] [int] NOT NULL CONSTRAINT [DF_xSecurityFunctions_Createdby] DEFAULT (0),
[UpdatedDate] [datetime] NOT NULL CONSTRAINT [DF_xSecurityFunctions_UpdatedDate] DEFAULT (getdate()),
[UpdatedBy] [int] NOT NULL CONSTRAINT [DF_xSecurityFunctions_UpdatedBy] DEFAULT (0),
CONSTRAINT [PK_xSecurityFunctions] PRIMARY KEY CLUSTERED
(
[FunctionId]
) WITH FILLFACTOR = 90 ON [PRIMARY]
) ON [PRIMARY]
GO
There are no updateable columns in the table [dbo].[xSecurityFunctions] even though differences exist these cannot be sychronised.
What does this mean and is there a way to get around the problem.
I am using SQL Packager version 5.2.5.0
This is the Schema of the table.
CREATE TABLE [xSecurityFunctions] (
[FunctionId] [int] NOT NULL ,
[Name] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[Description] [varchar] (1000) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[Hide] [bit] NOT NULL CONSTRAINT [DF_xSecurityFunctions_Hide] DEFAULT (0),
[TimeStamp] [timestamp] NOT NULL ,
[CreatedDate] [datetime] NOT NULL CONSTRAINT [DF_xSecurityFunctions_CreatedDate] DEFAULT (getdate()),
[Createdby] [int] NOT NULL CONSTRAINT [DF_xSecurityFunctions_Createdby] DEFAULT (0),
[UpdatedDate] [datetime] NOT NULL CONSTRAINT [DF_xSecurityFunctions_UpdatedDate] DEFAULT (getdate()),
[UpdatedBy] [int] NOT NULL CONSTRAINT [DF_xSecurityFunctions_UpdatedBy] DEFAULT (0),
CONSTRAINT [PK_xSecurityFunctions] PRIMARY KEY CLUSTERED
(
[FunctionId]
) WITH FILLFACTOR = 90 ON [PRIMARY]
) ON [PRIMARY]
GO
Comments