But, Coldplay, followed by the Pixies?!? Oh dear...

Thanks very much, thats sopt on!

For info, a collegue of mine came up with this alternative solution:

declare @days as int

declare @startDate as datetime

declare @endDate as datetime

set @startDate = '2008-11-01'

set...

Hi Chris, thanks for the help!

My table looks like this (simplified):

CREATE TABLE [dbo].[LogEntry](

[ID] [bigint] IDENTITY(1,1) NOT NULL,

[LogDate] [smalldatetime] NOT NULL,

[Message] [text] NOT NULL,

[ProcessID] [nvarchar](50) NULL

)

Some test data:

SET IDENTITY_INSERT LogEntry ON

INSERT...

Thats spot on mate - thanks a lot! 😀

For technical software I think it is a very different approach to that required for consumer software.

In a technical application I want it to be VERY easy to get up...

The CSV is repopulated every day.

I'm not getting any line numbers reported at all actually, I get the error almost instantly. I've looked through the first few lines and can't...

Not even trying to run.

We also have some tasks displayed in the jobs list which permanently say they are currently running. There's no activity from them, and if I right-click...

Ah found it, some of the mail tasks were trying to send through a profile which no longer exists - thanks very much for the tip!