Last modified date of a view
This is a discussion on Last modified date of a view within the SQL Server forums, part of the Microsoft SQL Server category; --> How to get the date a view was last modified? (As opposed to created)...
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-28-2008, 07:02 PM
| |||
| |||
 Re: Last modified date of a view Trev@Work (bouncer@localhost) writes: > How to get the date a view was last modified? (As opposed to created) Alas this information is not available in SQL Server. There is a column schema_ver in sysobjects which appears to be incremented by 16 each time you alter the view, but that is as close as you get. -- Erland Sommarskog, SQL Server MVP, sommar@algonet.se Books Online for SQL Server SP3 at http://www.microsoft.com/sql/techinf...2000/books.asp      |
|
02-28-2008, 07:03 PM
| ||||
| ||||
| Re: Last modified date of a view "Erland Sommarskog" <sommar@algonet.se> wrote in message news:Xns94464E4FE2E5Yazorman@127.0.0.1... > Trev@Work (bouncer@localhost) writes: > > How to get the date a view was last modified? (As opposed to created) > > Alas this information is not available in SQL Server. There is a column > schema_ver in sysobjects which appears to be incremented by 16 each time you > alter the view, but that is as close as you get. That may help, thanks. |
Linear Mode
