Remove the popup message after removing the SQL document in SQL Server

Question

Goal: don't display the popup when you remove/delete the SQL document in SQL Server.

Problem: before I downloaded the latest version of SQL Server, it didn't show any popup about status when I removed the SQL document.

When I downloaded the latest version of SQL Server, it suddenly started to display the popup.

It always displays when I remove/delete the SQL document in SQL Server.

How do I remove it?

Thank you!

Answer 1

Uninstalling third-party SQL software permanently removed the "Querying transaction count" popup for me. Details are below.

---

I downloaded Devart's "SQL Tools" pack. It was one installation file that installed the 15 separate applications into SQL Server Management Studio. I didn't even open any of the applications yet or activate the free trial (not sure if it activates automatically or not), and ever since have been receiving the "Querying transaction count" popup every time a query window is closed.

This was reducing my productivity, so I spent a few hours researching how to remove this popup so I don't have to click the close button thousands of times. SSMS didn't update, there weren't any options within SSMS or Devart to remove this popup, and there weren't any solutions online other than to create a macro to replicate multiple keyboard strokes to disconnect the connection first and then close the query window.

I ended up uninstalling these 15 applications, and without even needing to restart my PC, the "Querying transaction count" stopped appearing. As an added bonus, the annoying "Buy Devart" PC ads with the too-tiny-to-click-to-close-X that were also popping up every few hours (15+ popup ads a day during Black Friday sale too) stopped appearing as well! Hallelujah! Maybe someone else experiencing this "Querying transaction count" SELECT @@trancount popup installed third-party software like Devart's and just needs to uninstall it.

The software below looks amazing and I'm still interested in trying them out if the free trial didn't automatically activate and expire, but will probably install them one at a time so I can figure out which of the 15 programs is causing this popup. SQL Complete was the only one that I kept and is not causing the popup, so it's 1 of the other 14.

Devart's SQL Tools

1. SQL Complete (Not Causing Popup)
2. Source Control
3. Unit Test
4. Schema Compare
5. Data Compare
6. Data Generator
7. Documenter
8. Data Pump
9. Index Manager
10. Query Builder
11. Search
12. Monitor
13. Event Profiler
14. SQL Decryptor
15. DevOps Automation