Comments
Sort by recent activity
Hi Per, The Dev team have advised that the issue you are seeing is due to using an incorrect syntax for TRIM. The syntax for SQL Server 2022 (16.x) and earlier versions, Azure SQL Database, and Azure Synapse Analytics: TRIM ( [ characters FROM ] string )From https://learn.microsoft.com/en-us/sql/t-sql/functions/trim-transact-sql?view=azuresqldb-current the given example there is: SELECT TRIM( '.,! ' FROM ' # test .') AS Result;The syntax for SQL Server 2022 (16.x) and later versions, Azure SQL Managed Instance, and Microsoft Fabric: TRIM ( [ LEADING | TRAILING | BOTH ] [characters FROM ] string ) / comments
Hi Per,The Dev team have advised that the issue you are seeing is due to using an incorrect syntax for TRIM. The syntax for SQL Server 2022 (16.x) and earlier versions, Azure SQL Database, and Azur...
Thank you for your post. I'm afraid SQL Data Compare doesn't have a function for counting the number of rows in each of the DBs that the comparison is run on. If you'd like, though, you can post in our Uservoice forum if this is a feature you'd like to see in the future: https://redgate.uservoice.com/forums/147879-sql-data-compare / comments
Thank you for your post. I'm afraid SQL Data Compare doesn't have a function for counting the number of rows in each of the DBs that the comparison is run on. If you'd like, though, you can post in...
Hi, A fix for this is now Included in yesterday's release (13.0.44) https://documentation.red-gate.com/sm/release-notes-and-other-versions/sql-monitor-13-0-release-notes Database unavailable alert will no longer be raised for mirrored databases. / comments
Hi,A fix for this is now Included in yesterday's release (13.0.44)https://documentation.red-gate.com/sm/release-notes-and-other-versions/sql-monitor-13-0-release-notesDatabase unavailable alert wil...
Hi @alphonseg thank you for your post. In that same folder in the original machine (where you were moving the SQL History file over from) there should also be a JSON file named "sqlhistory-search" if you move that over to the other machine are you then able to search through the SQL Histroy? / comments
Hi @alphonseg thank you for your post. In that same folder in the original machine (where you were moving the SQL History file over from) there should also be a JSON file named "sqlhistory-search" ...
To share a snippets, highlight the snippets you wish to share, and press the share button above the snippets list. [image] Or, right click and select Share in the context menu for a given snippet. When you share a snippet, you will be asked which team in your organization you want to share the snippet with: [image] Once a snippet has been shared, it will take a few minutes for it to be synchronized to the Redgate Platform and be available for other team members. / comments
To share a snippets, highlight the snippets you wish to share, and press the share button above the snippets list.Or, right click and select Share in the context menu for a given snippet.When you s...
Thank you for your post. When you update a shared style or create new style are then electing to share the style via the platform? [image] When you share a formatting style, you will be asked which team in you organization you want to share the formatting style with:
[image]
Once a formatting style has been shared, it will take a few minutes for it to be synchronized to the Redgate Platform and be available for other team members. / comments
Thank you for your post. When you update a shared style or create new style are then electing to share the style via the platform? When you share a formatting style, you will be asked which team in...
Hi Dave, Thank you for your post. Copy As In Clause should remove duplicates you're right: [image] [image] [image] I am running the same version of SQL Prompt, and it appears to remove the duplicates. If you can try exporting a copy of your SQL Prompt settings (SQL Prompt>Options>Export) and then restore the options to the default. Then save and close SSMS and re-open and try the Copy As In Clause option again. Does this change the behaviour? If not, then you can restore your previous settings by importing the settings file that you previously exported. / comments
Hi Dave,Thank you for your post. Copy As In Clause should remove duplicates you're right:I am running the same version of SQL Prompt, and it appears to remove the duplicates. If you can try exporti...
I'm afraid there isn't a way to override this behaviour. / comments
I'm afraid there isn't a way to override this behaviour.
Hi Neil, Thank you for your post. For the SQL Server Agent job alert this will alert on the first time a job fails, it will not alert on subsequent failures though as this is a Continuous alert. So the alert will remain active until the job completes successfully again. If after completing successfully the job then fails, it will alert on this failure. / comments
Hi Neil,Thank you for your post. For the SQL Server Agent job alert this will alert on the first time a job fails, it will not alert on subsequent failures though as this is a Continuous alert. So ...
Hi @JGoulet89, SQL prompt supports the following Azure platforms:
Azure SQL Database
SQL Server on Azure VM
Just doing some testing on this as well, which Provider are you using for the linked server? [image] [image] [image] [image] [image] [image] [image] [image] [image] [image] [image] [image] / comments
Hi @JGoulet89,SQL prompt supports the following Azure platforms:
Azure SQL Database
SQL Server on Azure VM
Just doing some testing on this as well, which Provider are you using for the linked server?