mod date for view

mod date for view

Post by jj » Fri, 20 Jun 2003 20:43:34



Hello,
What query would tell me the modification date for a view?

Thanks
jj

 
 
 

mod date for view

Post by Aaron Bertrand - MV » Fri, 20 Jun 2003 20:47:50


SQL Server doesn't track this information.  However, if you use source
control and follow a sane check-in process, your source control tool should
tell you.


Quote:> Hello,
> What query would tell me the modification date for a view?

> Thanks
> jj


 
 
 

1. Find out last mod. date of a table

I was wondering is there a way to find the last time a table was updated
in a database without using either 1)a timestamp column or 2)auditing.
In other words, I have tables in a production system and I just want to
find out at anytime when the last time any one table was
updated/inserted/deleted.

I don't think there is a way off the top of my head but maybe other
Sybase DBAs have ideas?

Thanks

Sent via Deja.com http://www.deja.com/
Before you buy.

2. EXE Argument

3. last mod date for a specific field

4. Tbrowse Objects in Clipper

5. Q: Getting The Date/Time Of The Last Mod Of A Sql svr Table

6. Help: "The setup routines for the SQL Server ODBC driver could not be loaded due to system error code 126"

7. Problems with date mod/SAVE UNTIL

8. Architectural concerns

9. Julian dates to normal date in view

10. ((Current Date - Start Date)/(End Date - Start Date))*Contract Amt

11. FTP DTS jobs - HELP How to tell when file mod changes

12. SQL-SERVER-SYBASE ( MOD, % )

13. MOD function in SQL