Database contention

[Darkness84]

I have a service (which I have written in C#) that I want to run on 2 different computers however they will both be accessing the same database. Is there a way to tell when one computer is writing to the database so I can stop the other from writing to it at the same time to avoid contention issues?

[Dave Kreskowiak]

It would help to know what kind of database... Access, SQL Server, ...

Dave Kreskowiak Microsoft MVP - Visual Basic

[Darkness84]

SQL Server 2005

[Dave Kreskowiak]

In that case, no, you don't have to worry about it. SQL Server maintains order on its own. Just keep in mind that the "last write" will win.

Dave Kreskowiak Microsoft MVP - Visual Basic