How can I see the actual problem/error from a logged exception? RRS feed

  • Question

  • On my Azure SQL "Server" I have a few SQL Databases, on the "Server" I have enabled Server-level auditing.  On the SQL Database I click "Auditing" then "View Audit Logs" and I see my stored procedure call like this which returned as "Failed":

    Event time (UTC)12/2/2019 10:24:10 PM
    Event type    RPC COMPLETED
    Server name    sydbsqlserveruat
    Database name    sqlUS_ETeB9bb6b9
    Application name    Core Microsoft SqlClient Data Provider
    Principal name    mysa
    Client IP
    Status    Failed

    I click on the audit log record and can see the Statement just as-expected.  But I am trying to find WHAT the error was and cannot.  I've gone to the SQL "Server" Logs (in the Monitoring task panel) and have run a bunch of the Sample Queries such as "Latest 50 Logs" and "Errors and Warnings" etc. but cannot correlate ANY entries to this call.

    QUESTION:  where do I need to look for more details?  Is there a service or property that I need to enable either on the "Server" or the individual databases? 

    Thank you in advance!

    Bill Blakey

    Tuesday, December 3, 2019 12:43 AM


All replies