Thanks for the quick response!

What if the job has been disabled? Is it possible to query a job and have it fire an alert if a job is disabled?

Regards,

Iain

Thanks!  Worked a treat!

Thanks.  I'll give that a try!

Thanks guys.  Can DBCC REBUILDLOG be used on SQL 2000?

Hi guys,

Thanks for the advice.  As it turned out, it WAS just a ropey restore.  I ran it again and surprise, surprise it worked.

We usually DO use disk based backups...

Thanks - I'll take a look at this and get back to you.

But if the two databases are on the same server, surely server persmissions don't apply?

Well, we've tried with two databases (identical according to SQL compare) on staging and one is fine but the other won't work (the restored one).  Would server permissions come in...

The only reason we believe that it is the database causing the issue is that the db that the front end is pointed at is the only thing that changes. ...

Hi guys,

I've got it figured out.  I was joining on utterly the wrong thing (and the wrogn table for that matter *blush*).  The complete query is below. 

Iain

select

employee.work_email as...

Thanks guys - I'll give that whirl and let you know how I get on.

Hi ya,

Thanks for the feedback - I've done exactly that

Hi,

Thanks for the help, but this appears to have resolved itself.  *shrugs*  One of those things I guess.

Cheers!

Job's a good 'un!