mssqltips logo

SQL Server 2012 Task List Feature in SSMS

By:   |   Updated: 2011-07-29   |   Comments (6)   |   Related: More > 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




Post a comment or let the author know this tip helped.

All comments are reviewed, so stay on subject or we may delete your comment. Note: your email address is not published. Required fields are marked with an asterisk (*).

*Name
*Email
Email me updates

Signup for our newsletter

I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.





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

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

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

"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 07, 2013 - 3:26:58 AM - Graham Back To Top

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

Where do these tasks get saved?

Thanks

Graham


Tuesday, December 06, 2011 - 9:05:49 AM - Wayne Erfling Back To Top

 

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

Interesting. Is this intended to integrate with TFS?



download

























get free sql tips

I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.



Learn more about SQL Server tools