Comments
Sort by recent activity
Hey @Digga
Great news! I'm very pleased to hear it!
Thank you for your patience with us on this!
/ comments
Hey @Digga
Great news! I'm very pleased to hear it!
Thank you for your patience with us on this!
Hi @Digga
I'm pleased to advise that a fix for this will be included in the next release of SQL Prompt, which is likely to be at some point next week.
I will update you again as soon as I am made aware the release is available for you to download. Thank you for your patience with us on this!
/ comments
Hi @Digga
I'm pleased to advise that a fix for this will be included in the next release of SQL Prompt, which is likely to be at some point next week.
I will update you again as soon as I am made...
Hey @Digga
Thanks!
Have you had a chance to test this following the update?
/ comments
Hey @Digga
Thanks!
Have you had a chance to test this following the update?
Hey @Digga
We have finally been able to reproduce the issue you are seeing here!
Our development team will be working on a fix for this bug, I will update this thread as soon as I have an update for you on this. Thank you for highlighting this to us.
/ comments
Hey @Digga
We have finally been able to reproduce the issue you are seeing here!
Our development team will be working on a fix for this bug, I will update this thread as soon as I have an update ...
Thanks @Digga, you have a great weekend too! / comments
Thanks @Digga, you have a great weekend too!
Hey @Digga
Thank you for your update on this, and for providing the script you are using. Reading what you have mentioned about using an IDENTITY column over Azure suggests that these things combined are what is causing suggestions to not appear. Is that correct? I will be attempting to replicate this issue again later today and will let you know that outcome as soon as possible.
/ comments
Hey @Digga
Thank you for your update on this, and for providing the script you are using.Reading what you have mentioned about using an IDENTITY column over Azure suggests that these things combin...
Hi there @Digga
My apology for the delay in replying to you.
I have been speaking with my colleagues regarding this. We have tried again to reproduce the issue you are seeing but have so far been unsuccessful.
Just going back to the first images you provided, there is a difference in the Nullability of the CRMEntity_Id column which is making us question whether it is looking at two different tables (although it doesn't suggest this when looking at the rest of the screenshots you provided): [image]
[image]
I order to help us with our attempts to reproduce this, would it be possible to get a copy of your script used for the above example?
/ comments
Hi there @Digga
My apology for the delay in replying to you.
I have been speaking with my colleagues regarding this. We have tried again to reproduce the issue you are seeing but have so far been ...
Hi @Digga
My sincerest apology for not responding to you on this before now. I am sorry that this issue continues for you, I'd really like to try and find a solution for you on this!
I think just a couple of things to get my troubleshooting moved forward on this: As
mentioned before, this clearly appears to be Azure related, however please
can you just confirm that the Connection settings within the SQL Prompt
Options are set to load suggestions for all databases and schemas and linked servers (see below)?
[image] Also, if you haven't already, please can you update to the very latest version of SQL Prompt (v.10.6.12). This version can be downloaded directly from here: https://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_10.6.12.20269.exe
If you can please let me know if either this issue persists or not after trying the above, please don't hesitate in coming back to me so that I can further advise.
Again, my sincere apology for the lack of update on this!
/ comments
Hi @Digga
My sincerest apology for not responding to you on this before now.I am sorry that this issue continues for you, I'd really like to try and find a solution for you on this!
I think just ...
Hi @Digga Sorry to hear you're experiencing this issue, thanks for reaching out to us on this. The very latest version of SQL Prompt (v10.6.1) contains fixes for Azure related issues. As a first step, please can you update to this version, which can be downloaded here: https://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_10.6.1.17779.exe
Please let me know this does or does not resolve this issue for you.
/ comments
Hi @Digga Sorry to hear you're experiencing this issue, thanks for reaching out to us on this.The very latest version of SQL Prompt (v10.6.1) contains fixes for Azure related issues. As a first ste...
Hi @Digga
Thanks for your response on this! My apology for the delay in getting back to you! I'm sorry to hear that these issues continue in the latest version of SQL Prompt!
I think the next thing to try would be update SSMS, I see you are currently using v 17.9, would you be happy to update to the latest version (v 18.8)? If so, this can be downloaded here: https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver15
In the meantime, I will pose your query to my colleagues for discussion and will update you again shortly.
/ comments
Hi @Digga
Thanks for your response on this! My apology for the delay in getting back to you!I'm sorry to hear that these issues continue in the latest version of SQL Prompt!
I think the next thin...