Changing any paramaters in a NEW unsaved stored procedure, cleaars all of the SQL code section
HI ! This is for DBForge studio 2025.1.134 It did the same thing in 1.124 as well. I thought I saw this posted already. I went looking for it but could not find it. so posting it here. If you create a new stored procedure, then go to the SQL code section
DBForge MySQL - BOOL fields converted to TinyINT(1) on their own
HI ! Not sure If this is a bug or a new feature. But I just noticed that ALL of my fields that I created as Boolean types, converted themselves to TinyInt(1). Every one of them in the entire database. This is 2025.1.124. Is this supposed to happen ?
Query Builder overwrites my text and generates a query with errors?
dbForge Studio for MS SQL version 7.1.63 (Windows 11) Steps to Reproduce: 1. New Query 2. Add tables to the Query Builder 3. Give tables alias 4. Join on fields as needed 5. View text tab and qualify fields with alias (manually type them in) 6. Return
Cannot decrypt procedures on Azure SQL
I have the free Decryptor product and would like to use it on Azure SQL. Whenever I try, I get the error message "dbforge SQL encryptor DBCC command 'DBINFO' is not supported in this version of SQL Server." Is the decryptor compatible with Azure SQL.
DBForge MySQL - Linking Tables with FK shows up in random spots
HI! First time posting here, NEW User ! Whoo Hoo ! I just installed the latest of DBForge Studio for MySQL - 2025.1.124 I like the product. So far, I am very happy I noticed something though and wondering if this can be looked at and changed. When I create
Restoring Tabs After Restart Getting Worse
dbForge Studio for SQL Server 2025.1.124 seems to be noticeably worse at restoring tabs after a restart. I'm down to two sql tabs being restored from about the ten I had yesterday after a couple of restarts.
SQL Complete No Longer Shows Column List For Trigger Tables
I could've sworn SQL Complete used to show the column names for the inserted/deleted tables in the list members CREATE TRIGGER [dbo].[tu_Contact_StandingId] ON [dbo].[Contact] AFTER UPDATE AS BEGIN IF UPDATE(StandingId) BEGIN INSERT CapitaTransaction
New AI Feature in dbForge Studio for SQL Server
Good start but a bit rough when actually using it, both in terms of UX and output. My first prompt, "Explain this query", resulted in a 500 internal server error. I figured out I had to include the query with the prompt but in these cases, Studio should
SQL Complete not appearing in SSMS 20 on ARM64
Running Windows 11 ARM64 and SQL Complete installs quite happily but then does not appear in SSMS20. SQL Complete does appear and function in Visual Studio 2022.
Table Designer in dbForge Studio
When the property pane has focus in the table designer, hitting Tab should go to the next property, not the script pane.
SQL Complete - Data Viewer
Now is limited to 2033 chars, pleas extend size to 2 MB / 5 MB /Unlimited like option in Studio for query results in grid.
SSMS 21 Support
I'm starting to test SSMS 21. Is there a roadmap of when you might add support for SSMS 21?
Newer Version of SQL Complete Breaks Stream Deck Macros
Using SSMS 20.2. Stream Deck https://www.elgato.com/ca/en/s/welcome-to-stream-deck is a piece of hardware or an app that hooks up to your PC and provides extra macro keys. I have text strings assigned to some of these macro keys. Until SQL Complete v7.0.362
Computer crashes when opening SSMS
The two members of my team (including myself), who have dbForge SQL Complete installed, are having issues with our computers crashing every time we open SSMS 20.2. Since it's happening just to the two of us with dbForge, we're suspecting that it's the
This server version 17.1 is not currently supported
I installed the latest dbForge Studio for Postgres. Running on windows 10. Postgres container (latest version from last week) is running in docker desktop for windows on port 5432. When I am creating the connection, dbForge studio is able to connect and
Entity Developer issue with nullable DateOnly
I am in the process of upgrading our apps to .net 8 and EF core 8 and have also upgraded Entity Developer to the latest release. However, I am having an issue with DateOnly fields. If I mark a database field as DateOnly and nullable = true, the resulting
SSMS 19.3 no SQL Complete after installation
Hi. Yesterday I installed SqlComplete 7.0. Everything went smoothly until I saw there is no SQLComplete menu in SSMS 19.3. There was no indication of error. I tried it twice, with same result. What should i do? How do I troubleshoot this? Thanks.
Unable to use dotconnect for postgres
I recently had to get a new computer and a previous web services site that worked fine under VS 2017 does not work under VS2022 and the error is when accessing the entity I get the following exception. Keep in mind the exact same site is working in production.
Add Stored Procedure fails in DB First, unless trivial contents
Firstly, there seems to be no Support Category for Entity Developer. I hope that's not a reflection of the support for that product?? Most of the time when I attempt to add existing Stored Procedures to the model, the process fails when retrieving result
An error occurred when receiving wrapped code for the 'LOCUS.INC' object: ORA-06550: line
I get this error when I do a schema compare between 2 databases. An error occurred when receiving wrapped code for the 'LOCUS.INC' object: ORA-06550: line 13, column 37: PL/SQL: ORA-00942: table or view does not exist ORA-06550: line 13, column 7: PL/SQL:
dbForge Monitor v7.0 w/ SSMS v20.2 on Windows 11 - Microsoft.IdentityModel.Clients.ActiveDirectory error
I've installed the latest dbForge Monitor v7.0 (7.0.158) on my Workstation SSMS install. It installed with no errors and SSMS starts up and connects to a remote server with no errors. When I try to activate "Monitor / Show Monitor" I get the following
Importing data into a temporal table requires default value in PeriodEnd, PeriodStart
The PeriodEnd and PeriodStart columns in an SQL Server table are designated as "Generated Always." No default value can be provided. Because Data Pump identifies the columns on the table, a default value is required. How can I import data into a temporal
SQL Complete Execution History Search
Can the search be triggered manually instead of automatically after each keystroke? It's painful to wait for the search to complete after each keystroke before you can type in the next letter in the search term
dbForge Source Control adding extra Unicode characters
The Source Control inside dbForge has begun adding extra characters on the end of commits. How can we fix this? dbForge Studio for SQL Server Version: 6.5.16 Enterprise Azure DevOps And in Notepad:
SQL Query Causing "Execution Timeout Expired" even when connection execution timeout set to 0
I have a query I'm trying to run in dbForce for SQL Server that is causing an Execution TImeout Expired error after 30s, even though my connection settings are set to 0s. What's strange is I've had other queries that run well over that timeframe without
Issue with Schema Comparison and Synonyms
I'm schema-comparing two databases (i'm using Schema comparison from within SQL Server Studio). Database A and B exist in two different servers/instances (let's say S1 and S2). Database A has a synonym to Database C (in the same server - S1) but Database
SSMS 20.0 Support
I was trying to use SSMS 20.0 (3/19/2024), along with dbForge SQL Complete, but I can't get it to work. Can you please add support to get this to work? My workaround is to use SSMS 19.3. Thanks, Jacob
Support for Azure MFA (Azure EntraID) log in in connection manager
Hello, It looks like currently the only way to create a login using MFA in the connection managers is to create an application account in Azure AD (now EntraID) and use the ApplicationID in the connection manager. There does not appear to be an ability
Evaluating SQL Source Control - Linked server on Get Latest
Hello! I am trying to run a get latest command in the Source Control module - there's 1 stored procedure it's trying to update my local DB with that has a linked server. The linked server does not allow distributed transactions and I saw that the tool
Can't install SQL Search version 2.7.25 for SSMS version 20.0
Hi, This is the error that I get. With SSM 19.X, it's working.
SQL Server Source Control - which Git client is needed?
SQL Server Source Control - which Git client is needed? instructions state Git client for windows must be installed. We use DevOps for our Visual Studio / C# code. I was unsure exactly which Git client to install, and was skittish about changing any existing
DDL Search works on comments on views but not stored procedures
As the title states, I can search comments left in views but not in stored procedures. For example we lable all sprocs and views with "author: [INSERT NAME HERE]", yet a search for author only returns the views and not stored procedures.
BiDirectionalSync
we are using two databases in which one is source database (central database) and the other is destination database (store database). And we are preforming bidirectional sync between central and store database, the problem occurred where the data existed
Issue when comparing temporal table dbForge Schema Compare
Hello, I encounter an issue while comparing GIT branch VS SQL Server database especially with temporal table alter on dbForge Schema Compare while "Synchronize" action. I unchecked both "Ignore history table" and "Ignore history table name" options and
Minor visual issue in data comparison
Data comparison, Mapping tab. Pressing ... on a table which has a comparison key, opens the mapping window. In there, see the problem portrayed in the image attached to this post.
Source Control Conflicts - Grants added on end
Hello, When running source control some tables, procedures etc. are flagged as conflicting. Clicking get local/remote does nothing as they seem to come back on refresh. The conflict seems to be grant permissions being added on my local database (automatically)
Need help using Transaction Log tool with a TDE encrypted MSSQL server.
I've purchased dbForge Transaction Log. Our production database uses TDE for encryption. I cannot open the logs for either the online or offline DBs. I believe this is normal behavior because the DB is TDE encrypted. I tried to get around this by creating
Source controle for git doesn't detect git folder
The folder has been clonned with visual studio with this result: When we set the folder in source controle he doesn't detect the git.
SQL Complete with large databases
Any tips for tuning SQL Complete with large databases? I work with ~100 similar databases across multiple servers. Each database has ~65k tables, ~100k stored procedures, 15k functions etc. I've read that SQL Complete shouldn't cause SSMS to freeze -
Unable to uninstall. Error that SSMS is open, but it is not.
Hi, I'm unable to uninstall. I have restarted the PC, so nothing was running.
Next Page