Comments
Sort by recent activity
RichardL said:
Hi @myuabov Thanks for your post. This looks like something a support engineer should look at for you so please send us a ticket if you have a support contract on your serial key. Don't forget to include the sample script please if possible. Kind regards Richard Lynch.
I believe this issue has been resolved in Version 9.1.15.5260. Thank you! / comments
RichardL said:
Hi @myuabov Thanks for your post. This looks like something a support engineer should look at for you so please send us a ticket if you have a support contract on your serial k...
Thanks, Richard -- I've submitted a support request. / comments
Thanks, Richard -- I've submitted a support request.
Hello, I've just installed the SQL Prompt 9 Version 9.1.13.5130 update and I'm getting an error message trying to Format SQL (Ctrl+K, Ctrl+Y): "Object reference not set to an instance of an object". I'm attaching a screenshot below. [image] I've tried restarting SSMS then the PC and that didn't help. The debug log has the following errors: <div>29 May 2018 21:23:13,415 [1] INFO RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver - Runtime failed to load assembly RedGate.SQLPrompt.CommonControls.resources, Version=9.1.13.5130, Culture=en-US, PublicKeyToken=7f465a1c156d4d57, let's have a go</div><div>29 May 2018 21:23:13,417 [1] INFO RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver - Failed to load assembly RedGate.SQLPrompt.CommonControls.resources, Version=9.1.13.5130, Culture=en-US, PublicKeyToken=7f465a1c156d4d57 from C:\Program Files (x86)\Red Gate\SQL Source Control 6\RedGate.SQLPrompt.CommonControls.resources.dll</div><div><br><div>29 May 2018 21:23:13,548 [1] ERROR RedGate.SQLPrompt.CommonUI.Refactor.RefactoringErrorReporter - Refactoring/Analysis failed</div><div>System.NullReferenceException: Object reference not set to an instance of an object.</div></div><div></div> The previous version worked fine. Any suggestions? Thanks, Mark / comments
Hello, I've just installed the SQL Prompt 9 Version 9.1.13.5130 update and I'm getting an error message trying to Format SQL (Ctrl+K, Ctrl+Y): "Object reference not set to an instance of an object"...
sph
sp_help
spt
sp_helptext
w2
sp_who2+^{LEFT}{F5}
Mark / comments
sph
sp_help
spt
sp_helptext
w2
sp_who2+^{LEFT}{F5}
Mark
I concur -- once you've typed in the alias and pressed ".", you should see only the columns from the aliased table.
Mark / comments
I concur -- once you've typed in the alias and pressed ".", you should see only the columns from the aliased table.
Mark
Great, thank you, David. / comments
Great, thank you, David.
I have also observed that some objects are reported as having differences when they are identical. I ran the following tests:
1. Compare Live DB1 with Live DB2:
29 objects exist in both but are different
313 only in DB1
314 only in DB2
159 are identical
2. Create a snapshot of DB2
3. Compare Live DB1 with the Snapshot of DB2
Expected results: should be identical to step 1
Actual results:
104 objects exist in both but are different
313 only in DB1
314 only in DB2
84 identical
4. Compare Live DB2 with the Snapshot of DB2
Expected results:
502 identical
Actual results:
417 objects exist in both but are different
85 identical
5. Compare the Snapshot of DB2 with itself.
Actual and Expected results:
502 identical
--Mark / comments
I have also observed that some objects are reported as having differences when they are identical. I ran the following tests:
1. Compare Live DB1 with Live DB2:
29 objects exist in both but are di...