Activity overview
Latest activity by Harry Frankish
Hi krshort
Unfortunately there's currently no way for SQL Compare to include new objects while excluding existing objects. Please could you add your idea to our UserVoice so others can vote for it? We use UserVoice to help us decide what to work on next.
A possible workaround would be to deploy the 2017 boundaries to your development database (linked to source control) and commit them so your dates in source control are in sync with production.
Many thanks
Harry / comments
Hi krshort
Unfortunately there's currently no way for SQL Compare to include new objects while excluding existing objects. Please could you add your idea to our UserVoice so others can vote for it?...
Hi RileyM
Thanks for the suggestion. I wonder if SQL Compare's new Summary view might help as it will only show you what has changed on the database rather than a textual difference in the create script. You can read more about the Summary view here: https://forum.red-gate.com/discussion/81060/beta-feature-for-sql-compare-summary-view
Please let us know if this helps.
Many thanks
Harry / comments
Hi RileyM
Thanks for the suggestion. I wonder if SQL Compare's new Summary view might help as it will only show you what has changed on the database rather than a textual difference in the create s...
Beta feature for SQL Compare - Summary view
The latest frequent update of SQL Compare (12.4.0.4551) adds the Summary view – a new way to visualize the differences between database objects:
Unlike the SQL view, which displays the whole creati...
Hi Rae
In this build SQL Prompt doesn't qualify columns which are ambiguous. This will stop SQL Prompt adding the 'el' alias to 'ProductID' in the IN() statement from your example.
Please let us know if it fixes it for you or if you find any other issues.
Cheers
Harry / comments
Hi Rae
In this build SQL Prompt doesn't qualify columns which are ambiguous. This will stop SQL Prompt adding the 'el' alias to 'ProductID' in the IN() statement from your example.
Please let us kn...
HI pmagid
Are you using the new formatting styles? You can turn these on by selecting "SQL Prompt > Options... > Labs > Experimental Features > Use new formatting styles"
The default style there formats your example with ELSE IF on the same line:
IF 1 = 1
PRINT 'HELLO';
ELSE IF 2 = 1
PRINT 'Good Bye';
Cheers
Harry / comments
HI pmagid
Are you using the new formatting styles? You can turn these on by selecting "SQL Prompt > Options... > Labs > Experimental Features > Use new formatting styles"
The default style there fo...
Hi Willem
I haven't been able to reproduce this issue on my machine .Please could you can send your options file to sqlpromptteam@red-gate.com? It'll hopefully help us find the problem. The file is in "C:\Users\<user>\AppData\Local\Red Gate\SQL Prompt 7".
Cheers
Harry / comments
Hi Willem
I haven't been able to reproduce this issue on my machine .Please could you can send your options file to sqlpromptteam@red-gate.com? It'll hopefully help us find the problem. The file i...
Hi Bryan
I think this is now fixed in this build: http://download.red-gate.com/EAP/SQLPrompt/SQLPrompt_7.5.0.942.exe
As it's essential syntax, columns in an UPDATETEXT statement should now always be qualified with the table name regardless of your settings.
Please let us know if you have any further problems.
Cheers
Harry / comments
Hi Bryan
I think this is now fixed in this build: http://download.red-gate.com/EAP/SQLPrompt/SQLPrompt_7.5.0.942.exe
As it's essential syntax, columns in an UPDATETEXT statement should now always b...
Hi Bryan
Thanks for reporting this. I've reproduced the issue here and will try to get a fix to you as soon as possible.
Until then there are 2 possible ways to prevent SQL Prompt removing the table name:
1 - In "SQL Prompt > Options... > Inserted code > Qualification" select the "Qualify column names with table name" checkbox.
Or
2 - In "SQL Prompt > Options... > Format > Actions" deselect the "Qualify object names" checkbox
Thanks again!
Harry / comments
Hi Bryan
Thanks for reporting this. I've reproduced the issue here and will try to get a fix to you as soon as possible.
Until then there are 2 possible ways to prevent SQL Prompt removing the tabl...
Hi adambean
That's strange. The TextMgrP.dll should be installed with SSMS 2016 and VS 2015. If repairing SSMS and VS doesn't work, try installing SQL Server Data Tools for VS 2015: https://msdn.microsoft.com/en-us/mt186501.aspx - this is how the dll gets installed for VS 2017. Hopefully that'll resolve the issue.
Cheers
Harry / comments
Hi adambean
That's strange. The TextMgrP.dll should be installed with SSMS 2016 and VS 2015. If repairing SSMS and VS doesn't work, try installing SQL Server Data Tools for VS 2015: https://msdn.mi...
Hi kjmcsd
Did this appear in the Visual Studio 2015 Gallery? SQL Prompt Core is only for Visual Studio 2017 Enterprise and shouldn't have appeared in 2015.
You can update SQL Prompt via SQL Prompt > Help > Check for updates or by downloading the latest version from our website: http://www.red-gate.com/products/sql-de ... ql-prompt/
Cheers
Harry / comments
Hi kjmcsd
Did this appear in the Visual Studio 2015 Gallery? SQL Prompt Core is only for Visual Studio 2017 Enterprise and shouldn't have appeared in 2015.
You can update SQL Prompt via SQL Prompt ...