Double Row Insertion

[quwesi]

When I execute an INSERT statement to add a row to a table within my SQLsever database I realise that the row is inserted TWICE.

Any idea how to resolve this?

Thanks

 

[r937]

there's a bug in your application code, you're executing the INSERT twice

r937.com | rudy.ca

 

[macleod1021]

Also, check to make sure you don't have any triggers that are replicating the data.

im in ur stakz, overflowin ur heapz!

 

[SQLSister]

Or if you are inserting based on a selct statement with a join, could be one of the join tables has two rows. Withouthseeing the actual insert statment it is hard to diagnose the problem.

"NOTHING is more important in a database than integrity." ESquared