Activity overview
Latest activity by myuabov
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"...
Great, thank you, David. / comments
Great, thank you, David.
PlasticSCM Integration
Just saw this at http://codicesoftware.blogspot.com/2013 ... astic.html -- does anyone know when the command line hook for PlasticSCM will be included in SQL Source Control?
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...
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
Pressing ( after FROM inserts the default candidate then (
When entering a select statement with a derived table such as
select *
from ( select * ...
as soon as you enter the left parenthesis, the default candidate is inserted then the (. I wonder if I'm ...
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
INNER JOIN ON[space] inserts the wrong candidate.
When entering a select statement formatted like this:
select *
from [Person].[Address] AS a
inner JOIN [Person].[Contact] AS c
on
the candidate list appears defaulting to the "All common objects". ...