How can we help you today? How can we help you today?
HenrikM
When I say crashes SSMS I mean that SSMS becomes unresponsive and I have to kill the SSMS process..  Sometimes maybe if I wait several minutes (3+ minutes) SSMS will become responsive again. I have checked the logs and in the sqlprompt-sqlhistory*.logs found this Exception 2022-12-05 12:45:10.003 +01:00 [Information] Logging level set to 'Information' 2022-12-05 12:45:10.195 +01:00 [Information] Started successfully with identifier '*****************************' 2022-12-05 12:45:10.266 +01:00 [Error] Error processing operation System.NullReferenceException: Object reference not set to an instance of an object.    at RedGate.SqlPrompt.SqlHistory.Storage.StoreInitializer.Create()    at RedGate.SqlPrompt.SqlHistory.Storage.Commands.CommandStore.AddContentsRevision(Guid queryIdentity, String name, String path, String contents, SqlHistoryConnection connection, SaveReason saveReason)    at RedGate.SqlPrompt.SqlHistory.Server.Commands.CommandProcessor.StoreContentsRevision(RevisionMessage message)    at RedGate.SqlPrompt.SqlHistory.Server.Commands.CommandProcessor.ProcessCommand(CommandOperationType commandOperationType, ICommandMessage message)    at RedGate.SqlPrompt.SqlHistory.Server.OperationQueue.ProcessQueue(Object sender, DoWorkEventArgs e) 2022-12-05 12:45:14.020 +01:00 [Information] [Startup status] Size on disk (bytes) = 377958400, Number of queries = 46308, Number of revisions = 50798, Highest revisions per query = 102, Longest contents (characters) = 4781898 / comments
When I say crashes SSMS I mean that SSMS becomes unresponsive and I have to kill the SSMS process.. Sometimes maybe if I wait several minutes (3+ minutes) SSMS will become responsive again.I have c...
0 votes