i have a need to perform multiple bulk inserts into 3 different tables within a transaction so that if any 1 of the 3 fails then ALL are rolled back. i have read up on this article which implies it can be done http://msdn.microsoft.com/en-us/library/tchktcdk(v=VS.90).aspx but it doesnt really show how do what i need to do... anyone any experience here would be greatly appreciated....
|