Date of import of an object - backup SQL Maintenance Plan

andy76

Hello,

I want to know if there is a method to understand when an object has been imported/replaced in a database both SQL (2000 or 2005) or DB Nav standard [not the date of last modification in version list].

I want to be sure that the backup complete of SQL scheduled by Maintenance plan/Integration service include also all object (fob) modified because I am not sure of that.

Thank you very much.

DenSter

A full SQL Server backup includes the entire database, including all the objects in their state when you run the backup. No need to also create a NAV backup.

andy76

Ok, but how to see when an object (fob : table / report / dataport/report / codeunit...) has been imported / replaced in a db?

Thank you

DenSter

There is no standard way to see that. The only way that I know to make 100% sure that there is no difference between two versions of an object is to export the object as text and compare it with a text compare tool.