Objects by date

Is there a way to pull a list of objects by modified date?
like views, procedures and so on...
Thanks,
VictorBy modified, do you mean when data in tables were modified, or structure of
tables? SQL Server
doesn't keep track of when data were modified. For 2005, you can see when st
ructure were modified in
sys.objects.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Victor Rodriguez" <lasalsatx@.newsgroups.nospam> wrote in message
news:e%23OmtzibGHA.3908@.TK2MSFTNGP02.phx.gbl...
> Is there a way to pull a list of objects by modified date?
> like views, procedures and so on...
> Thanks,
> Victor
>|||I mean changes on the structure of objects.
thanks,
Victor
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23K7Cx3ibGHA.3352@.TK2MSFTNGP03.phx.gbl...
> By modified, do you mean when data in tables were modified, or structure
> of tables? SQL Server doesn't keep track of when data were modified. For
> 2005, you can see when structure were modified in sys.objects.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Victor Rodriguez" <lasalsatx@.newsgroups.nospam> wrote in message
> news:e%23OmtzibGHA.3908@.TK2MSFTNGP02.phx.gbl...
>|||Hi Victor,
Thanks for your post.
As Tibor mentioned, you could find the latest modified datetime of each sql
server object in the sys.objects catalog view.
The column modify_date includes the date when the object was last modified
by using an ALTER statement. If the object is a table or a view,
modify_date also changes when a clustered index on the table or view is
created or altered.
The column type_desc includes the object type. Example:
SQL_STORED_PROCEDURE
USER_TABLE
VIEW
Here is the article about sys.objects catelog view:
sys.objects (Transact-SQL)
http://msdn2.microsoft.com/en-us/library/ms190324.aspx
Thank you for your patience and hope this will be helpful.
Sincerely,
Wei Lu
Microsoft Online Community Support
========================================
==========
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
==========
This posting is provided "AS IS" with no warranties, and confers no rights.