Activity overview
Latest activity by HenrikM
Same issue here VS2022 and using v10.15.1 / comments
Same issue hereVS2022 and using v10.15.1
Getting SQL Prompt to work in SSMS 19.1
Hi,have just installed SSMS 19.1 along side SSMS 18 on a RDP server with multiple users.SQL Prompt does not work/appear in SSMS 19.1. Have tried to do a repair as suggested in another post, that di...
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...
new feature SQL History is more or less useless
Hi,I am the only one, who has a bad experience using the new feature SQL History in SQL Prompt in SSMS.1. Opening SQL History takes 1-2 minutes and SSMS is completely frozen while opening the SQL H...
btw our server Collation is : Danish_Norwegian_CI_AS / comments
btw our server Collation is : Danish_Norwegian_CI_AS
Hi, no i do not have any other extensions installed on SSMS...
i am using SSMS through RDP, do not know if that can have an effect? / comments
Hi, no i do not have any other extensions installed on SSMS...
i am using SSMS through RDP, do not know if that can have an effect?
Hi Frederico,
i have sent you an email with information you requested
Regards
Henrik / comments
Hi Frederico,
i have sent you an email with information you requested
Regards
Henrik