SQL server存储模糊查询

SQL存储模糊查询

查询存储和函数

SELECT OBJECT_NAME(sm.object_id) object_name, * FROM sys.sql_modules AS sm

查询含有12345的存储和函数

SELECT  OBJECT_NAME(sm.object_id) object_name, * FROM sys.sql_modules AS sm
WHERE sm.definition LIKE '%12345%'

查询作业执行命令

查询执行命令含有XXX的作业

SELECT  [job].[name] AS '作业名称'
       ,[jstep].[step_name] AS '步骤名称'
       ,[jstep].[database_name] AS '执行数据库名'
       ,[jstep].[command] AS '执行命令'
FROM    [msdb].[dbo].[sysjobsteps] AS [jstep]
        INNER JOIN [msdb].[dbo].[sysjobs] AS [job] ON [jstep].[job_id] = [job].[job_id]
WHERE   [jstep].[command] LIKE '%XXX%'
ORDER BY [job].[name]
       ,[jstep].[step_id]

查询是否发布

SELECT * FROM distribution.dbo.MSarticles AS ms