Modification date of objects

Hello there
Is there a way to know whan was the last time i've mofied objects? tables,
views, store procedures ect...?You can determine when they were created (crdate in sysobjects) but not
when they were modified. Use a source control system for that.
David Portas
SQL Server MVP
--|||That information is not available from SQL Server. If you really need it you
can use a product like Lumigent's LogExplorer to trail through your
transaction logs, but the best thing to do is use a Source Control system
like SourceSafe.
Jacco Schalkwijk
SQL Server MVP
"Roy Goldhammer" <roygoldh@.hotmail.com> wrote in message
news:OrVEKZIKFHA.2212@.TK2MSFTNGP12.phx.gbl...
> Hello there
> Is there a way to know whan was the last time i've mofied objects? tables,
> views, store procedures ect...?
>
>|||What is Source Control System?
And how can i get it and use it?
"Jacco Schalkwijk" <jacco.please.reply@.to.newsgroups.mvps.org.invalid> wrote
in message news:uIW6CkIKFHA.576@.TK2MSFTNGP15.phx.gbl...
> That information is not available from SQL Server. If you really need it
you
> can use a product like Lumigent's LogExplorer to trail through your
> transaction logs, but the best thing to do is use a Source Control system
> like SourceSafe.
> --
> Jacco Schalkwijk
> SQL Server MVP
>
> "Roy Goldhammer" <roygoldh@.hotmail.com> wrote in message
> news:OrVEKZIKFHA.2212@.TK2MSFTNGP12.phx.gbl...
tables,
>|||A Source Control program is an application that maintains a code
repository, records changing versions of code and logs who makes
changes and when. You can put into source control any stored procedure
scripts and DDL scripts for your database. Some form of source control
is pretty much essential if you have more than 1 or 2 people cutting
code. Of course, if you give DDL admin rights to your developers then
they still need to be disciplined enough to ensure they put every
change into source control...
SourceSafe is MS's source control offering and it's included with the
Enterprise editions of VisualStudio, or available as a separate
purchase. There are alternative products available though and you can
Google for those.
David Portas
SQL Server MVP
--