Steve Jones - Editor (9/20/2010)

---

Doh! Just realized I didn't start the newsletter yesterday. That's what comes from being highly unwired and busy on the weekend.

Fortunately our new hardware will get...

Congratulations, Gail !

They should add "SSC black belt" for that number op points.

Please use convert(datetime, ...., format) when you want to handle datetime info.

Check books online for the correct format parameter to be used.

as per http://support.microsoft.com/kb/303411

"Error 8344 is equal to insufficient permissions to perform the registration operation."

This doesn't apply for sqlagent.

Did you try changing the service account and putting it back to the...

Chris Morris-439714 (9/17/2010)

---

Jon, you should try a different take on it to the Alaskan crab, say Singapore Chilli Crab (works well with blue and brown crab) or one of the...

I don't think it is an account problem.

If it were, it wouldn't get sqlagent to start in the first place.

Did you enable automatic failback in the cluster group definitions...

Oliiii (9/17/2010)

---

ALZDBA (9/17/2010)

---

I removed the user ref of this quote, because I just want to make a general comment on windows authentication ...

...It might also be cheaper to convert the...

I removed the user ref of this quote, because I just want to make a general comment on windows authentication ...

...It might also be cheaper to convert the application to...

Did you have a look at Jeffs great article : "Solving the "Running Total" & "Ordinal Rank" Problems (Rewritten)" http://www.sqlservercentral.com/articles/T-SQL/68467/

Strange indeed. According to the sqlagent.out logging it seems sqlagent received a stop request.

[131] SQLAgent$INST1 service stopping due to a stop request from a user, process, or the OS... 2010-09-16...

A single printout may even cover...

please post both execution graphical execution plans (you can save them as .sqlplan and attacht them in a reply) ?

did you try a joined solution like ...

Update A

Set RptStatement = ' watever you ' + C.comapnyName + ' @' + cast (year(getdate()) as char(4))

from...

can you attach a sqlagent.out file that came from the (failed) start of the troublesome node ?

It's a shame Raw materials is about to be ripped from our daily relief.:crying:

Can't they just turn it into a flipover kalender (you know, this kind thing

)

Many times,...