How can we help you today? How can we help you today?
Fadi
Activity overview Badges (0) Posts (2) Comments (6)

Activity overview

Latest activity by Fadi

Thanks Dan / comments
  1. Community
  2. SQL Compare
  3. SSMS Integration Pack Crashing
Thanks Dan
0 votes
Hello Dan, I'm using version 19.1.56.0 of SSMS, and version 15.0.9.23488 of SQL & Data Compare. Error occurs within SSMS natively, while using the SSMS Integration Pack to compare schema of an existing DB as a source, Once I click on Compare/Deploy with SQL Compare button, I am prompted with the error and SSMS crashes as soon as I close the error message. [image] [image] [image] / comments
  1. Community
  2. SQL Compare
  3. SSMS Integration Pack Crashing
Hello Dan,I'm using version 19.1.56.0 of SSMS, and version 15.0.9.23488 of SQL & Data Compare.Error occurs within SSMS natively, while using the SSMS Integration Pack to compare schema of an existi...
0 votes
SSMS Integration Pack Crashing
  1. Community
  2. SQL Compare
Hello,I'm receiving the following error when I'm using the Schema Compare/Deploy functionality on a database:Please advise,Thanks,
2 followers 4 comments 0 votes
Jon_Kirkwood said: Thank you for your patience whilst our development team investigated this error. Unfortunately it is not something we are able to resolve as this error is being generated from the Microsoft SQL Parser and not code that we control.  Apologies we are unable to bring better news at this point, however this may be resolved through an update via Microsoft which would then be picked up by SQL Prompt in a future release. Hello Jon, Thanks for reaching back.  Out of curiosity, is the MS SQL Parser functionality independent of the Parse command SSMS uses? [image] [image] [image] [image] / comments
  1. Community
  2. SQL Prompt
  3. SQL Format throws error when code includes statistics updates with MAXDOP
Jon_Kirkwood said: Thank you for your patience whilst our development team investigated this error. Unfortunately it is not something we are able to resolve as this error is being generated ...
0 votes
Dan_J said: Hi @Fadi Thanks for reaching out to us regarding this. I am also seeing the same error when attempting to format that code, I will raise this with our development team and come back to you as soon as I have an update for you. Thanks Dan. Looking forwards to the fix. Fadi. / comments
  1. Community
  2. SQL Prompt
  3. SQL Format throws error when code includes statistics updates with MAXDOP
Dan_J said: Hi @Fadi Thanks for reaching out to us regarding this.I am also seeing the same error when attempting to format that code, I will raise this with our development team and come bac...
0 votes
SQL Format throws error when code includes statistics updates with MAXDOP
  1. Community
  2. SQL Prompt
The following code raises an error when I try to run Format SQLUPDATE STATISTICS #table WITH MAXDOP = 1; The error is:
3 followers 5 comments 0 votes
Hi dkim, There's no folder with that name under GAC_MSIL. / comments
  1. Community
  2. SQL Prompt
  3. "The given key was not present in the dictionary." Error
Hi dkim,There's no folder with that name under GAC_MSIL.
0 votes
Thank you for reaching out, Victoria. Below is the log associated with the error: 2022-01-03 10:21:28.045 -05:00 [Error] Report error dialog UI shown System.Collections.Generic.KeyNotFoundException: The given key was not present in the dictionary. at System.Collections.Generic.Dictionary`2.get_Item(TKey key) at RedGate.SqlPrompt.TabHistory.Monitoring.OpenDocuments.GetOpenDocument(IDocumentWrapper document) at RedGate.SqlPrompt.TabHistory.Monitoring.TabWatcher.StoreDocument(IDocumentWrapper document, SaveReason saveReason) at RedGate.SqlPrompt.TabHistory.Monitoring.TabWatcher.<OnQueryExecuted>b__34_0() at RedGate.SQLPrompt.UsageReporting.ErrorReporting.ErrorReporterWithUI.Do(Action action) 2022-01-03 10:21:30.157 -05:00 [Error] Report error dialog UI shown System.Collections.Generic.KeyNotFoundException: The given key was not present in the dictionary. at System.Collections.Generic.Dictionary`2.get_Item(TKey key) at RedGate.SqlPrompt.TabHistory.Monitoring.OpenDocuments.GetOpenDocument(IDocumentWrapper document) at RedGate.SqlPrompt.TabHistory.Monitoring.TabWatcher.StoreDocument(IDocumentWrapper document, SaveReason saveReason) at RedGate.SqlPrompt.TabHistory.Monitoring.TabWatcher.<OnQueryExecuted>b__34_0() at RedGate.SQLPrompt.UsageReporting.ErrorReporting.ErrorReporterWithUI.Do(Action action) 2022-01-03 10:21:30.983 -05:00 [Error] Report error dialog UI shown System.Collections.Generic.KeyNotFoundException: The given key was not present in the dictionary. at System.Collections.Generic.Dictionary`2.get_Item(TKey key) at RedGate.SqlPrompt.TabHistory.Monitoring.OpenDocuments.GetOpenDocument(IDocumentWrapper document) at RedGate.SqlPrompt.TabHistory.Monitoring.TabWatcher.StoreDocument(IDocumentWrapper document, SaveReason saveReason) at RedGate.SqlPrompt.TabHistory.Monitoring.TabWatcher.<OnQueryExecuted>b__34_0() at RedGate.SQLPrompt.UsageReporting.ErrorReporting.ErrorReporterWithUI.Do(Action action) 2022-01-03 10:21:31.861 -05:00 [Error] Report error dialog UI shown System.Collections.Generic.KeyNotFoundException: The given key was not present in the dictionary. at System.Collections.Generic.Dictionary`2.get_Item(TKey key) at RedGate.SqlPrompt.TabHistory.Monitoring.OpenDocuments.GetOpenDocument(IDocumentWrapper document) at RedGate.SqlPrompt.TabHistory.Monitoring.TabWatcher.StoreDocument(IDocumentWrapper document, SaveReason saveReason) at RedGate.SqlPrompt.TabHistory.Monitoring.TabWatcher.<OnQueryExecuted>b__34_0() at RedGate.SQLPrompt.UsageReporting.ErrorReporting.ErrorReporterWithUI.Do(Action action) / comments
  1. Community
  2. SQL Prompt
  3. "The given key was not present in the dictionary." Error
Thank you for reaching out, Victoria. Below is the log associated with the error:2022-01-03 10:21:28.045 -05:00 [Error] Report error dialog UI shown System.Collections.Generic.KeyNotFoundException:...
0 votes
Total activity
11
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
3