• 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 Q.in_progress = 1 AND Q.database_id = 9

    There is then a function called KILL STATS JOB Y