Here's the script of the appropriate job step

---------------------------

EXEC @ReturnCode = msdb.dbo.sp_add_jobstep @job_id=@jobId, @step_name=N'Email Send',

@step_id=18,

@cmdexec_success_code=0,

@on_success_action=1,

@on_success_step_id=0,

@on_fail_action=2,

@on_fail_step_id=0,

@retry_attempts=0,

@retry_interval=0,

@os_run_priority=0, @subsystem=N'TSQL',

@command=N'/*Routine to check disk space and...

The default database for domain\user is the database that is being queried. We've tried both @execute_query_database and specifying the database in the @query.

40.  Hmm... I think I remember 40 but I'm not quite sure.  Glad you had a good one Steve.

Next year my wife will 50, our two 'kids' will be 21...

I think Amazon's problem is: What is going to cost us more - the error or the bad publicity?

As a potential customer, after this story and the "price rises" story...

"I'll likely bail in the future from sending feedback. It's just too much of a pain now."

Maybe that's idea.  Dealing with all the feedback can be a pain, too.  If...

One final thought...

How come none of the folk who cited Jesus as one of their choices picked the Devil as well?  If you believe that Jesus was influential then, surely, you...

Now, now children.  Stop squabbling.

Some thoughts:

1. Steve: this was an interesting idea but if the level of "debate" amongst intelligent people can so quickly be reduced to abuse then I'd...

Not very deeply thought through - more a gut reaction - and certainly not in any particular order...

Nelson Mandela

Adolf Hitler

Phillip Jones Griffiths - war photgrapher, especially Vietnam.  Pictures may not...

Steve - Good Luck to your son... and his parents!  Here in the UK our daughter recently took a national math test, so I have some idea of what you're going...