sql server replication: HOW TO PREVENT DUPLICATE RECORDS IN SQL EXPRESS 2005 -- sql server replication

HOW TO PREVENT DUPLICATE RECORDS IN SQL EXPRESS 2005

mca
5/26/2006 6:06:18 AM

sql server replication: Hi everyone!

I am a computer engineer and have recently upgraded to .net 2005. With
new data components available, I have decided to write a simple
database application in order to get familiar with the new aspects of
..net 2005.

Here is my problem : When I try to update a record on an sql 2005
express database via a datalist component, updated records multiply
itself. Hence multiple instances of same record occupies my database.
Moreover these instances can not be deleted.

If anyone knows anything to fix this problem, please help me!

Sincerely;

Can AKPINAR
mehmetcanakpinar@gmail.com

Re: HOW TO PREVENT DUPLICATE RECORDS IN SQL EXPRESS 2005

Hilary Cotter
5/28/2006 12:00:00 AM

I think you need to only insert the rowschanged as opposed to each row in
the data list. Can we see your code to verfiy this is what is occurring?

--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

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

[quoted text, click to view]