Re: UPDATE Statements May be Replicated as DELETE/INSERT Pairs

Tech-Archive recommends: Fix windows errors by optimizing your registry

Sorry, the table data when the foriegn key was violated doesn't seem to be
formatted properly, please see it in the attachment.


"Asser Maany" <asser.maany@xxxxxxxxxxxxxxxx> wrote in message
news:O5UWueBMGHA.1676@xxxxxxxxxxxxxxxxxxxxxxx
I couldn't really tell what was the update statement that caused this
delete/insert , but what I can tell you is the data that existed in the
table when the foreign key constraint was violated

Table when the foreign key was violated


BranchID TrxNumber TrxDate DriverID Vehicle Trailer KilometerReading
GDNCount BoxCollected BoxTotal Confirmed EntryDate EntryUser BUID
NINDCDDC000 26 2/12/06 12:00 AM NULL NULL NULL 0 18 347 347 0
2/12/06 5:04 PM shuhaib


Statements that were running causing foreign key violation


{CALL sp_MSdel_IC_ShipGDN_Master ('NINDCDDC000 ', '000026 ')}
{CALL sp_MSins_IC_ShipGDN_Master ('NINDCDDC000 ', '000026 ',
2006-02-12 00:00:00.000, NULL, NULL, NULL, 0, 18, 347, 347, 0, 2006-02-12
17:04:32.297, 'shuhaib ', ' ')}
Schema

CREATE TABLE [dbo].[IC_ShipGDN_Master](

[BranchID] [char](15) NOT NULL,

[TrxNumber] [char](15) NOT NULL,

[TrxDate] [datetime] NOT NULL,

[DriverID] [char](15) NULL,

[Vehicle] [varchar](15) NULL,

[Trailer] [varchar](15) NULL,

[KilometerReading] [int] NOT NULL CONSTRAINT
[DF__IC_ShipGD__Kilom__4E22BDCE] DEFAULT (0),

[GDNCount] [int] NOT NULL CONSTRAINT [DF__IC_ShipGD__GDNCo__4F16E207]
DEFAULT (0),

[BoxCollected] [int] NOT NULL CONSTRAINT [DF__IC_ShipGD__BoxCo__500B0640]
DEFAULT (0),

[BoxTotal] [int] NOT NULL CONSTRAINT [DF__IC_ShipGD__BoxTo__50FF2A79]
DEFAULT (0),

[Confirmed] [tinyint] NOT NULL CONSTRAINT [DF__IC_ShipGD__Confi__51F34EB2]
DEFAULT (0),

[EntryDate] [datetime] NULL,

[EntryUser] [dbo].[BS_User] NULL,

[BUID] [varchar](15) NULL CONSTRAINT [DF__IC_ShipGDN__BUID__52E772EB]
DEFAULT ([dbo].[ST_FN_GETBU](1)),

CONSTRAINT [PK_IC_ShipGDN_Master] PRIMARY KEY CLUSTERED

(

[BranchID] ASC,

[TrxNumber] ASC

)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]

) ON [PRIMARY]

GO

SET ANSI_PADDING OFF

GO

EXEC sys.sp_bindefault @defname=N'[dbo].[DF_Now]',
@objname=N'[dbo].[IC_ShipGDN_Master].[EntryDate]' ,
@futureonly='futureonly'

GO

EXEC sys.sp_bindefault @defname=N'[dbo].[DF_System_User]',
@objname=N'[dbo].[IC_ShipGDN_Master].[EntryUser]' ,
@futureonly='futureonly'

go

ALTER TABLE [dbo].[IC_ShipGDN_Master] WITH CHECK ADD CONSTRAINT
[FK_IC_ShipGDN_Master__AR_SalesMan__DriverID] FOREIGN KEY([DriverID])

REFERENCES [dbo].[AR_Salesmen] ([SalesmanId])

GO

ALTER TABLE [dbo].[IC_ShipGDN_Master] WITH CHECK ADD CONSTRAINT
[FK_IC_ShipGDN_Master__ST_Branches__BranchID] FOREIGN KEY([BranchID])

REFERENCES [dbo].[ST_Branches] ([BranchID])








"Hilary Cotter" <hilary.cotter@xxxxxxxxx> wrote in message
news:OuytHTBMGHA.2012@xxxxxxxxxxxxxxxxxxxxxxx
Can you post the schema of the problem table(s) and also the problem
update delete statements?

--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

"Asser Maany" <asser.maany@xxxxxxxxxxxxxxxx> wrote in message
news:O0XjZJBMGHA.3408@xxxxxxxxxxxxxxxxxxxxxxx
Sorry, missed your last comments, there are no cascaded deletes or
updates, and I'm not updating the primary key, that is why I don't
really
understand why is it converted as a delete and update.



"Asser Maany" <asser.maany@xxxxxxxxxxxxxxxx> wrote in message
news:ea%23MjDBMGHA.536@xxxxxxxxxxxxxxxxxxxxxxx
Thanks for the fast reply, but my point now is how should I deal with
it
to enforce the referential integrity, as I said in my employee example,
the delete that SQL server sends will cause a foreign key violation?


Regards
Asser Maany


"Hilary Cotter" <hilary.cotter@xxxxxxxxx> wrote in message
news:OgTCD3AMGHA.3100@xxxxxxxxxxxxxxxxxxxxxxx
If a table is published for replication and updates occurring on it
are
logged in the tlog as an delete insert pair. The log reader will
construct an equivalent update statement from this delete insert
pair -
unless an update in place cannot occur (ie you are updating a pk
amoung
other events).

I spoke with someone on the query optimizer team about this and he
said
it was for efficiency in the command construction process (IIRC). I
didn't really follow much more of what he said. Is it also possible
that you have cascading updates and deletes and you have not checked
the enforce constraint for replicatioin option?

--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

"Asser Maany" <asser.maany@xxxxxxxxxxxxxxxx> wrote in message
news:eV2sAbAMGHA.2628@xxxxxxxxxxxxxxxxxxxxxxx
Hi There,

I was troubleshooting a problem in my transactional replication
and
notices that SQL Server replicates some of my update statements as
Delete/Insert pairs, I was really surprised and couldn't understand
why SQL server does that, I found an article in MS support web site
http://support.microsoft.com/kb/238254/EN-US/ that is saying more or
less that this might happen in some cases, still not convinced why,
but this is a fact of life.



Found also another article saying that there is a trace flag that
would force SQL server to perform an update as an update (not
Delete/Insert pair) (http://support.microsoft.com/kb/302341/EN-US/)
but still not in all cases, again failed to understand why.



I'm struggling now to understand why does SQL server do that and also
want a solution from my problem since these delete/insert statements
are conflicting with my database referential integrity, imagine that
I'm updating an employee record that is used in almost all my tables
and has got foreign keys every where referencing it and SQL Server is
deleting this employee when I perform an update on the publisher!!



In the first article they are saying that I should change the logic
of
my triggers or replication stored procedures to handle this case, but
how can I detect that the first delete is followed by an insert for
the same record and convert them as an update.



If you faced this situation before or you have a solution for this
dilemma ,please share your experience with me.



Thanks in advance

Asser Maany














begin 666 IC_SHIPGDN_Master.xls
MT,\1X*&Q&N$`````````````````````/@`#`/[_"0`&```````````````!
M````(0``````````$ ``_O___P````#^____`````" ```#_____________
M____________________________________________________________
M____________________________________________________________
M____________________________________________________________
M____________________________________________________________
M____________________________________________________________
M____________________________________________________________
M____________________________________________________________
M____________________________________________________________
M____________________________________________________________
M______________________\)"! ```8%`-,8S0?!P ``!@,``.$``@"P!,$`
M`@```.(```!<`' `"P``07-S97(@36%A;GD@(" @(" @(" @(" @(" @(" @
M(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @
M(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @($(``@"P!&$!`@``
M`, !```]`0(``0"<``(`#@`9``(````2``(````3``(```"O`0(```"\`0(`
M```]`!(`> !X`%M*[3 X```````!`%@"0 `"````C0`"````(@`"````#@`"
M``$`MP$"````V@`"````,0`:`,@```#_?Y !``````#0!0%!`'(`:0!A`&P`
M,0`:`,@```#_?Y !``````#0!0%!`'(`:0!A`&P`,0`:`,@```#_?Y !````
M``#0!0%!`'(`:0!A`&P`,0`:`,@```#_?Y !``````#0!0%!`'(`:0!A`&P`
M,0`:`,@``0#_?[P"`````@#0!0%!`'(`:0!A`&P`,0`:`,@`! `,`) !```!
M``#0!0%!`'(`:0!A`&P`,0`:`,@`! `D`) !```!``#0!0%!`'(`:0!A`&P`
M,0`:`* ```#_?Y !``````#0!0%!`'(`:0!A`&P`'@0<``4`%P``(B0B(RPC
M(S!?*3M<*"(D(B,L(R,P7"D>!"$`!@`<```B)"(C+",C,%\I.UM2961=7"@B
M)"(C+",C,%PI'@0B``<`'0``(B0B(RPC(S N,#!?*3M<*"(D(B,L(R,P+C P
M7"D>!"<`" `B```B)"(C+",C,"XP,%\I.UM2961=7"@B)"(C+",C,"XP,%PI
M'@0W`"H`,@``7R@B)"(J(",L(R,P7RD[7R@B)"(J(%PH(RPC(S!<*3M?*"(D
M(BH@(BTB7RD[7RA 7RD>!"X`*0`I``!?*"H@(RPC(S!?*3M?*"H@7"@C+",C
M,%PI.U\H*B B+2)?*3M?*$!?*1X$/P`L`#H``%\H(B0B*B C+",C,"XP,%\I
M.U\H(B0B*B!<*",L(R,P+C P7"D[7R@B)"(J("(M(C\_7RD[7RA 7RD>!#8`
M*P`Q``!?*"H@(RPC(S N,#!?*3M?*"H@7"@C+",C,"XP,%PI.U\H*B B+2(_
M/U\I.U\H0%\I'@0D`*0`'P``6R0M-# Y761D9&1<+%P@;6UM;5P@9&1<+%P@
M>7EY>1X$&@"E`!4``%LD+30P.5UH.FUM.G-S7"!!32]031X$(0"F`!P``%LD
M+30P.5UM+V0O>7E<(&@Z;6U<($%-+U!-.T#@`!0``````/7_( ``````````
M````P"#@`!0``0```/7_( ``] ``````````P"#@`!0``0```/7_( ``] ``
M````````P"#@`!0``@```/7_( ``] ``````````P"#@`!0``@```/7_( ``
M] ``````````P"#@`!0``````/7_( ``] ``````````P"#@`!0``````/7_
M( ``] ``````````P"#@`!0``````/7_( ``] ``````````P"#@`!0`````
M`/7_( ``] ``````````P"#@`!0``````/7_( ``] ``````````P"#@`!0`
M`````/7_( ``] ``````````P"#@`!0``````/7_( ``] ``````````P"#@
M`!0``````/7_( ``] ``````````P"#@`!0``````/7_( ``] ``````````
MP"#@`!0``````/7_( ``] ``````````P"#@`!0```````$`( ``````````
M````P"#@`!0``0`K`/7_( ``^ ``````````P"#@`!0``0`I`/7_( ``^ ``
M````````P"#@`!0``0`L`/7_( ``^ ``````````P"#@`!0``0`J`/7_( ``
M^ ``````````P"#@`!0`!P```/3_````] ``````````P"#@`!0`!@```/3_
M````] ``````````P"#@`!0``0`)`/7_( ``^ ``````````P"#@`!0```"F
M``$`( ``! ``````````P"#@`!0```````$`* ``$ ``````````P"#@`!0`
M``````$`( ``(!$10"! ( ``P"#@`!0```"F``$`( ``)!$10"! ( ``P"#@
M`!0`!0````$`( ``*!$10"! ( ``P"#@`!0`!0"F``$`( ``+!$10"! ( ``
MP""3`@0`$( #_Y,"! `1@ ;_DP($`!* !/^3`@0`$X '_Y,"! `4@ G_DP($
M`!6 "/^3`@0``( `_Y,"! `6@ 7_8 $"````A0`2`$ (``````H`5&%B;&4@
M9&%T88P`! `!``$`P0$(`,$!```BO@$`_ #R`!0````2````#P``3DE.1$-$
M1$,P,# @(" @! ``3E5,3!D``'-H=6AA:6(@(" @(" @(" @(" @(" @(" /
M```@(" @(" @(" @(" @(" (``!"<F%N8VA)1 D``%1R>$YU;6)E<@<``%1R
M>$1A=&4(``!$<FEV97))1 <``%9E:&EC;&4'``!4<F%I;&5R$ ``2VEL;VUE
M=&5R4F5A9&EN9P@``$=$3D-O=6YT" ``0F]X5&]T86P)``!#;VYF:7)M960,
M``!";WA#;VQL96-T960)``!%;G1R>41A=&4)``!%;G1R>55S97($``!"54E$
M_P`:``@`&P<```P```".!P``?P```/('``#C````8P@5`&,(````````````
M`!4`````````T@H````)"! ```80`-,8S0?!P ``!@,```L"% ``````````
M``0```"2&P``.!X```T``@`!``P``@!D``\``@`!`!$``@```! `" #\J?'2
M36)0/U\``@`!`"H``@```"L``@```((``@`!`( `" ```````````"4"! ``
M`/\`@0`"`,$$% ```!4```"#``(```"$``(```!-`)(2``!<`%P`40!!`%,`
M10!2`%8`10!2`$(`50!<`$@`4 `@`$P`80!S`&4`<@!*`&4`= `@`#(`,P`P
M`# `( ```````00`!=P`M!%#_X '`0`)`)H+- AD``$`#P!8`@(``0!8`@(`
M``!!`#0`````````````````````````````````````````````````````
M```````````````````````````````````````````````!``````````$`
M```"````# $``/____\`````````````````````1$E.52(````T`H /Y\?4
MP0`````````````````````````````````````D``````````$``0``````
M`````````0`````````````````````````"````````````````````````
M``````````,`````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````@ \``$E54$@!`!$```````$````"`````0``````````````
M`P```````````````0`!`&0``0````(``@````$````"````00`T````````
M`````````````````````````````````````0````8`````````````````
M````````````````````````````````````````````````````````````
M`" `6P!N`&\`;@!E`%T`````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````( !;`&X`;P!N`&4`70``````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M``````````````````````````````````````````````!!`'(`:0!A`&P`
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M`````````#0```!0``````````$`````````P,# ``````# P, `! ``````
M``````````````D````!````9 ```````````( _````````````````````
M``$````````````````````!`0``!0$``````````````0````$`````````
M``````````!!`%,`4P!%`%(`````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````/ !!`'4`= !O`&T`80!T`&D`
M8P`^````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M```````!```````````````````````````````!`````0````$`````````
M``````$````````````````````P`````````````````````0````\````,
M`0````````\````,`0````````(```````````````\````,`0``#P````P!
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````:@```/T+``!I````_0L``&L```#_"P``:P```/X+``!M````^0L`
M`&T```#Y"P```@```/____^A`"(`"0!D``$``0`!``(`6 )8`@```````. _
M````````X#\!`%4``@`(`'T`# ``````VP\/``8``@!]``P``0`!`"0+#P`&
M``(`?0`,``(``@#;#Q<`!@`"`'T`# `#``,`20@/``8``@!]``P`! `$`-L'
M#P`&``(`?0`,``4`!0``!P\`!@`"`'T`# `&``8`MA$/``8``@!]``P`!P`'
M`$D*#P`&``(`?0`,``@`" !)#0\`!@`"`'T`# `)``D`) D/``8``@!]``P`
M"@`*`&T*#P`&``(`?0`,``L`"P#;#A<`!@`"`'T`# `,``P``!(/``8``@!]
M``P`#0`-`)()#P`&``(```(.```````$```````.````" (0```````.`/\`
M```````!#P`(`A ``0````X`_P````````$/``@"$ `#````#@#_````````
M`0\`_0`*```````;``0```#]``H````!`!L`!0```/T`"@````(`' `&````
M_0`*`````P`;``<```#]``H````$`!L`" ```/T`"@````4`&P`)````_0`*
M````!@`;``H```#]``H````'`!L`"P```/T`"@````@`&P`.````_0`*````
M"0`;``P```#]``H````*`!L`#0```/T`"@````L`' `/````_0`*````# `;
M`! ```#]``H````-`!L`$0```/T`"@`!````&0``````O0`2``$``0`9````
M.D :``#MXD "`/T`"@`!``,`&0`!````_0`*``$`! `9``$```#]``H``0`%
M`!D``0```+T`) `!``8`&0``````&0```#) &0``L'5 &0``L'5 &0``````
M"@`#`@X``0`+`!H`5 5\Q!;MXD#]``H``0`,`!D``@```/T`"@`!``T`&0`#
M`````0(&``,````8`-<`"@"N`0``* #$`*0`/@(2`+8&`````$ `````````
M`````!T`#P`#%P`%`````0`7`!<`!07O``8`" `W````"@``````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M`````````````````````````/[_```%`0(```````````````````````$`
M``#@A9_R^4]H$*N1" `K)[/9, ```*@````'`````0```$ ````$````2 ``
M``@```!<````$@```' ````,````B ````T```"4````$P```* ````"````
MZ 0``!X````,````07-S97(@36%A;GD`'@````P```!!<W-E<B!-86%N>0`>
M````$ ```$UI8W)O<V]F="!%>&-E; ! ````@,NPS14PQ@% `````*6J:!@P
MQ@$#````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M``````````````````````````#^_P``!0$"```````````````````````!
M`````M7-U9PN&Q"3EP@`*RSYKC ```#0````"0````$```!0````#P```%@`
M```7````; ````L```!T````$ ```'P````3````A ```!8```",````#0``
M`)0````,````JP````(```#H! ``'@````P```!-:6-R;W1E8V@````#````
MV!@+``L`````````"P`````````+``````````L`````````'A ```$````+
M````5&%B;&4@9&%T80`,$ ```@```!X````+````5V]R:W-H965T<P`#````
M`0``````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M`````````````````````````````0````(````#````! ````4````&````
M!P````@````)````"@````L````,````#0````X````/````_O___Q$````2
M````$P```!0````5````%@```!<```#^____&0```!H````;````' ```!T`
M```>````'P```/[____]_____O__________________________________
M____________________________________________________________
M____________________________________________________________
M____________________________________________________________
M____________________________________________________________
M____________________________________________________________
M____________________________________________________________
M____________________________________________________________
M__________________________________________________]2`&\`;P!T
M`" `10!N`'0`<@!Y````````````````````````````````````````````
M````````````````%@`%`?__________`@```" (`@``````P ```````$8`
M```````````````@:A""&##&`?[___\``````````%<`;P!R`&L`8@!O`&\`
M:P``````````````````````````````````````````````````````````
M```````2``(!________________````````````````````````````````
M`````````````````````'T>````````!0!3`'4`;0!M`&$`<@!Y`$D`;@!F
M`&\`<@!M`&$`= !I`&\`;@```````````````````````````````````"@`
M`@$!`````P```/____\`````````````````````````````````````````
M```````0`````! ````````%`$0`;P!C`'4`;0!E`&X`= !3`'4`;0!M`&$`
M<@!Y`$D`;@!F`&\`<@!M`&$`= !I`&\`;@``````````````. `"`?______
M_________P```````````````````````````````````````````````!@`
*````$ ``````````
`
end

.

Relevant Pages

  • Re: UPDATE Statements May be Replicated as DELETE/INSERT Pairs
    ... I couldn't really tell what was the update statement that caused this ... Looking for a SQL Server replication book? ... Delete/Insert pairs, I was really surprised and couldn't understand ...
    (microsoft.public.sqlserver.replication)
  • RE: SqlMail using POP3/SMTP on a Windows 2003 Server
    ... What's the detail error message it shown when access violation? ... Office and SQL Server has been installed on your machine? ... you have SQL Server Service Pack 2 installed. ... MAPI Initialize and MAPI Unitialize for every thread that uses MAPI API. ...
    (microsoft.public.sqlserver.setup)
  • Re: Return SQL Server Error Msg
    ... Cannot insert duplicate key in ... > Violation of PRIMARY KEY constraint 'PK_Stages'. ... how could I return the error msg returned by SQL Server? ...
    (microsoft.public.sqlserver.programming)
  • Re: Update question
    ... Hi Simon, ... Yes, it is allowed by SQL Server, though it is on violation of relational ...
    (microsoft.public.sqlserver.programming)