Unable to update data.

Adrian Eaton

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

Brian Donahue

I'd assume it means that the only difference that Packager found in the table was in the timestamp column, and timestamp columns, by their nature, can't be synchronized. There should be an option in the 'data options' tab of the SQL Packager options to include timestamp columns, so you should turn that off and it should prevent the error message.