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?

more ▼

asked Jan 06, 2010 at 06:55 AM in Default

avatar image

Kev Riley ♦♦
64.1k 48 62 81

Good question, I wish I knew.

Jan 06, 2010 at 11:24 AM Jack Corbett

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.

Jan 06, 2010 at 01:35 PM Grant Fritchey ♦♦
(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

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.


more ▼

answered Jan 06, 2010 at 06:23 PM

avatar image

Fatherjack ♦♦
43.7k 79 98 117

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Jan 06, 2010 at 06:55 AM

Seen: 3528 times

Last Updated: Jan 06, 2010 at 06:55 AM

Copyright 2016 Redgate Software. Privacy Policy