I know this is almost a year old, but did you ever this answered? My company is looking at the same thing so I'd like to get informed on...

I have a little utility very similar:

SET NOCOUNT ON;

GO

DECLARE @UntrustedConstraints TABLE (

DatabaseName SYSNAME NOT NULL,

SchemaName SYSNAME NOT NULL,

TableName...

Ok, for what it's worth... I found out I can simply rerun the latest service pack exe and it will also correct this problem... go figure - so much simpler!

Let me revise my original statement. It sounds like you can use the SQLAgentUserRole or SQLAgentReaderRole to limit running jobs that a user does not own. The trick...

Ah, I missed the part about not *all* users. That part might be a little tricky. I imagine you could define your own roles and then within the...

Use the roles in the msdb database provided by Microsoft. These are just for this purpose.

After running the script and rerunning the previously posted tests, everything appears to function.

Ok, needs debugged but I think this script will do exactly what I need - rebuild the certificates and signatures from scratch. This code was pulled from the instmsdb.sql...

Ok, I've been reviewing the installation scripts and I think I know what needs to be done. Here is my summary of steps:

- Create certificate ##MS_AgentSigningCertificate## in msdb

- Add...

Sounds like you are having the same issue as me. Refer to my post in this same forum - http://www.sqlservercentral.com/Forums/Topic792839-359-1.aspx. In short, a workaround is to give them...

Elliott W (10/6/2009)

---

Do any of the ones that fail happen to be restored from somewhere else? Are you having any other securiy problems on those databases? Can you...

Ok, I have an update and a good idea what the issue is. Since our base issue is users that are part of the SQLAgentOperatorRole are unable to view/edit...

We have seven servers total but these users in question only have access to 3 of the servers:

DEV - Version: 9.00.3042.00, SP2, Developer Edition

QA - Version: 9.00.3042.00, SP2, Enterprise Edition

Staging...

No opinions?

Gift, I do not think I clearly expressed my intentions. But here goes another attempt.

Basically, I do want to get in the position where our home users...