SQLserver查进程
SELECT request_session_id
spid,OBJECT_NAME(resource_associated_entity_id)tableName
FROM
sys.dm_tran_locks
WHERE resource_type='OBJECT'
![查进程sql,复制网址即可查看!谢谢](https://img-blog.csdnimg.cn/b4a7f7cbe9cc4daaa520e891c8207205.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBAcXFfNDMwMDExMzI=,size_20,color_FFFFFF,t_70,g_se,x_16#pic_center)
SQLserver杀进程
KILL (spid)
如:kill 61