objects

How can I get a list of all view, procedures, tables that has been
change/edit in the last month?
Thanks,
VictorSELECT *
FROM sys.objects
WHERE modify_date > DATEADD(month, -1, GETDATE())
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
--
"Victor Rodriguez" <lasalsatx@.newsgroups.nospam> wrote in message
news:OHcK$I3eGHA.1456@.TK2MSFTNGP04.phx.gbl...
> How can I get a list of all view, procedures, tables that has been
> change/edit in the last month?
> Thanks,
> Victor
>|||Thank you very much!!!
Victor
"Adam Machanic" <amachanic@.hotmail._removetoemail_.com> wrote in message
news:OSJz9K3eGHA.4912@.TK2MSFTNGP05.phx.gbl...
> SELECT *
> FROM sys.objects
> WHERE modify_date > DATEADD(month, -1, GETDATE())
>
> --
> Adam Machanic
> Pro SQL Server 2005, available now
> http://www.apress.com/book/bookDisplay.html?bID=457
> --
>
> "Victor Rodriguez" <lasalsatx@.newsgroups.nospam> wrote in message
> news:OHcK$I3eGHA.1456@.TK2MSFTNGP04.phx.gbl...
>> How can I get a list of all view, procedures, tables that has been
>> change/edit in the last month?
>> Thanks,
>> Victor
>>
>