网友您好, 请在下方输入框内输入要搜索的题目:
TestKing.comusesSQLServer2005.Auserreportsthatanorderprocessingapplicationstoppedrespondinginthemiddleofanordertransaction.TheusersSQLServersessionIDis54.Youneedtofindoutifsession54isblockedbyanotherconnection.Ifitis,youneedtoidentifytheblockingsessionID.Whataretwopossiblewaystoachievethisgoal?()
A.InSQLServerManagementStudio,opentheActivityMonitor.OpentheProcessInfopage.ViewtheblockedBycolumnforsession54.
B.InSQLServerManagementStudio,opentheActivityMonitor.OpentheLocksbyProcesspage.ViewtheRequestModecolumnforsession54.
C.InSQLServerManagementStudio,openanewquerywindowandexecutethefollowingstatement.SELECT*FROMsys.dmexecrequestsWHEREsessionid=54Viewtheblockingsessionidcolumn.
D.InSQLServerManagementStudio,openanewquerywindowandexecutethefollowingstatement.SELECT*FROMsys.dmexecsessionsWHEREsessionid=54Viewthestatuscolumn.
参考答案