SQL2012 几个常用的脚本

USE TiconBPMTest--要收缩的数据库名
--查找日志文件
select name,size/128 AS sizeM from sysfiles 

ALTER DATABASE TiconBPMTest--要收缩的数据库名
SET RECOVERY SIMPLE;
GO
DBCC SHRINKFILE (BPMProduct_log, 1);--日志文件名
GO
ALTER DATABASE TiconBPMTest--要收缩的数据库名
SET RECOVERY FULL;
GO

--查找包含某个字段的表名
select distinct so.name from dbo.syscolumns sc,dbo.sysobjects so 
where sc.id=so.id and so.type='U' and sc.name='Group' 
order by so.name desc

--查询存储过程内容包含关键字
select name 
from sysobjects o, syscomments s 
where o.id = s.id 
and text like '%Dept_OfficeCode%' 
and o.xtype = 'P' 

select session_id, Text,r.blocking_session_id 
from sys.dm_exec_requests r  
cross apply sys.dm_exec_sql_text(sql_handle) t