If you're aliasing a Delete table for a join, the same principal works.  Example:

Delete from MyTable

from MyTable t1

join OtherTable t2

on t1.A = t2.A  ...

Basically, you have to list the FROM...

Are you talking about in the text of the proc or in the actual proc name?

You can write a T-SQL statement that pulls the name & Text of the Procs affected...

Except for the problem that the job is what actually schedules the SSIS package, so using SSIS to schedule the job wouldn't work except in a very recursive, clumsy way.

A...

The more I think about your idea, Ed, the more I like it.  I'm not sure how easy or hard it really would be for MS to code it up,...

I definitely would like to just go in and click a little check box next to each job step to say "Disabled".  It would make my life much easier.  And...

As much as I hate to suggested it, the only way you can do what you want is through the use of dynamic SQL.  Stored procedures and Cursors don't like...

Well, the agent does support that sort of thing much in the same manner as John mentioned the disabling of steps.  What you do is use the sp_start_job proc to...

Okay, now I feel just plain silly. @=)

I completely forgot about that functionality... Thanks for reminding me, John.

Half the stuff posted on Monster anymore seems to be trying to get people into Sales jobs or get them into training classes.  It's sad.

Worse when they stick ads for...

Good point on the definition, Matt.

I actually meant outsourced in the sense that the DBA A) a contractor (not employed directly by the company and B) doesn't come into the...

I'm glad my forgetfulness could help someone out. @=)

If the practice tests are any example, I'm thinking you have 145 minutes total for the exam.  The other stuff may be covered by NDAs (I haven't taken the test...

Has anyone noticed whether DBAs get outsourced?  I've heard of programming, help desks and other call centers getting outsourced, but I've never heard one instance of DBA outsourcing.

I can't imagine how anyone could...

HA!  I'm not going crazy!!!

I just found the errata for this book on Microsoft's Website.  No wonder I'm frustrated.  There are a LOT of typos in this stupid book.

Moral of...

AHA!  I think I finally found the the way to turn XML datatype data into data you can operate on.

Does the Nodes() method sound correct to anyone?