SQL Server 2012 Task List Feature in SSMS

By:   |   Comments (6)   |   Related: > SQL Server Management Studio


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.


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

sql server categories

sql server webinars

subscribe to mssqltips

sql server tutorials

sql server white papers

next tip

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.

This author pledges the content of this article is based on professional experience and not AI generated.

View all my tips

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)


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?



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?

get free sql tips
agree to terms