optimistic concurrency error with datetimeoffset fields upon update

optimistic concurrency error with datetimeoffset fields upon update by d4e666

Closed

Type:	Bug
ID:	766419
Opened:	10/6/2012 6:23:28 AM
Access Restriction:	Public

Workaround(s)

view

User(s) can reproduce this bug

in my database I have added 3 datetimeoffset(7) fields to record when a record is inserted, updated or deleted. All fields are nullable but date inserted and date updated are set to thefaultvalue getutcdate(). Every time I want to save a record in SSMS I get the notification that data has changed. This seems unlikly since

1. I am the only user on the database
2. The database is local to my system
3. I get this on overy record which seems rather unlikly that someone else is changing my data

Details (expand)

English

SQL Server 2008 R2 SP1

Tools (SSMS, Agent, Profiler, Migration, etc.)

Windows 7 Ultimate (SP1)

Dutch

create the table using the following script

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ApplicationInvariant]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[ApplicationInvariant](
    [ApplicationID] [uniqueidentifier] ROWGUIDCOL NOT NULL,
    [Code] [varchar](255) NOT NULL,
    [Tag] [varchar](255) NOT NULL,
    [SortOrder] [int] NULL,
    [DateCreated] [datetimeoffset](0) NULL,
    [CreatedBy] [uniqueidentifier] NULL,
    [DateLastModified] [datetime2](7) NULL,
    [LastModifiedBy] [uniqueidentifier] NULL,
    [DateDeleted] [datetime2](7) NULL,
    [DeletedBy] [uniqueidentifier] NULL,
    [IsVisible] [bit] NOT NULL,
    [ParentApplicationID] [uniqueidentifier] NULL,
CONSTRAINT [PK_ApplicationInvariant] PRIMARY KEY CLUSTERED
(
    [ApplicationID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
END
GO

SET ANSI_PADDING OFF
GO

IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_ApplicationInvariant_ApplicationID]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[ApplicationInvariant] ADD CONSTRAINT [DF_ApplicationInvariant_ApplicationID] DEFAULT (newid()) FOR [ApplicationID]
END

GO

IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_ApplicationInvariant_IsVisible]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[ApplicationInvariant] ADD CONSTRAINT [DF_ApplicationInvariant_IsVisible] DEFAULT ((1)) FOR [IsVisible]
END

everytime a record is edited the message telling that the data has changed appears.

that this messageonly shows when the data has acutally been changed by another user

X64

0 attachments

Hi!, thanks for writing in to Microsoft and reporting this bug.

We took a look at this bug and triaged it against several others and unfortunately, it did not meet the bar to be fixed. While we are closing this bug as 'won't fix', we have taken note of this internally and we will try & incorporate this request when we revisit this functionality in a future release of SSMS.

Regards,
Sanjay Nagamangalam, SQL Server Manageability