存储过程
USE XXXX
GOSELECT obj.Name 存储过程名, sc.TEXT 存储过程内容
FROM syscomments sc
INNER JOIN sysobjects obj ON sc.Id = obj.ID
WHERE sc.TEXT LIKE '%' + 'usr' + '%'
AND TYPE = 'P'
GO
作业
select * from msdb.dbo.sysjobsteps where command like '%usr%'
存储过程
USE XXXX
GOGO
作业
select * from msdb.dbo.sysjobsteps where command like '%usr%'