For SQL 2008, here is what we do:

ALTER DATABASE [XXX] SET AUTO_UPDATE_STATISTICS OFF WITH ROLLBACK IMMEDIATE

ALTER DATABASE [XX] SET AUTO_UPDATE_STATISTICS_ASYNC OFF WITH ROLLBACK IMMEDIATE

select Q.job_id,Q.database_id,Q.in_progress from sys.dm_exec_background_job_queue Q

where...

Great. Thanks for your help.

Thanks for the query, but it isn't returning the correct data.

The logical filename is present in select sys.master_files - I just can't workout how to tie this to the other...