I have had errors with non-default collations or trying to create the procedure in a database in 80 compatibility. Hard to guess without knowing the errors.

True, thank you, that would eliminate the need for those CTEs. I wish the servers in our environment were all 2008.

ITIL? Source control? Now that's just crazy talk. You can't get them to invest in something FREE.

Heck, I just would like user jobs to run on a schedule...

I hate to pick apart a person's comments, but I used to think you could do everything with SQL Server, SSIS, creativity and custom code. Truth is you can,...

You may be able to rig something with a login trigger.

I hear you. I would probably break the "where have you used it before" into a multi part answer, and maybe a question.

SQL Server Agent does not...

I'd actually use the join if the keys are unique together (concatinated key).

The optimizer is already going to optimize for the literal on e.cmpid and s.salyear, and will...

I know I'm going to get flack for this, but it is a forum. Please assume that I know the benefits of scheduling everything you can in SQL Agent,...

I agree with Craig, you need to alias the tables in the from clause, and you really don't want a JOIN for the reasons in the contextual example that Craig...

You cannot disable windows groups.

From BOL (TSQL Reference on ALTER LOGIN):

You cannot use ALTER_LOGIN with the DISABLE argument to deny access to a Windows group. For example, ALTER_LOGIN...

Are you able to apply a filter?

Examine the errors closely. You may be failing on connection manager validation and not the task. Also, you should be able to adjust the failure threshold (max errors)...

Typically, we offload reporting to a reporting copy of the data using <insert_ETL/reporting_method_here>, and most (pronounced "all") of the time it is because report queries "get out of hand" on...

Quick check, does this return any rows?

select name, type_desc, is_disabled

from sys.server_principals

where name = 'xx\xxxx'

That looks like what you want ... in the original post...