Not able to create tasklist in Sql Server Management Studio

Question

Hi,

I 'm using SSMS and want to start using the tasklist option. displaying the task list is not a problem.

However the button for creating a new tasklist is not available. Does enyone now how I can create a new tasklist?

I'm using:

Microsoft SQL Server Management Studio                        13.0.16100.1
Microsoft Analysis Services Client Tools                        13.0.1700.441
Microsoft Data Access Components (MDAC)                        10.0.14393.0
Microsoft MSXML                        3.0 6.0
Microsoft Internet Explorer                        9.11.14393.0
Microsoft .NET Framework                        4.0.30319.42000
Operating System                        6.3.14393

Harm

Answer 1

Hello Harm,

We have only one task list and new Task can be added with the little clip board icon with the red check mark

---

Olaf Helper

[ Blog] [ Xing] [ MVP]

Answer 2

Thanks for the quick answer Olaf,

But that's the one thing I'm missing. Do you now how to bring it into my ssms environment?

Harm

Answer 3

Sorry, not clear: What to bring into SSMS?

---

Olaf Helper

[ Blog] [ Xing] [ MVP]

Answer 4

ok sorry: 'the little clip board icon with the red check mark' this is missing.

Answer 5

Hello there,

I also confirm this problem with 13.0.16000.28, there's no problem with 13.0.700.242. I think it's a bug of SSMS.

I would file it in the MS Connect, but the site also is suffering from a bug =) I'll do it later and update this thread.

---

http://ekremonsoy.blogspot.com | http://www.ekremonsoy.com | @EkremOnsoy

Answer 6

The clipboard icon with the red check mark is not there in the releases we mention Olaf =/

It seems it's gone after some certain release.

---

http://ekremonsoy.blogspot.com | http://www.ekremonsoy.com | @EkremOnsoy

Answer 7

Here's the Connect Item. Please vote.

https://connect.microsoft.com/SQLServer/feedback/details/3118202/task-list-seems-incomplete

---

http://ekremonsoy.blogspot.com | http://www.ekremonsoy.com | @EkremOnsoy

Answer 8

Hi H. van der Linde,

Based on my test, I can also not find the 'the little clip board icon with the red check mark' in my SQL Server Management Studio(SSMS) 13.0.16100.1 as shown in the below picture:



Please go to the website given from Ekrem and vote it, based on my searching, I did not find a related change in SSMS 13.0.16100.1. You can also install SSMS 2014 to work along with SSMS 2016 until this problem has fixed, you can download SQLManagementStudio_x64_ENU.exe or SQLManagementStudio_x86_ENU.exe from https://www.microsoft.com/en-sg/download/details.aspx?id=42299

If you have any other questions, please let me know.

Best Regards,
Teige

---

MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [e-mail].

Answer 9

Ok, thanks for the support.

Voting has been done.

Answer 10

Hi,

The link for feedback has  moved. it is now here:

Task List seems incomplete

https://feedback.azure.com/forums/908035-sql-server/suggestions/32899060-task-list-seems-incomplete

---

Dan Jameson
Associate Director of IT/DBA
Children's Oncology Group
www.ChildrensOncologyGroup.org

Answer 11

I tried to figure out what exactly this thread is about and what is this Task List but I don't see it at all. What it's supposed to be and how to create it?

---

Looking for new opportunities

For every expert, there is an equal and opposite expert. - Becker's Law

My blog

My TechNet articles

Answer 12

On the View menu in SSMS there is a "Task List" item. If you choose it, it opens the Task List at the bottom of SSMS. If you put the cursor on a line in the SQL Editor, and tap Ctrl-K, Ctrl-H, it will put a shortcut icon in the gray gutter bar on the left and an entry in the Task List. If you double click the Task List item, it will take you to the line of code, even if you have closed the file.

What is broken is that in the older versions of SSMS, there was a button in the Task List to add an ad-hoc task. I has been missing, apparently, since SSMS 2017. The feedback item I linked to above is about getting the Add Task button put back.

---

Dan Jameson
Associate Director of IT/DBA
Children's Oncology Group
www.ChildrensOncologyGroup.org

Answer 13

Hi Dan,

This is where I was trying to find this option yesterday (I am using the very latest SSMS). I looked everywhere and this is what I currently see (do I need to open something first in SSMS to get this window?) I only have new Query opened right now.

---

Looking for new opportunities

For every expert, there is an equal and opposite expert. - Becker's Law

My blog

My TechNet articles

Answer 14

Naomi,

Wow! You're right. When I was working with this late last night I was using SSMS 17.9.1 at home. I just checked the SSMS 18.6 I have at work, and it looks like they removed the Task List instead of fixing it.

Darn! I was just looking forward to using it. It is still available in Visual Studio 2019 database projects.

---

Dan Jameson
Associate Director of IT/DBA
Children's Oncology Group
www.ChildrensOncologyGroup.org

Answer 15

Thanks Dan. Since I never used it I don't know what do I miss :) But at least you got me the info.

Thanks again.

---

Looking for new opportunities

For every expert, there is an equal and opposite expert. - Becker's Law

My blog

My TechNet articles

Answer 16

Wow! You're right. When I was working with this late last night I was using SSMS 17.9.1 at home. I just checked the SSMS 18.6 I have at work, and it looks like they removed the Task List instead of fixing it.

No, it is still there. (As testified by the fact that Next Task and Previous Task is still in the menu.) You can use Ctrl-Alt-K to open it. Whether Ctrl-K, Ctrl-H still works, I don't know, since I always remap Ctrl-K to show the actual execution plan.

(I was completely unaware of the Task List prioor to Jedi reviving this thread. But it was easy to find the function through the Keyboard-configuration menu under Tools->Options.)

---

Erland Sommarskog, SQL Server MVP, [e-mail]

Answer 17

Well, it does open for me, but both drop downs are empty and I see no way to add anything to the task list (pressing Ctrl+K/Ctrl+H does nothing for me - says something in the bottom that this command is bound to 'Toggle Task List shortcut' which is not currently available.

---

Looking for new opportunities

For every expert, there is an equal and opposite expert. - Becker's Law

My blog

My TechNet articles