MS SSMS Object reference not set to an instance of an object.
Best Answer
-
Jon_Kirkwood Posts: 423 Silver 5
Hi @ap_petko
Thank you for reaching out on the Redgate forums regarding your SQL Prompt error message.
The development team has confirmed that this is a known bug and they are currently looking into it.
I will keep this forum post monitored and advise when a fix has been released.
In the interim, it may be possible to downgrade your version to temporarily resolve this.
I have had reports from users that they were able to install v10.12.3 without error
Download link available here: https://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_10.12.3.28623.exe
Apologies for any inconvenience caused and hope to have an update in time for you with a better resolution.
Jon Kirkwood | Technical Support Engineer | Redgate Software
Answers
Hi,
Coming to advise that a fix has not yet been released and is not likely before the end of year.
In the interim I'd suggest keeping an eye on the SQL Prompt release notes page for notice of release and look forward to a fix coming in a version in the new year
https://documentation.red-gate.com/sp/release-notes-and-other-versions/sql-prompt-10-13-release-notes
Hi @ap_petko
Thank you for your patience on this issue whilst our development team worked on it.
I have received notification overnight that SQL Prompt release v10.13.4 should include a fix for this issue.
Are you able to patch at your earliest convenience and verify if this is now resolved for you.
Download link for the patch is available here:
https://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_10.13.4.32349.exe