Comments
Sort by recent activity
Hi @mweis, Would you be able to screenshot the right click context menu for me when you click on a server? I have tried to replicate this on my machine by setting colours and upgrading to 10.8.4.24201, but my right click menu remains. You could try removing and re-adding one of the colours from the options menu to see if gets it to show back in the right click menu? You could also try updating to the latest version of prompt to see if this fixes it for you? https://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_10.9.2.25020.exe / comments
Hi @mweis,Would you be able to screenshot the right click context menu for me when you click on a server? I have tried to replicate this on my machine by setting colours and upgrading to 10.8.4.242...
Hi @jstretto, Unfortunately, it's not possible to be able to pull this information directly out of the database. The Top 10/25/50 queries can only be viewed from the Overviews section in SQL Monitor, with their query plans as well. The query plans themselves can be queried, which is just done through the sys.dm_exec_query_plan table. Apologies for the inconvenience. / comments
Hi @jstretto,Unfortunately, it's not possible to be able to pull this information directly out of the database. The Top 10/25/50 queries can only be viewed from the Overviews section in SQL Monitor...
Hi MarcoPes, Could I ask you to try the installation from within ADS?
Open ADS
Click the "Extensions" tab
Click the "..." button
Select "Install from .VSIX"
Select the SQL Prompt extension from wherever it's saved on your machine
/ comments
Hi MarcoPes,Could I ask you to try the installation from within ADS?
Open ADS
Click the "Extensions" tab
Click the "..." button
Select "Install from .VSIX"
Select the SQL Prompt extension from wher...
Hi all, This issue can be resolved via checking the log files of SCA (Click here for a link to the documentation page about logs) and finding the culprits that are causing the build process to break. In the above example, there were a couple of instances that the process had failed on. One was a credential issue with the username and password inside of the SCA build. The second issue was related to a stored procedure that had some invalid columns in it. These issues will usually be outlined within the log files, so it is suggested to consult these to find what may be the cause of the problem. After these issues were resolved, the build process went through. / comments
Hi all,This issue can be resolved via checking the log files of SCA (Click here for a link to the documentation page about logs) and finding the culprits that are causing the build process to break...
Hi @KatMakes With regards to the constant refreshing, is it possible you have the following feature enabled? This is under the SQL Prompt Options > Experimental Features: [image] [image] If yes, can you try disabling this to see if this fixes your issue? / comments
Hi @KatMakes With regards to the constant refreshing, is it possible you have the following feature enabled? This is under the SQL Prompt Options > Experimental Features:If yes, can you try disabli...
Hi @Cho Could you try the following to see if this works for you: sqldatacompare /Server1:<server name> /Database1:<database name> /Scripts2:<path to scripts folder> /Synchronize / comments
Hi @Cho Could you try the following to see if this works for you:sqldatacompare /Server1:<server name> /Database1:<database name> /Scripts2:<path to scripts folder> /Synchronize
Hi Cho, Instead of the /makescripts option, you'll actually need to use the /scriptfile option instead. I have pasted below a simple amendment of your command which shows how the /scriptfile option is to be used. You'll notice it's not much different from the /makescripts option. Using this should resolve your issue. > .\sqldatacompare /Server1:MyServer01 /Database1:MyDatabase /Database2:MyDatabase2 /scriptfile:"\\MyServer01\My_SQL_Compare_Backup\MyDatabase_20211021\script.sql" Below is the explanation on this option which can be found through the following command: sqlcompare /help /verbose. /scriptfile:<scriptfile> Alias: /sf Writes SQL change migration script to specified file. This option allows you to generate an SQL script to migrate the changes which can be executed at a later time. If the file already exists an error will occur, unless you have also used the /force switch. Also, a helpful tip that I use: You can output the help list to HTML by using this: sqlcompare /help /verbose /html /out:C:\help.html I find it makes it far easier to read and to search. / comments
Hi Cho,Instead of the /makescripts option, you'll actually need to use the /scriptfile option instead. I have pasted below a simple amendment of your command which shows how the /scriptfile option ...
Hi @cgrissomatTFL This can be done after running a comparison between two databases in SQL Compare and by clicking the filters button located at the top. After clicking filters, you can scroll to the table filter, click the pencil icon next to it. This will open a "Edit filter rules" popup menu which you can enter your filter into. [image] [image] Regarding SQL Data Compare, there is no similar feature to be able to filter based on the table. The most you are able to do is type t_ in the search bar located at the top right, which does a blanket search of your tables/views to only include ones that have t_ in the name. Keep in mind this is more of a wildcard search, so it doesn't just look at the start of the name. [image] / comments
Hi @cgrissomatTFL This can be done after running a comparison between two databases in SQL Compare and by clicking the filters button located at the top. After clicking filters, you can scroll to t...
Hi there, With regards to your blocked issue, I have managed to replicate this on my machine. From what I can see, when you have a transaction running on the DB for the ALTER TABLE ALTER COLUMN statement, SQL Compare hangs and stops functioning due to the lock on the table. Until the lock is cleared, SQL Compare will not finish whatever it's trying to do (in my testing I was just trying to compare my two databases) and will not produce any logs related to the hanging as it hasn't actually produced any errors. I did do some testing around your link where it doesn't like the OBJECTPROPERTY() function, which you are correct on, but, various other portions of the query are also having issues running due to the lock. Specifically the 'definition' column in the sys.sql_modules table. It hangs when this is queried. As this issue is related to the table lock, there isn't anything else that can be done apart from clearing the lock to let SQL Compare function normally. / comments
Hi there,With regards to your blocked issue, I have managed to replicate this on my machine. From what I can see, when you have a transaction running on the DB for the ALTER TABLE ALTER COLUMN stat...