question

Kev Riley avatar image
Kev Riley asked

Task List in Management Studio 2008

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?

sql-server-2008ssms
2 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Good question, I wish I knew.
0 Likes 0 ·
Never saw that one before. Reading up on it, it sounds like it's part of Visual Studio... It's connected to projects somehow, according to the documentation, but I can't seem to get it to work. Interesting.
0 Likes 0 ·

1 Answer

·
Fatherjack avatar image
Fatherjack answered

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.

Jonathan

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.