Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
codebased
Starting Member
5 Posts |
 Posted - 2009-05-16 : 04:29:43
|
| hi guys, somebody has just deleted a column from the production database. how can I check that who has done that? any way to check? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
YellowBug
Aged Yak Warrior
616 Posts |
Posted - 2009-05-16 : 05:38:42
|
| Schema Changes History Report will tell you who changed the table recently. Will not give all the details though, but maybe enough to help you. |
 |
|
|
codebased
Starting Member
5 Posts |
Posted - 2009-05-16 : 05:51:12
|
quote:
Originally posted by YellowBug
Schema Changes History Report will tell you who changed the table recently. Will not give all the details though, but maybe enough to help you.
Thank you for the reply. Yes, you are right that I could find that the table has modified under the login. But the report is suggesting the command type only i.e. "ALTER". |
|
|
|
|
|
|
audit deleted column