Answer C is correct. The DBCC OPENTRAN command will only give you the last open transaction for a particular database. There is no such command as sp_helptransaction, and executing a query against any system tables would be difficult to resolve the desired information, although it could be possible. By far the easiest technique, assuming access to the 2005 toolset, is to use the Activity Monitor. For more information, see the following sources:
|