I think I finally found the issue:

The SQL Network Interface library could not register the Service Principal Name (SPN) for the SQL Server service. Error: 0x2098, state: 15. Failure to...

It was an upgrade from SP1 to Sp2.

Yes. We changed it back, but I'm trying to explain why it happened to a bunch of managers.

We had an issue that was kind of fallout from bad time updates from a domain controller that put some backup jobs into a suspended state (suspended = 5).  The...

look for corruption in msdb.

We've verified the permissions are solid.

Nope, they authenticate with SQL Server Authentication passed by an app module.

Thanks but that didn't work either.  Here's what I came up with and it works like a charm since there was nothing standard:

create function OraDateFormat (@theDate datetime)

returns varchar(20) as

begin

          ...

That's my problem.  I've tried all those SQL Server methods you've listed and none of them will get me to dd-mon-yyyy.  I need to put the date in this format...