locked
Deleted appointment in SQL RRS feed

  • Question

  • Hello, I'm sorry for my english this is not very well.

    I have CRM Dynamics 2013 and I have deletd one or more appointment, where can I see deleted appointment in Sql? In which table can I filter this?

    Thank you very much!!!

    Bye

    Tuesday, October 14, 2014 9:16 AM

All replies

  • I don't think deleted data is stored in the SQL Database.

    If you have SQL back-ups you can restore to a previous backup to recover the deleted records.

    • Proposed as answer by Mohd Saad Tuesday, October 14, 2014 9:50 AM
    Tuesday, October 14, 2014 9:26 AM
  • Thank you but in in CRM there is the audit log, in this I have all the deleted appoint but I can filter this by name of the account.

    I think that the audit Log is registered in SQL. What is the name of the table for audit?

    Thanks a lot!!

    Wednesday, October 15, 2014 9:08 AM
  • The audit logs are stored in table dbo.auditbase (or view dbo.audit).
    Problem is you can't "see" the changes in 1 table. Only ID's are stored here.
    You will probably need to join multiple tables with dbo.auditbase
    Wednesday, October 15, 2014 9:13 AM