--USE [HrPortal]
USE [SUP_SUPOK2]
--USE [ACCPAC]
go
SELECT
--m.definition
DISTINCT o.schema_id, s.name, o.name AS Object_Name, o.type_desc, o.create_date, o.modify_date
FROM sys.sql_modules m
INNER JOIN sys.objects o ON m.object_id = o.object_id
LEFT JOIN sys.schemas s ON o.schema_id = s.schema_id
--WHERE m.definition Like '%Latest modification date: 05-
(
Read more... )