Check out SQL Server Agent roles in BOL:

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/719ce56b-d6b2-414a-88a8-f43b725ebc79.htm

Here's a VB Script that will do it as well. You can run it from Task Scheduler or SQL Agent (whichever you want). Just remove the .txt from...

The first question to ask is "what's changed?". Things don't just stop working.

It sounds like the computer you are logging in to with Novell credentials is not connected to a Windows network (correct me if I'm wrong).

That being the case, you will...

I have on our dev environment and things seemed to continue ticking along OK. Haven't had to do it in production (it's been all or nothing failovers, mainly for...

Question 1: What's changed?

Things (usually) don't just stop working by themselves.

Question 2: Can you create a connection from the scheduling server to the SQL Server manually? Try...

There are bits & pieces scattered around the place. The stuff I have found is:

Registry: HKCU\Software\Microsoft\Microsoft SQL Server

C:\Documents and Settings\[username]\Application Data\Microsoft\Microsoft SQL Server

C:\Documents and Settings\[username]\Local Settings\Application Data\Microsoft\Microsoft SQL...

I have seen it written that having separate resources for DTC is best, but that it is acceptable to have it with your quorum resources. I am running a...

Depends if you need to notify multiple people or not. You could setup a shared mailbox & send emails to that. Or you could set up a distribution...

I don't think that will help - the problem is the databases aren't available to be selected, let alone getting to the table level.

It's not mssqlsystemresource.mdf is it? You'll not want to be fiddling with that.

Make sure you have restarted SQL Agent after configuring the mail profile for it.

Any error being returned? What mail system is being used?

What exactly are you wanting to trace? Login/logout/login failure by members of the groups? Object access by members of these groups? Profiler will track individual logins but...

I've been getting the same thing. It's especially frustrating when you get a job failure but looking in that log shows everything finished OK (the integrity checks run OK...