Activity overview
Latest activity by aisberg
How to downgrade to the latest version, containing "Tab history"?
What is the last version where "Tab history" was available, and how can we downgrade?The "History" is immature and not yet suitable for daily work. There are too many missing features, compared to ...
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" ...
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.
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.
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...
@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...
request - improve sharing of formatting files between ADS SQL Prompt and the "normal" SQL Prompt
I tried to use the same formatting in ADS and in SSMS. But the file locations, file extensions and content are different.
SSMS config file has the extension .json and the first entry is "metadata"
...
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,
...
issue - placeWhereConditionOnNewLine doesn't work with "WHERE Match" (graph tables)
missing line break between Where and MATCHformatted sql
<div>Select</div><div> Object1.[RepoObject_fullname] As ReferencingObjectName</div><div> , ...
@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.