Best Of
Re: Extension not working again
Hi All,
There has been a fix released in SQL Prompt 10.16.5.15563 As part of this release the ADS timebomb has been extended.
In light of Microsoft announcement yesterday, The extension is for 3 months only.
Update the ADS version to 0.2.16. (attached)
I sympathise with your frustrations, I want to reassure you that we are in constant communication with the development team to try to highlight the volume of concerns we have on this matter.
There has been a fix released in SQL Prompt 10.16.5.15563 As part of this release the ADS timebomb has been extended.
In light of Microsoft announcement yesterday, The extension is for 3 months only.
Update the ADS version to 0.2.16. (attached)
I sympathise with your frustrations, I want to reassure you that we are in constant communication with the development team to try to highlight the volume of concerns we have on this matter.

2 ·
Data comparison in Azure DevOps using SQL Change Automation
Currently we are working on implementing database releases using Azure DevOps and SQL Change Automation.
The problem is that I haven't been able to compare data. What I need to do is Compare two tables in different databases (while ignoring 2 rows).
Is there any way of doing this using Redgate SQL Change Automation Build or Release?
Thank you
The problem is that I haven't been able to compare data. What I need to do is Compare two tables in different databases (while ignoring 2 rows).
Is there any way of doing this using Redgate SQL Change Automation Build or Release?
Thank you

1 ·
Re: "A duplicate definition was found for the stored procedure '[dbo].[sproc_name]'.
I have the same problem. I commit and Redgate Source control creates a new .sql file in the format of:
SPName#.sql
e.g. SPName1.sql
Then if SQL Source control can recognize the code in both, it breaks saying it is a duplicate definition of the object.
Terrible!
SPName#.sql
e.g. SPName1.sql
Then if SQL Source control can recognize the code in both, it breaks saying it is a duplicate definition of the object.
Terrible!

1 ·
Re: Exclude system databases from any Reports and Monitoring Activities
Good morning, Cristian!
thank you for the expanded answer!
I understand this is per server option. it's very frustrating to do the same thing for each server. Is there any system wide option for this or may be powershell?cperez said:With respect to alarms, you should be able to click on Configuration > Alert Settings from the SQL Monitor UI and drill down to the database level in order to suppress all alerting from those databases.
I found all checkups I was referring to, using Settings you provided. Thank you!cperez said:
With respect to SQL Monitor Reports and checkups, could you possibly elaborate on what you are trying to achieve? What are you referring to when you say checkups?

1 ·
Re: SQL History not showing anything
i am having this same issue. i have followed all the above and still do not have a service i pay for. I need redgate support to respond with a fix for this asap.

1 ·
Variable is declared but never used - Issue

1 ·
Re: SQL Search does not search synonym definitions
This is really a pity. SQL Search seaches everywhere, even in job step definitions, but it misses to seach in column base_object_name in sys.synonyms even in version 3.5.2.
We would greatly appreciate to see this in SQL Search. We just missed several linked server occurrences in databases because they were encapsulated in synonyms that were not found.
We would greatly appreciate to see this in SQL Search. We just missed several linked server occurrences in databases because they were encapsulated in synonyms that were not found.

1 ·
Re: Microsoft Fabric support?
@Victoria W, can you let me know about this? I’m connecting to the analytics and point via ssms and I can see prompt attempting to load the database objects. It stops loading as it can’t find a master database associated with the server. Any workarounds?Joeb_csl said:How about any plans to support Fabric Lakehouse sql analytics endpoints?

1 ·
Cannot no longer use product
I have my own version of SQL Prompt I use at work. With whatever just changed, I can no longer use it - the product does not 'see' me. I deallocated and reallocated - but since I do not have 'localhost' on my PC due to CJIS standards - I cannot change my license.
Is there a way to get SQL Prompt back on my PC?
Thanks,
Doug
Is there a way to get SQL Prompt back on my PC?
Thanks,
Doug

1 ·