• Here is a great post by Erin Stellato that talks about when/how stats get updated. http://www.sqlskills.com/blogs/erin/understanding-when-statistics-will-automatically-update/

    If covers what you are trying to do and why you should worry about turning off those options (like Gail said).



    Microsoft Certified Master - SQL Server 2008
    Follow me on twitter: @keith_tate

    Forum Etiquette: How to post data/code on a forum to get the best help[/url]