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

Kev Riley gravatar image

Kev Riley ♦♦
53.8k 47 49 76

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

Fatherjack gravatar image

Fatherjack ♦♦
42.8k 75 79 108

so another example of where MS are trying to force data peeps down the same route as app devs. I never really liked the move from EM to SSMS, and can see how these kind of things just fuel the thirst for 3rd party admin tools. TOAD anyone? :)
Jan 06, 2010 at 07:45 PM Kev Riley ♦♦
TOAD is a bit too warty for me.
Jan 07, 2010 at 06:57 AM Mark Allison
I just have the feeling they didnt want to support EM and VS so got them close enough together to call it useable and then walked away. Getting things like this to work would be a good use in a team environment. I have (dare I admit it?) never tried any other editors ...
Jan 07, 2010 at 08:52 AM Fatherjack ♦♦
(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.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

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: 2987 times

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