Viewing 15 posts - 1 through 15 (of 27 total)
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...
May 19, 2015 at 2:28 pm
I have a little utility very similar:
SET NOCOUNT ON;
DECLARE @UntrustedConstraints TABLE (
DatabaseName SYSNAME NOT NULL,
SchemaName SYSNAME NOT NULL,
November 7, 2014 at 2:26 pm
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!
October 9, 2009 at 1:40 pm
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...
October 8, 2009 at 11:52 am
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...
October 8, 2009 at 11:43 am
Use the roles in the msdb database provided by Microsoft. These are just for this purpose.
October 7, 2009 at 3:15 pm
After running the script and rerunning the previously posted tests, everything appears to function.
October 7, 2009 at 1:01 pm
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...
October 7, 2009 at 12:52 pm
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
October 7, 2009 at 9:38 am
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...
October 7, 2009 at 7:58 am
Elliott W (10/6/2009)
October 7, 2009 at 7:11 am
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...
October 6, 2009 at 2:30 pm
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
October 1, 2009 at 3:15 pm
September 30, 2009 at 6:53 am
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...
September 21, 2009 at 12:51 pm