skcadavre, thanks the value for the response time was 805972 if that helps....

skcadavre (3/2/2011)

---

karen.blake (3/2/2011)

---

I do have one other question. For 2 of the calls the response time is 223:52:54 (if you calculate it and states this in the system we are...

Hi crainlee2, thanks for this I had also read this point too.

I deleted anything over 7 days 3000 rows at a time in the end and it actually didn't take...

Hi Terry,

I ended up changing it to this:

DELETE FROM SiteEvents

WHERE TimeStamp < DATEADD(DD, -7, GetDate())

This works fine. I now of course have to do some investigation into lock strategies since...

Thanks skcadavre, that's really helpful.

For the first part I just need to get rid of the decimals but I know that will be a format issue.

For the second part I...

My apologies I need to remember to just include everything from now on and that it's never too much information.

Ok so for the table here is the query used to...

Lowell thank you so much I think I was staring at it too long and couldn't see the wood for the trees!

Hi Lowel,

Thanks for your response, I did wonder if I had given enough information so here is the whole query that I have run:

DECLARE @Hours int

DECLARE @minutes int

DECLARE @seconds INT

SET...

It's a dumb day for me...thank you worked perfectly!

Ok I managed to solve it by using the actual URL rather than anything else in the Server Name area. Worked first time....hopefully that helps someone else.

thanks jmcmullen it turns out that an additional profile had been set up for the database mail so was easily solvable in the end 🙂

Doug I had a whole week of getting my head round that last week, it's tricky. Determined to do it plus I am a firm fan of SSRS.

GetOffMyfoot, thank you so much I clearly was looking at things too closely (overthinking as per usual!).

It worked first time with your suggestion, I really appreciate it.

Thank you so much both of you, GSquared that is perfect I used your suggestion.

Thanks again.

Hi All,

Thank you so much for your help, it's appreciated.

A good night's sleep and looking at this has made things much clearer. I will work on it today and let...