数据库被卡住一天了，停止数据库服务停不了，kill进程提示事务回滚0%

 SELECT

log.name 



 AS [Name],

log.principal_id AS [ID],

ISNULL(ak.name 



,N'') AS [AsymmetricKey],

ISNULL(cert.name 



,N'') AS [Certificate],

ISNULL(c.name 



,N'') AS [Credential],

CASE WHEN N'U' = log.type THEN 0 WHEN N'G' = log.type THEN 1 WHEN N'S' = log.type THEN 2 WHEN N'C' = log.type THEN 3 WHEN N'K' = log.type THEN 4 END AS [LoginType]

FROM

sys.server_principals AS log

LEFT OUTER JOIN master.sys.asymmetric_keys AS ak ON ak.sid = log.sid

LEFT OUTER JOIN master.sys.certificates AS cert ON cert.sid = log.sid

LEFT OUTER JOIN sys.credentials AS c ON c.credential_id = log.credential_id

WHERE

(log.type in ('U', 'G', 'S', 'C', 'K') AND log.principal_id not between 101 and 255 AND log.name 



 <> N'##MS_AgentSigningCertificate##')

ORDER BY

[Name] ASC