• hisakimatama (1/13/2014)


    Aha! With what Jeff mentioned, it seems that you may indeed be a victim of the aforementioned bug:

    Microsoft Fix Notes

    It seems that this problem was fixed in a Cumulative Update to Service Pack 2; since you're still on Service Pack 1, you're open to being subject to being affected by the bug.

    If at all possible, I'd say an upgrade to the most recent service pack would be preferable; that should (hopefully) clear the issue up.

    I'd like to expand on that a little - I'd recommend updating to anything from build 5200 to 5323 (for simplicity's sake, apply SQL2005 SP4 CU3), and then (re)apply the MS12-070 security patch to bring you up to build 5324 - you'll need the QFE ('with CU') version instead of the GDR ('with SP only') version you used before. http://sqlserverbuilds.blogspot.com/[/url].

    Anyone with more experience, please chime in - I'm probably doing a poor job explaining how to pick patches.