locked
Not able to create tasklist in Sql Server Management Studio RRS feed

  • 問題

  • 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

    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.



    2017年1月9日 上午 04:06

所有回覆

  • 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]

    2017年1月6日 上午 09:12
  • 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

    2017年1月6日 上午 09:22
  • Sorry, not clear: What to bring into SSMS?

    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    2017年1月6日 上午 10:14
  • ok sorry: 'the little clip board icon with the red check mark' this is missing.
    2017年1月6日 上午 10:41
  • 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
    解答者
  • 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

    2017年1月6日 上午 11:39
    解答者
  • 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.



    2017年1月9日 上午 04:06
  • Ok, thanks for the support.

    Voting has been done.

    2017年1月9日 上午 09:30
  • 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

    2020年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 articles

    2020年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.org

    2020年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 articles

    2020年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 articles

    2020年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 articles

    2020年8月19日 下午 09:32