Found a way simpler way to get this info. 🙂

Just grant execute on msdb.dbo.sqlagent_suser_sname to my low priv account and use it to get the acct name using the sid.

I suggest you do a qoogle on "sql injection attacks" and read up on them and how to protect against them.

Your procedure is wide open to being hacked. ...

Tell them to quit moaning about all the work and schedule the time to fix the 400 web.config files.

Forgot to mention that when I want to tell someone privately, one-on-one, that they're being a jack-@$$ and need to stop whatever they're doing that's making everybody mad, that the...

Back in the late 70's or early 80's (the years blur together as they go by faster and faster 🙁 ), I was in college and played D&D with my...

kerry_hood (1/6/2010)

---

I'm not a twenties-something (er, forties-something) but I am female (and in the UK). What I noticed, when I started programming, was that at college and when I...

No, my problem was that there were custom, flawed triggers added to the msdb database.

But I'll file away your fix in case I run into the problem you had. ...

Learned how to use sql profiler today to identify which procedures the database was running to create the job.

Figured out which one was blowing up and re-ran that set of...

Thanks for the idea, but that's what I've been doing. 🙁

Hmm... Wonder if going to the physical machine and doing it there would make a difference?

Have to try that...

Took the 2008 cluster offline and rebooted everything. No change. Still get the error.

Took the 3 named instances on the server offline, leaving just the default instance online....

I'm trying to create a new maintenance plan.

When I press save, it gives me a cannot create jobstep error.

Don't understand what you mean by "post the error snapshot". It's just a pop-up window that says there was an error creating the jobstep.

Is there more detail available somewhere?

I...

Books, articles, and forum examples are chock full of extremely insecure practices. Add comments warning about bad practices and point the readers to where they can find good examples...

david_wendelken (6/25/2008)

---

Here's a simple chart to illustrate reality in our software field. It applies to all job descriptions in the IT field, not just DBAs.

[font="Courier New"]

Level of...

Here's a simple chart to illustrate reality in our software field. It applies to all job descriptions in the IT field, not just DBAs.

[font="Courier New"]

Level of

...