question

AndrewAbel-6569 avatar image
0 Votes"
AndrewAbel-6569 asked Criszhan-msft edited

SQL Server 2016 Maintenance Plan Editor - Add Annotation Not Working

I'm using: -

Microsoft SQL Server 2016 (SP2-CU15-GDR) (KB4583461) - 13.0.5865.1 (X64)

SQL Server Management Studio 15.0.18384.0

I have created a brand new Maintenance Plan for a Daily Backup. The Maintenance Plan works fine and does the backup. However, I would like to add an Annotation, but each time I click "Add Annotation" nothing happens. I have used it before on many other projects, so I know how it should work.

116370-addannotation.png


I've also tried cut-n-pasting an Annotation from a Maintenance Plan on another server running SQL Server 2016 (SP2-GDR), and just get an error. Any suggestions appreciated. Thanks

116373-addannotation2.png


sql-server-general
addannotation.png (33.2 KiB)
addannotation2.png (25.0 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

Criszhan-msft avatar image
1 Vote"
Criszhan-msft answered Criszhan-msft edited

Hello,

Welcome to Microsoft Q&A!

I can reproduce your problem, I also used SSMS18.9.1, and then connected to a SQL Server 2019 instance, but opened the maintenance plan design window, clicked on the blank page and then selected "Add Annotation", the same as your situation, there is no response .

I don't have this problem with SSMS 17.9.1 and SSMS 18.5, it looks like this is a problem with SSMS 18.9.1. I will try to test the latest SSMS 18.9.2.

Update: SSMS 18.9.2 works, please upgrade your SSMS.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.