select distinct object_name(id) from syscomments

where id in (select object_id from sys.objects where type='P') and text like '%keywords%'

select request_session_id spid, OBJECT_NAME(resource_associated_entity_id) tableName

from sys.dm_tran_locks

where resource_type='OBJECT'

kill id

-- 设置允许显式插入自增列

SET IDENTITY_INSERT tablename ON

-- 设置不允许显式插入自增列

SET IDENTITY_INSERT tablename Off

truncate table tablename --truncate方式会直接删除表中数据

DBCC CHECKIDENT (tablename,reseed,0) --重置表中标识列为指定值，不删除表中数据，慎重使用

DBCC CHECKIDENT (tablename,noreseed) --查询表中当前标识列的最大值
--笨方法：删除自增列，然后重新添加同名自增列