none
Export Extended Events to Table in SSMS RRS feed

  • Question

  • Hello,

    Getting the following error while trying to export Extended Events to Table in SSMS:

    "Property DefaultSchema is not available for Database 'xxx'. This property may not exists for this object, or may

    not be retrievable due to insufficient access rights (Microsoft.SqlServer.Smo)"

    Thanks for help :)

    Monday, August 5, 2019 7:32 AM

All replies

  • Hi GaliM1,

    What is the authentication method being used to access the database via SSMS? SQL Authentication or Azure Active Directory? Are you able to login as the SQL Admin or the SQL Active Directory Admin if you are not accessing the database with one of these privileged accounts? 

    Can you also detail the SSMS version you currently have installed. 

    Download SQL Server Management Studio (SSMS) (link)

    This is likely a permissions issue but through a process of elimination, could also be an issue with SSMS.

    Regards,

    Mike

    Tuesday, August 6, 2019 12:06 AM
    Moderator