28 results found
-
It's not possible to remove object filter in scomp document
After searching for an object, if you clear the filter, data is not displayed
10 votes -
dbForge Studio Database Documention can´t create "Depends On" or "Used By"
When dbforge Studio creates the Documention for a Database all "Depends On" and "Used By" refers are empty when the Database Name contains a "-".
6 votes -
DB Forge crashing
Probably 2-3 times a day DB Forge crashed. Quite often it does this while i'm not even using it. All I get is the windows 'dbForge Studio for SQL Server has stopped working' dialog (the one which has the Debug and Close Program buttons). This has started happening after the last update
4 votes -
Sticky "Object has invalid source text and cannot be saved"
Often, when editing functions, and I try to save something with invalid syntax, I will get a pop-up with "Object has invalid source text and cannot be saved" instead of the useful list of errors with line numbers. (However, the product still often red-underlines a problematic portion in these cases.)
That annoyance is separately reported here:
However, sometimes, after getting this once, every successive save will fail with that error, even after the problem has been resolved. Copying and pasting into SSMS will verify that it is correct. Then closing and re-opening the function editor window will allow me…
4 votesThis issue is fixed in the latest version 5.4 https://www.devart.com/dbforge/sql/studio/download.html
-
Invalid scripting for FK deleting using "IF OBJECT_ID('FK_...', 'F') IS NOT NULL" check.
Invalid scripting for FK deleting using "IF OBJECTID('FK...', 'F') IS NOT NULL" check.
There is need to use schema as part of FK name. Reason: "OBJECT_ID() function returns NULL for "non-dbo schema" FK.Bad script:
IF OBJECTID('FKFDlalala', 'F') IS NOT NULL
ALTER TABLE EE.FDlalala
DROP CONSTRAINT FKFDlalala
GOUber script:
IF OBJECTID('EE.FKFDlalala', 'F') IS NOT NULL
ALTER TABLE EE.FDlalala
DROP CONSTRAINT FKFDlalala
GO3 votesThis issue is fixed in dbForge Studio for SQL Server, v5.1 https://www.devart.com/dbforge/sql/studio/download.html
-
Copy with column names doesn't paste correctly into Excel
Do any select, copy with column names. Paste into Excel. Data pastes properly, but column names do not.
3 votes -
User-Defined Function Editing Removes Existing Permissions
if you edit a user-defined functions, any pre-existing permissions are removed. They should not be.
2 votes -
Showing the connection color in the status bar
Apologies, not sure if this is a bug or needs to be a feature. I love the identification of tabs using the shape and color of a connection. I would LOVE it if that color would also transfer to the status bar, which on my setup is always blue. Due to the status bar's visibility, I get super confused when I'm on a connection colored, say, red (production) but the status bar is blue (test).
2 votes -
buggy release
Am I the only one thinking the latest version of DB forge is still full of bugs?
2 votes -
dbForge Studio crashes after an extended period of being open ( memory leak most likely)
dbForge Studio crashes after an extended period of being open ( memory leak most likely) 5.4.275
1 vote -
Lost cursor after executing script
Lost cursor after executing script
1 vote -
Unable to fix bugs
I have reported a few bugs over the past few months, and although you are good at responding and looking into this there seems to be a few bugs that you can't seem to get right.
Upgrading. It is always painful. Links that you publish to download the upgrade don't work. There are always licencing/activation problems, etc. I upgraded yesterday as advised (having gone through the normal pain to find the right place to download), and everything seemed to work. Yet today I am asked to enter my activation key yet again. Why can't you just make the upgrade seamless?…
1 vote -
5.4.211 crashes upon schema synchronization
5.4.211 crashes upon schema synchronization
1 vote -
Mouse wheel does not scroll the Database Explorer tree list
I have a database server with many dozens of databases containing many hundreds of objects (tables, views, etc.) each. I use the mouse scroll wheel to scroll this list in MS SSMS and I would hope to be able to do this with dbForge Studio.
1 vote -
Autocomplete doesn't work if table belongs to schema and no alias or schema name used in join.
Example:
select *
from Schema1.Table1 join Schema1.Table2 on Table1.[AutoComplete doesn't show table fields]select *
from Schema1.Table1 T1 join Schema1.Table2 T2 on T1. [AutoComplete works properly]1 voteThis feature is implemented in dbForge SQL Complete, v5.6 https://www.devart.com/dbforge/sql/sqlcomplete/download.html
-
F3 button not working properly
Normally, if I do an incremental search (CTRL+I) or a normal search (CTRL+F), pressing F3 takes you to the next location of your search text in the current file. With DBForge it seems to jump all over the place. The only place it doesn't take you to is the next location in the current file, which basically makes it impossible to use.
1 votePlease try the latest version 5.4 https://www.devart.com/dbforge/sql/studio/download.htmlhttps://www.devart.com/dbforge/sql/studio/download.html
-
Skin styled images not showing in menu
If you set "Use styled images" in options, all the icons/images use this setting except for the cell edit cascade menu... as shown here:
1 vote -
Invalid error line for "Display Estimated Execution Plan"
use this script for test:
DECLARE @FILENAME AS NVARCHAR(500),
@FILENAMEPRE AS NVARCHAR(500),
@FILENAMESUF AS NVARCHAR(500),
@SQLSTMT AS NVARCHAR(MAX)SET @SQL_STMT = 'SELECT t1.*, CASE WHEN c1 IS NULL THEN ''Y'' ELSE ''N'' END AS [COLUMN1], t2.c3 FROM t1 LEFT JOIN (SELECT * FROM (VALUES (''v1'',''v1'',''v1''), (''v2','v2','v2''), (''v3'',''v3'',''v3'')) RET (c1, c2, c3)) t2 ON t1.c1 = t2.c2 '
if you press "Display Estimated Execution Plan", then the first line will be highlighted with an error: Incorrect syntax near ','.
But if you press "Execute" then correct one will be highlighted1 voteThis issue is fixed in the latest product version 5.4 https://www.devart.com/dbforge/sql/studio/download.html
-
Autosize
Last beta version does not autosize the result set (regression). You have to retrieve multiple times to get the results aligned properly.
1 voteThis issue is fixed. Please upgrade to the latest version https://www.devart.com/dbforge/sql/studio/download.html
-
Ao tentar executar consulta na primeira vez
Quando executo uma consulta pela primeira vez, após a carga da aplicação, nada é exibido. Somente após fechar uma das janelas é que consigo voltar a visualizar a saída dos resultados.
1 vote
- Don't see your idea?