asked
when was table one column removed from table in sql??
I want to know when was one column removed from table in sql? what time? is it possible???
Assuming that nothing else changed in the table, you can use the default trace to help determine this, to a point. The trace won't explicitly tell you the exact command (not that I found anyway), but it will tell you that the table was altered. Look for EventClass = 164, which is the 'Object:Altered'. The ObjectName column will tell you the table name that was altered.
http://blogs.technet.com/b/beatrice/archive/2008/04/29/sql-server-default-trace.aspx Hope this helps!
Alternately you can also check the 'Schema Changes History' report of the Database. Right Click on the Database--> Reports --> Standard Reports --> Schema Changes History. This will also give you the user executing the command. Hope this helps...
+1 This report reads from the default trace, so it's a nice easy way of getting the data out
yes dhamandave you are right............ and thanking you johnmorehouse.......
Glad to know it helped :) It would be helpful if you mark the answer as correct so that it could assist others for future reference. Thanks... Cheers !
12 People are following this question.
