I am using IDENT_CURRENT to get the id of a record from a table and using it somewhere else (for data insertion, updating). I understand that this not correct from a multi-user perspective since another user can access the same table and all hell can break loose.

My question is this :
If I surround the SQL code using all my inserts and updates with transactions will it guarantee that data will not be corrupted?...

Please note that when B appears (becomes visible) it shows up on top of the mouse pointer. This is on purpose and works fine.

I have two windows forms. (A and B).
A contains an instance of B
A and B are both invisible at program startup. A sits in the Taskbar at program
startup with a NotifyIcon. When the NotifyIcon recieves a left mouse click event
B becomes visible. (mouse is not released at this point).

B has mouse move / mouse down events however they don't fire until the mouse is released and clicked again. Why? Is there...