最佳解答者
Not able to create tasklist in Sql Server Management Studio

問題
-
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.14393Harm
2017年1月6日 上午 09:02
解答
-
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 MSDNFSF@microsoft.com.
- 已編輯 Teige Gao 2017年1月9日 上午 04:08
- 已標示為解答 H. van der Linde 2017年1月9日 上午 09:29
2017年1月9日 上午 04:06
所有回覆
-
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
2017年1月6日 上午 11:35解答者 -
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
- 已編輯 Olaf HelperMVP 2017年1月6日 下午 07:16 Link as a link
- 已提議為解答 Teige Gao 2017年1月9日 上午 02:34
2017年1月6日 下午 06:51解答者 -
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 MSDNFSF@microsoft.com.
- 已編輯 Teige Gao 2017年1月9日 上午 04:08
- 已標示為解答 H. van der Linde 2017年1月9日 上午 09:29
2017年1月9日 上午 04:06 -
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.org2020年8月19日 上午 05:31 -
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 articles2020年8月19日 上午 05:43 -
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.org2020年8月19日 上午 05:53 -
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 articles2020年8月19日 下午 01:03 -
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- 已提議為解答 JediSQL 2020年8月19日 下午 08:40
2020年8月19日 下午 06:30 -
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 articles2020年8月19日 下午 06:42 -
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, esquel@sommarskog.se
2020年8月19日 下午 09:11 -
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 articles2020年8月19日 下午 09:32