Comments
Sort by recent activity
I have the same issue. Tab History was the most used feature. Now it is missing. And it looks like, there is some "history" instead of. But this "History" can't be used as well as the "Tab History" before. It is all more cumbersome. And a big problem is: I can't find how to rename the queries. Before (in Tab history) I used favorites, they got names. And that way I could organize the scripts. Now there is no more way to rename, at least not through the GUI. How to work with it, if there is now "SQLQuery4.sql", "SQLQuery5.sql" etc.? Or do I now have to save a query under a specific name first, so that it gets a proper name? But then you can also use the built-in functionality of SSMS to save and open scripts. Where is the added value then? So please, if no "Tab History", then please provide the whole functionality again. / comments
I have the same issue. Tab History was the most used feature. Now it is missing. And it looks like, there is some "history" instead of.But this "History" can't be used as well as the "Tab History" ...
I have a similar issue (maybe it is the same): When I open SSMS, then the tabs from the last session are restored 3 times. I must delete all these duplicates. But I get this error every time. I get this only after upgrading to 10.10.2 / comments
I have a similar issue (maybe it is the same): When I open SSMS, then the tabs from the last session are restored 3 times. I must delete all these duplicates. But I get this error every time. I get...
often I have the same issue. Would be fine to fix it. / comments
often I have the same issue. Would be fine to fix it.
and I miss the workaround mentioned here in the https://documentation.red-gate.com/ss3/troubleshooting workaround instructions can be found only here in the forum. / comments
and I miss the workaround mentioned here in the https://documentation.red-gate.com/ss3/troubleshootingworkaround instructions can be found only here in the forum.
@ostandage I am using the latest versions 10.6.6. 0.2.6 but as I explained the files are different. SSMS configuration file contains one more entry on top which is missing in the ADS version: ```json "metadata": { "id": "de9438b0-12d2-4ff9-9cce-c0e23dd1001f", "name": "aisberg" }, ``` And it looks like this block is required by the SSMS version and the VS version. That's why I created this feature request. As I described: If I (or you) copy the config file from ADS app, not containing this part, in the SSMS config folder and add the extension `.json` to this file then this causes errors in SSMS SQL Prompt and VS SQL Prompt. I think the SSMS and VS versions are parsing these files and looking for this specific content. I tried several things, deinstalled and reinstalled SQL Prompt, before I found that the existence of this "invalid for SSMS SQL Prompt" configuration file causes the error. You should be able to reproduce the issue. Maybe it could be also a good idea to create a bug for SSMS SQL Prompt based on my description. Germo / comments
@ostandage I am using the latest versions 10.6.6. 0.2.6but as I explained the files are different. SSMS configuration file contains one more entry on top which is missing in the ADS version:```json...
the post is not shown as in the editor, I try again:
"dml": {
"clauses": {},
"listItems": {},
"addNewLineAfterDistinctAndTopClauses": true,
"collapseStatementsShorterThan": 75,
"collapseShortSubqueries": true,
"collapseSubqueriesShorterThan": 75,
"listItems": {
"placeGroupByAndOrderByOnNewLine": "always",
"placeFromTableOnNewLine": "always",
"placeWhereConditionOnNewLine": "always"
}
},
Select
Object1.[RepoObject_fullname] As ReferencingObjectName
, Object1.[RepoObject_type]
, Object2.[RepoObject_fullname] As ReferencedObjectName
, Object2.[RepoObject_type]
--, Object1.[RepoObject_guid]
--, Object2.[RepoObject_guid]
From
[graph].[RepoObject] As Object1
, [graph].[ReferencedObject] As referenced
, [graph].[RepoObject] As Object2
Where MATCH(
Object1-(referenced)->Object2)
And Object1.[RepoObject_type] In ( 'u', 'v' )
And Object2.[RepoObject_type] In ( 'u', 'v' )
Order By
Object1.[RepoObject_fullname]
, Object2.[RepoObject_fullname]
/ comments
the post is not shown as in the editor, I try again:
"dml": {
"clauses": {},
"listItems": {},
"addNewLineAfterDistinctAndTopClauses": true,
"collapseStatementsShorterThan": 75,
...
@AdrianB Thank you! This is exactly, what I was searching for. Could you consider adding this hint in the documentation of the extension? Then other users also would be able to easy find it. / comments
@AdrianB Thank you! This is exactly, what I was searching for.Could you consider adding this hint in the documentation of the extension? Then other users also would be able to easy find it.
I still from time to time try to use the sql-prompt formatting. But normally I give up. Because it is very hard to change the configuration if there is no GUI like in SSMS. I can't use SQL Prompt in SSMS because I have no license. Could you consider publishing the complete list of all possible settings for formatting? If a user can see, what is possible, then it will be much easier to find the possible settings. For now, I switched back to Poor Mens formatter, because it is free and is available in SSMS and in VSC. But I am not really happy with the result. It would be fine to use the same free formatter in VSC, ADS and SSMS and to be able to configure it a bit. Especially, when working in a team in an open source project, then there should be some free formatting options. / comments
I still from time to time try to use the sql-prompt formatting. But normally I give up. Because it is very hard to change the configuration if there is no GUI like in SSMS. I can't use SQL Prompt i...
@ostandage I found the link in the first topic of this forum here. I see it is a very new version. And it is easier now to see possible values using the path on the top. Of course, it would be easier to use the formatting settings dialogs of the plugin in SSMS. I know reg-gate plugins from some projects in the past where I was allowed to use red-gate software. Many years ago I even got a T-shirt "friends of red-gate" and I got a developer license to be able to use and to promote. But it is often hard to promote tools because there is one budget and process for consulting and another process for software. Often software needs to be "listed" to be allowed. So the only chance for me to use red-gate software was when the company will buy these tools for all developers. In most other projects I need to use what they have, for example the features in SSDT. ADS can be installed per user, without admin rights, and that's why it is easy to use in any project. And I am looking for methods to be used in projects where I don't get admin rights. Would be fine to get free refactoring also in ADS, with SQL-Prompt. Currently, the free ways are SSDT or the old standalone APEXSql Refactor. / comments
@ostandage I found the link in the first topic of this forum here. I see it is a very new version. And it is easier now to see possible values using the path on the top.Of course, it would be easie...
@ostandage OK, I got it. I need to place the Cursor between the ":" and the current value, then on CTRL-SPACE I get a full list. This works. My ADS Version of SQL Prompt is 0.2.4 ADS is showing me that this is the current version. And there is no download link in the readme file or in ADS. Normally I get the download link only when I get a notification in ADS about a new version. Maybe you could add the download link in the readme file? It is hard to find the right web link of the plugin because ADS has a restricting encapsulation to avoid users to move to the original resource site using a normal browser. I don't use SQL Prompt in SSMS because it is not free. I used the free APEX SQL tools for many years instead of red gate non-free tools. But now Apex stopped to deliver freeware. That's why now I have a look on red gate products again. / comments
@ostandage OK, I got it. I need to place the Cursor between the ":" and the current value, then on CTRL-SPACE I get a full list. This works.My ADS Version of SQL Prompt is 0.2.4ADS is showing me th...