Question 18


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:

  • Chapter 8, "Troubleshooting and Optimizing SQL Server"

  • SQL Server 2005 Books Online: "Database Engine How-to Topics, Performance Monitoring and Tuning How-to Topics, Server Performance and Activity Monitoring How-to Topics, How to: Open the Activity Monitor (SQL Server Management Studio)"

  • "sysprocesses," http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sys-p_3kmr.asp




MCTS 70-431(c) Implementing and Maintaining Microsoft SQL Server 2005
MCTS 70-431 Exam Cram: Implementing and Maintaining Microsoft SQL Server 2005 Exam
ISBN: 0789735881
EAN: 2147483647
Year: 2006
Pages: 200
Authors: Thomas Moore

Similar book on Amazon

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net