Unable to view SQL Audit logs RRS feed

  • Question

  • Dear Partner,

    We have SQL Server and Unable to view SQL Audit logs ?

    We unable to see Application, Security, etc. under Windows NT.

    I got Error with following,

    The given key was not present in the dictionary. (mscorlib)

    Program Location:

       at System.Collections.Generic.Dictionary`2.get_Item(TKey key)
       at Microsoft.SqlServer.Management.SqlManagerUI.LogMemoryStorage.AddRowNumberToSourceIndex(Int32 rowNumber)
       at Microsoft.SqlServer.Management.SqlManagerUI.LogMemoryStorage.InitializeStorage()
       at Microsoft.SqlServer.Management.SqlManagerUI.LogMemoryStorage.Initialize()
       at Microsoft.SqlServer.Management.SqlManagerUI.LogAggregator.DelegateAggregationWorkImplementation(ILogDataStorage storage)



    Tuesday, October 17, 2017 6:46 AM

All replies

  • I've had this. One thing you can test is that you connected Object Explorer with the master database. How you do it depends on how you connect Object Explorer. Another thing is of course to make sure that you run a current version of SSMS (17.3 is the most recent version).

    Tibor Karaszi, SQL Server MVP (Web Blog)

    Tuesday, October 17, 2017 7:09 AM
  • Hello, do you resolve this issue? please let me know

    Luchero The one

    Friday, August 3, 2018 4:06 PM
  • Did you make sure that master is current database for Object Explorer (as per my other post in this thread)?

    Tibor Karaszi, SQL Server MVP (Web Blog)

    Sunday, August 5, 2018 5:57 PM