I recently was bitten by some not so obvious behavior with DBCC OPENTRAN() that I would like to share. Basically this command is supposed to show you the oldest open transaction within the specified database or the current one if none is specified. If
Read More...