Home Forums SQL Server 2008 SQL Server 2008 Administration Frozen Jobs, SPIDS, and Rollback RE: Frozen Jobs, SPIDS, and Rollback

  • December 21, 2011 at 7:44 am

    #1424239

    Gail,

    I think I just found something. Read Jag's post here: http://social.msdn.microsoft.com/forums/en-US/sqldatabaseengine/thread/71d3cd0b-ce4d-4202-8e3b-38b38da90a5b%5B/url%5D. It sort of makes sense to me, but I'm wondering what else could be affected if I take this advice.

    EDIT: I can't restart SQL. This is a production box.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.