TSQL常用查询语句

能过参数查询存储过程。
select b.name
from dbo.syscomments a,dbo.sysobjects b where a.id=b.id  and b.xtype='p' and a.text like '%insert into%'

修改为默认dbo对象
exec sp_changeobjectowner '要改的表名','dbo'
批量修改：
EXEC sp_MSforeachtable 'exec sp_changeobjectowner ''?'',''dbo'' '