?????????????
????select spId
????from master..SysProcesses
????where db_Name(dbID) = '?????????'
????and spId <> @@SpId
????and dbID <> 0
???????????
????exec ('Kill '+cast(@spid  as varchar))
?????????????
????select   request_session_id   spid??OBJECT_NAME(resource_associated_entity_id) tableName
????from   sys.dm_tran_locks where resource_type='OBJECT'
????spid ???????
????tableName ????????
??????????
????declare @spid  int
????Set @spid  = 57 --???????
????declare @sql varchar(1000)
????set @sql='kill '+cast(@spid  as varchar)
????exec(@sql)