Last modified date of a view

How to get the date a view was last modified? (As opposed to created)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/techin.../2000/books.asp|||"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.