In SSMS 2008, I can bring up the 'Task List' window with the keyboard shortcut Ctrl-Alt-K, or by choosing View > Other Windows > Task List.
Nice. But what is it for? How do I create Tasks? How do I manage Tasks?
I have always dismissed this as not usable for SQL files. We tried to use it in some .Net projects but met with problems. You are meant to be able to place comments in your script files to 'bookmark' work to come back to.
In TSQL you should be able to type
-- TODO get this procedure to use set based solution
and it should show up in your Task List as a pointer that you ahve something that needs attention in your code. Double clicking the item in the Task List should take you to the point in your code. There are a few default Task categories - TODO, HACK and another that I have forgotten and I think you can create your own.
As I say, in .Net projects it sometimes worked sometimes not, I have never seen it work in a SSMS solution.
If anyone has had success I'd be very pleased to hear all about it.
No one has followed this question yet.