Funnily enough if I copy the results directly from SSMS to Excel the datetime2 coumn is fine and I can format the dates.

I can't see why this wouldn't be the...

It's more an issue of we asked the developers to use datetime2 going forward. The precision isn't really an issue.

It looks like we'll be having another discussion on datetime vs...

Its annoying because it means we'd have to cast or convert every datetime2 date that could appear on the spreadsheet(s).

The developers will argue it'd be quicker to change the data...

Ok thanks for the advice.

I'll bear that in mind when I make my choice.

Yeah I've been looking at a minimum of 16Gb for RAM. Ideally I'll get an SSD as well.

I don't mind paying decent money for something. I just don't want to...

I managed to get this working from this post

Thanks Adi.

Are you able to provide the link?

Ah ok. Thanks for the tip and I'll bear that in mind.

I did try that but the number of processes shown never seems to correspond to the number in the overview panel.

That isn't what I mean.

In the overview panel there is a graph showing 7 waiting tasks. I'm trying to find out how I can identify these 7 tasks.

Looks like sys.dm_os_waiting_tasks is what I need.

Is there something I have to filter on to return the specific tasks indicated by Activity Monitor?

Yeah I think you're right.

Thanks for your help on this.

Ok I see what you mean now.

At the moment it looks like a re-install.

Should I not be able to use:

EXEC sp_configure 'default language', 23

RECONFIGURE WITH OVERRIDE

This doesn't appear to work though.

The login is set to British English.

I just added a note to my previous post to say that if I run sp_helplanguage @language = @@LANGUAGE, the name of the language...