April 10, 2013 at 7:06 am
Hello,
I am trying to find out how can I track changes in my database, how deleted table or updated table etc, how can I track this?
Thank you
April 10, 2013 at 7:28 am
have a google at DDL Triggers.
April 10, 2013 at 7:40 am
Yes,this is just for tables,what about any changes on database?
April 10, 2013 at 7:49 am
Krasavita (4/10/2013)
Yes,this is just for tables,what about any changes on database?
Default trace[/url] could provide most of what you're looking for.
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
April 10, 2013 at 7:52 am
Krasavita (4/10/2013)
Yes,this is just for tables,what about any changes on database?
DML Triggers are for tables.
DDL Triggers are for the rest.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply