YoumanageadatabasenamedDB1,whichislocatedonaSQLServer2005computer.YoureceiveawarningthatthedriveonwhichtheDB1logfileislocatedisnearcapacity.Althoughthetransactionlogisbackedupeveryfiveminutes,youobservethatitissteadilygrowing.Youthinkthatanuncommittedtransactionmightbethecauseandyouwanttoinvestigate.YouneedtoidentifyboththeserverprocessIDandthestarttimeoftheoldestactivetransactioninDB1.Whatshouldyoudo?()
A.ConnecttotheDB1database.ExecuteDBCCOPENTRAN.ViewtheSPIDandStarttimerows.
B.Connecttothemasterdatabase.ExecuteDBCCOPENTRAN.ViewtheSPIDandStarttimerows.
C.InSQLServerManagementStudio,opentheActivityMonitor.SelecttheProcessInfopageandapplythefollowingfiltersettings,Database=DB1OpenTransactions=YesViewtheProcessIDandLastBatchcolumns.
D.Openaquerywindow.Connecttothemasterdatabase.Executethefollowingstatement.SELECTTOP1spid.lastbatchFROMsys.sysprocessesWHEREdbid=dbid(’DB1’)ANDopentran>0ORDERBYlastbatch