• Great question. For me, I couldn't decide between the background task running after the ALTER DATABASE command completed or immediately, before the ALTER DATABASE completed, as the background thread is asynchronous and I wasn't sure if the ALTER DATABASE had other work to do after it kicked the thread off.

    Fortunately, I chose correctly 🙂

    _____________________________________________________________________
    [font="Comic Sans MS"]"The difficult tasks we do immediately, the impossible takes a little longer"[/font]