Posts
Sort by recent activity
Performance tip rg_job_history prevents updates with CU 22 for SQl Server 2017
Hi allat https://documentation.red-gate.com/sm/troubleshooting/improving-performance-of-sql-agent-job-history-sampling is a performace tip of creating an filtered index on table msdb.dbo.sysjobhist...
How often get privileged permissons sampeld and can I trigger the sampling?
HiI have 4 monitored servers. Three servers have a list of provileged persmissions. The last ( in alphabetic order ) doesn't.On the first servers the permissions were sampled monday 8:00 (+- 2 mi...
Alter Inbox: Filtering alerts by click on monitored servers tree shows no alerts
HiI have 3 groups with 4 servers. In the alert inbox on the left side is a tree which shows the number of alerts . like this:MONITORED SERVERS-> All Servers (9) -> Group1 (6) -> Server1 (6) ...
Estate -> Installed Versions doesn't show latest release of SQL Server 2017
HiI can only see CU12 for Sql Server 2017. As my Sql Monitor installation can't get through my firewall, I need to update the versions json, which lies at C:\ProgramData\Red Gate\SQL Monitor\SqlSer...
Estate -> Disk Usage says "No SQL files on this disk"
Hi release 8.0.25.19531 shows on the "Estate" -> "Disk Usage" page for all my servers and all their disks "No SQL files on this disk"Is this right or a spelling problem? Disk is shown with upper-c...
Wrong dateformat
HI I use latest Version: 8.0.15.15813In configuration settings I use the 24 hour format. But when I open my alert inbox and open an alert group, then the times are here in the 12 hour format. Wh...
Script object as alter
Hi, I found a bug in the script object as alter function.
After changing an object the version in the database differs from the local cache. When I for example type the object name in an query wind...
Starttuperror in SSMS 2008 R2 on Win7 64
Hi I unintstalle SQL-Prompt 3.9 before installing SQL-Prompt 5.
I have Sql-Source Control 1.0.6 Installed.
When I start SSMS I get followin error:
RedGate.Refactoring.AddIn.RefactorStartup - Add-in...
SQL-Prompt Professional layout Merge statement
Hi
I'am using SQl-Prompt 3.9.0.43 on SSMS 2008 with SqlServer 2008 and have problems with the new MERGE-statement.
Layout and candidate listing don't work:
for example:DECLARE @T1 TABLE ( Tab1 INT,...