摘要:
--查找运行中的事务,输出其内容,并将其杀死IFNOTEXISTS(SELECT*FROMtempdb.dbo.sysobjectsWHEREid=object_id(N'tempdb..#OpenTranStatus')ANDtype='U')BEGINCREATETABLE#OpenTranStatus(ActiveTransactionVARCHAR(25),Detailssql_variant)ENDELSEBEGINDELETE#OpenTranStatusEND--Executethecommand,puttingtheresultsinthetab
阅读全文