• In SSMS. Right-click on the database and choose Reports. Choose Standard Reports | Schema Changes History.

    That will give you time/date and who did it, provided the info is still in the default trace. Unfortunately, it won't give you IP.

    K. Brian Kelley
    @kbriankelley