SQL Server 2012 Task List Feature in SSMS


By:   |   Updated: 2011-07-29   |   Comments (6)   |   Related: > SQL Server Management Studio


Problem

While looking through the new features and improvements in SQL Server 2012, we found a potentially interesting feature namely the Task List. This is a very useful feature which can be utilized by Developers and DBAs to quickly list all the tasks which have been planned for the day. This feature also allows you to prioritize the tasks as well. In this tip we will take a look at how to utilize the Task List Feature of SQL Server 2012 to help you in your day-to-day activities.

Solution

Let us go through the steps you need to follow to use the Task List feature of SQL Server 2012.

1. In the SQL Server Management Studio (SSMS), click View -> Task List from the drop down list as shown in the screen shot below. You can also access the Task List feature using the "Crtl+\,T" shortcut.

ssms task list

2. Once you click on Task List in the View menu, you will be able to see a Task List window at the bottom of your SQL Server Management Studio as shown in the screen shot below.

ssms task list window

3. You can "Create User Task" by clicking the button as highlighted in the screen shot above and then add each task you plan to complete one by one which will create separate rows.

in ssms task list window create user task

4. In the Task List, you also have the option to assign priorities to each of the tasks as highlighted in the screen shot below.

assign priorities to each task

5. Once you have completed a task, click the check box next to the task to mark it as completed as shown in the screen shot below.

mark completed task in ssms task list window
Next Steps


Last Updated: 2011-07-29


get scripts

next tip button



About the author
MSSQLTips author Ashish Kumar Mehta Ashish Kumar Mehta has been contributing to the MSSQLTips.com community since 2009 with over 60 tips.

View all my tips
Related Resources



Comments For This Article




Saturday, December 29, 2018 - 6:30:19 PM - ELINA Back To Top (78579)

Hi, I am trying this on but when I open the task list, the bar with the create new user task never shows up. any ideas? Thanks!!


Thursday, June 27, 2013 - 10:10:36 AM - Jeremy Kadlec Back To Top (25600)

Sharon,

Thanks so much.  This has been corrected.

Thank you,
Jeremy Kadlec
Community Co-Leader


Thursday, June 27, 2013 - 10:03:35 AM - Sharon Levine Back To Top (25599)

"While looking through the new features and improvements in  SQL Server 2021" - wow, I am REALLY behind on versions!  LOL

interesting feature tho!


Friday, June 7, 2013 - 3:26:58 AM - Graham Back To Top (25329)

Do these tasks get saved so they are available next time you start SSMS?

Where do these tasks get saved?

Thanks

Graham


Tuesday, December 6, 2011 - 9:05:49 AM - Wayne Erfling Back To Top (15299)

 

I would much prefer a Visual Studio "scan the source files" Task List.

I know it's rare, but I use SSMS Solutions and Projects with great success and would much rather have embedded task list items than a manually-created list.


Friday, July 29, 2011 - 8:45:43 AM - Mitchell Land Back To Top (14288)

Interesting. Is this intended to integrate with TFS?



download





Recommended Reading

Different Options for Query Results in SQL Server Management Studio

Display Line Numbers in a SQL Server Management Studio Query Window

How to Install SQL Server Management Studio on your Local Computer

SQL Server Database Diagram Index was Outside the Bounds of the Array

SQL Server Management Studio Keyboard Shortcuts














get free sql tips
agree to terms