SQL Server table changes log

[Surajit Laha]

Hi,

How can I find out when a particular table structure (design) was last
modified?

I want to find out whether the creation and modification date of the
table are same, to find out if anyone has ran a DDL statement against
the table!

regards,

Surajit Laha

[Simon Hayes]

"Surajit Laha" <s_****@rediffmail.com> wrote in message
news:ba**************************@posting.google.c om...

Hi,

How can I find out when a particular table structure (design) was last
modified?

I want to find out whether the creation and modification date of the
table are same, to find out if anyone has ran a DDL statement against
the table!

regards,

Surajit Laha

MSSQL only stores the create date, not the modification date for objects, so
there's no real way to find this out (unless the object was dropped and
recreated, of course). If you have transaction log backups, you could use a
third-party tool to search in the log for changes:

http://www.lumigent.com/products/le_sql.html

If you want to monitor DDL statements in future, you could use a trace - see
sp_trace_create in Books Online.

Simon