Viewing 15 posts - 286 through 300 (of 2,636 total)
Sorry, I've been on vacation. Hopefully you've figured this out, but if not, it occured to me that maybe the new instance was set up in Windows authentication mode....
July 30, 2009 at 12:16 pm
This thread describes a way to do this. Although I haven't had a need for this and haven't tried it, I think it's worth you consideration. http://www.sqlservercentral.com/Forums/Topic678099-146-1.aspx
July 30, 2009 at 12:00 pm
It can't be done. Even the SQL Agent database roles in msdb can't change job ownership.
July 23, 2009 at 5:30 pm
Whether this situation affects your application depends on what login the app is using to connect to SQL Server.
DBO is the owner of the database and is always mapped to...
July 23, 2009 at 1:15 pm
Have you looked at msdb.dbo.sp_help_job? If you run it without specifying a job, it will list all jobs.
July 22, 2009 at 5:17 pm
The Auto-Fix argument will map orphaned users to logins with the same name. Since you only have a login for abc, that's the only one that can be fixed....
July 22, 2009 at 5:10 pm
You can find step by step instructions for creating a scheduled SQL Agent job in BooksOnLine. The easiest way to do it is to right-click on SQL Server Agent...
July 22, 2009 at 8:53 am
luckysql.kinda (7/21/2009)
July 22, 2009 at 8:45 am
As far as I know, the Transfer Jobs task doesn't copy DTS packages, so I'm kind of confused by your problem. Is it possible that some of the packages...
July 14, 2009 at 3:27 pm
Sorry for the duplicate posts. Every time I hit the "post reply" button I got an error screen and it took me a while to realize that my replies...
July 8, 2009 at 4:37 pm
"hmm..i can do that but..like if i set deny permission on that role then it will be applied to all the logins associated to that role..i was trying to replicate...
July 8, 2009 at 4:31 pm
iqtedar (7/7/2009)
July 8, 2009 at 4:31 pm
iqtedar (7/7/2009)
July 8, 2009 at 4:30 pm
iqtedar (7/7/2009)
July 8, 2009 at 4:29 pm
The SQLAgentReaderRole can view job properties and job history for any job. Is the problem that you don't want the members of the role to create their own...
July 7, 2009 at 9:55 am
Viewing 15 posts - 286 through 300 (of 2,636 total)