January 6, 2008 at 10:41 pm
I have a maintenance plan to update statistics 10% for all tables in the database. I got the following error.
Server: Msg 3628, Level 16, State 1, Line 1
A floating point exception occurred in the user process. Current transaction is canceled.
I ran update statistics 10% against all tables and found out one table (6 millions rows and has no index) has this error. With 5% is successful but with 10%, 20%, it has this error. The database is set to auto create statistics. DBCC CHECKTABLE has no error on this table.
MS has a KB http://support.microsoft.com/default.aspx?scid=kb;en-us;812995 saying recent SP is required. My server is SQL2000 SP4 2187 already.
What is the possible problem? Any input is much appreciated.
January 7, 2008 at 12:15 am
Check the following link may help u
http://sqlforums.windowsitpro.com/web/forum/messageview.aspx?catid=70&threadid=45658&enterthread=y
January 7, 2008 at 7:20 am
Thank you vyas. I read this post. MDAC on my server is 2.82.1830.
I am wondering what the possible root cause?
I will try to export to another DB system. But why SQL query analyzer does not work?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply