469,898 Members | 1,741 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,898 developers. It's quick & easy.

SQL Server table changes log

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
Jul 20 '05 #1
1 2000

"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
Jul 20 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Ryan McLean | last post: by
1 post views Thread by System Audit | last post: by
1 post views Thread by Waqarahmed | last post: by
reply views Thread by Salome Sato | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.