The whole content of the table is more or less controlled by the merge function but some updates do occur by a program (Linq 2 SQL DataContext )
the layout of on of the tables look like this:
SET ansi_nulls ON
SET quoted_identifier ON
SET ansi_padding ON
CREATE TABLE [dbo].[resources]
(
[dataset] [NVARCHAR](3) NOT NULL,
[lxbenummer] [BIGINT] NOT NULL,
[medarbejder] [VARCHAR](20) NOT NULL,
[navn] [VARCHAR](50) NOT NULL,
[birth date] [DATETIME] NOT NULL,
CONSTRAINT [PK__Resource__EFB4713E4A03EDD9] PRIMARY KEY CLUSTERED (
[dataset] ASC, [medarbejder] ASC )WITH (pad_index = OFF,
statistics_norecompute = OFF, ignore_dup_key = OFF, allow_row_locks = on,
allow_page_locks = on) ON [PRIMARY]
)
ON [PRIMARY]
and the Merge function:
MERGE [resources] TARG
using navi2009views.dbo.resources SRC
ON ( TARG.lxbenummer = src.lxbenummer )
AND TARG.medarbejder = src.medarbejder
AND TARG.navn = src.navn
AND TARG.[birth date] = src.[Birth Date]
WHEN NOT matched BY target THEN
INSERT
VALUES (dataset,
lxbenummer,
medarbejder,
navn,
[birth date])
WHEN NOT matched BY source THEN
DELETE;
We did a couple of tests with the Merge function before we used it in production and we found that the metadata would update just as expected...
We've been using LINQ2SQL for years now and lately for about 2 years with the sync framework, without a problem like the one we have now.
It's a real mystery why the metadata suddently thinks that data has been deleted, without that being the case :-/
edit
would / could it be possible that a DELETE is fired and the DELETE_TRIGGER will only fire partially ?... that it succeed in updating the metadata, but fail to actually delete the data ? thereby invalidating the metadata ?
