You are the database administrator for your company. You manage all the SQL Server 2008 databases in yourcompany. The Prod_details database is the main database accessed by the company’s users. The head officereceives data from other branches of the company. After the data is verified by employees of the auditdepartment, the database is updated with this information. Some employees in the audit department complain they cannot update data in certain tables. You suspect thatother database users are holding locks on these tables.
You must identify the oldest transaction in the database and the SQL Server logins associated with thetransaction.
Which statements or functions should you use to obtain the desired results? (Choose two. Each answerrepresents a part of the solution.)