Check Objects “Modify Date” using “sys.all_objects”
If you need to check “Modify Date” for NAV Objects on SQL Server, you can use SQL Standard Function “sys.all_objects“; you don’t need to use standard NAV Objects Table.
Examples:
USE [Demo Database NAV (7-1)] GO
— VIEWS
SELECT * FROM sys.all_objects WHERE type_desc like ‘VIEW’ ORDER BY modify_date DESC
— TABLES
SELECT * FROM sys.all_objects WHERE type_desc like ‘USER_TABLE’ ORDER BY modify_date DESC
— VIEWS & TABLES
SELECT * FROM sys.all_objects WHERE type_desc like ‘VIEW’ or type_desc like ‘USER_TABLE’ ORDER BY modify_date DESC
— KEYS
SELECT * FROM sys.all_objects WHERE type_desc like ‘%KEY%’ ORDER BY modify_date DESC
— COMPANY OBJECTS (ex Cronus Italy)
SELECT * FROM sys.all_objects WHERE name like ‘CRONUS%’ ORDER BY modify_date DESC
— ALL OBJECTS
SELECT * FROM sys.all_objects ORDER BY modify_date DESC
Have Fun !
Pingback: Check Objects “Modify Date” using “sys.all_objects” | Pardaan.com