>>>Thanks, Naomi. The workaround (specifying any top number but 100 percent) will solve the problem for now.
>>>
>>>Does anybody know if SQL 2005 SP2 corrected this issue? I think my 2005 install might only be SP1...
>>>
>>>
>>
>>Are you sure there is SP2 for SQL Server 2005? I didn't hear.
>
>Yes, and (based on what I'm reading) it doesn't look like it fixed this issue.
>
>
http://support.microsoft.com/kb/913089Sorry, I got confused. I already have SP2 installed.
If it's not broken, fix it until it is.
My Blog