Sql database file modified date

Any thoughts how to do this please? Hello all, I was just thinking about a situation which I have been tasked with in that I have a package that is scheduled to run once a day which will import data from a flat file. The data does not have any distinguishing time that can be used to see whether or not it is beyond a last imported time. I was wondering, is there a way to access the date modified of the file? If so I could simply append this time to a table which keeps track of all of the files and the modified dates which I have ever imported for this task.

Why is it that, even though the database is modified daily, the modified date on the data file is not updated? I am taking a "complete backup" of my production db every day using Backupagent of Arcserver But the Modified Date of.

Is it normal? Thanks Wilson. Does anyone know how to get a table's 'last modified date' in SQL 7? Sysobjects contains the 'create date', but I can't find a 'last modified date' anywhere Is there any query please let me know.

Regards, S. I noticed that the windows explorer "date modified" field for my database files. MDF files doesn't change much even though there is activity going on. Sometimes it doesn't change for a week.

Is this the expected behavior? Could it be that no data is changing in my database? I find that hard to believe Thanks for any insights. In SQL Server is there a way to know when a procedure was lastmodified?

I only see the "Create Date" column on the EnterpriseManager. Thanks Experts! I appreciate any tips or suggestions provided! TIA - Rob. Thanks, Siva. How do I know the last updated data date using system objects or any other method? How do I know the last modified date of a table using system objects or any other method? How do I know when a table is last accessed Any help is appreciated Thanks for your time and help in advance Kumar.

Should you use UTC dates? Do you use a default for the creation date I assume yes? Should you create a trigger to handle the last update date? Or do you update the column directly in your stored procedures that modify data? You can use this procedure to find the owner of a stored procedure.

Executing it will give you the output like the below image. If you want to find the owner of a particular stored procedure, you can pass the name of the stored procedure as an input parameter. For example, if I want to know the owner of a stored procedure named Circle , I will write the query as:.

Read: SQL Server stored procedure vs function. In this section, we will discuss how you can check the last execution time of a stored procedure. When you execute any stored procedure or function in SQL Server, the entry is temporarily stored in the cache. You can access the last execution time of a stored procedure in the cache. The sys. But, this method is not reliable. Because you can only get the execution history of the cached objects only. If the object is removed from the cache, you will not be able to access the execution history.

However, if you want a permanent solution, you can implement your own logic. You can create a log table for storing the execution history of stored procedures. You can put an Insert statement at the end of every stored procedure to insert the name of the stored procedure and the current date and time. For example, if you have created a table as StoreLog , you can put an Insert statement like the following code at the end of every stored procedure:.

Thus, you might have learned various methods to track the execution history of stored procedures. At the end of this article, you might be aware of various methods that you can use to find the information about the stored procedures in your database.

Ask a question. Quick access. Search related threads. Remove From My Forums. Answered by:. Archived Forums. Configuration Manager General.