I wasn't sure if I was going mad or if something strange was happening with
my SQL Server 2005. I was convinced that changes I had made to
tables/views/procs etc were 'dissappearing' from time to time.
I have just written (couple of days ago) a ddl trigger that audits ddl
changes to an audit table.
This morning I looked at my database and noticed that a couple of objects
that I create yesterday were no longer in my db. I checked in my ddl audit
table to find that I had created the objects and I wasn't going mad.
Could someone advise me on how to find out what is going on.
Terry,
in Management Studio you can view a report "Schema Changes History"
which shows you which objects have been created, altered or dropped
and by which user. You need to select your server name and then either
go to the reports tab of the Summary page (pre SP2) or right click the
server and go to standard reports (SP2).
Markus
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment