Best Of

Re: Exclude system databases from any Reports and Monitoring Activities

Good morning, Cristian!

thank you for the expanded answer!

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 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 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?

I found all checkups I was referring to, using Settings you provided. Thank you!

WingDog

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.

aneu

1 ·

Variable is declared but never used - Issue

Hi,

The following SQL gives Issue code: MI005 for @date.

declare @date date = getdate()

declare @xml xml = '<root/>'

set @xml.modify('insert attribute testDate {sql:variable("@date")} into (root)[1]');

select @xml

Is this a bug or am I missing something?

Version - 10.12.5.30313

Thanks,

Dave.

ddowdell

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.

kondrich

1 ·

Re: Microsoft Fabric support?

Joeb_csl said:

How about any plans to support Fabric Lakehouse sql analytics endpoints?

@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

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

Ozzie

1 ·

Re: SQL Prompt doesn't work when running SSMS as different user

I'm experiencing the same issue. Due to security, to access SSMS properly, I have to shift-right click SSMS and "Run as a different user." When I do so, the SQL Prompt menu is bare - same as reported by ed_waystar above. If I log in with my normal user, I get all the SQL Prompt menu choices. Any idea how to resolve this?

bryan_1

1 ·

SQL Prompt doesn't work when running SSMS as different user

This used to work for years, but now when swapping to another SSMS instance with another user SQL Prompt ceases to work and tells me I have an unlicensed trial on the second instance.

When I click "Manage License" and then "Log In" it tells me to use my browser, and nothing happens.

version 10.14.21.9884
SSMS v18.12.1

ed_waystar

1 ·

Re: SQL Prompt Refreshing very slowly, different query when connecting to DB

I wish it only took 6 minutes... It is taking more like 15-20 minutes on some of our Databases. Please fix this!!!!

ShaneG

1 ·

Re: Is there a way to ignore Constraints as to whether objects are the same/different?

SQL Compare has an option that allows you to ignore system generated constraint names:
Visit Edit project/Options and check "Ignore system named constraint and index names".

David Atkinson

1 ·