Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

SQL Server table changes log

slaha11slaha11 Member Posts: 28
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


Comments

  • mark baekdalmark baekdal Member Posts: 3
    you can't, you need a database change management process. Check out DB Ghost (http://www.dbghost.com)



    regards,
    Mark Baekdal
    http://www.dbghost.com
    http://www.innovartis.co.uk
    +44 (0)208 241 1762
    Database change management for SQL Server



    : 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
    :
    :
    :

Sign In or Register to comment.