I am having a problem when running sp_updatestats on my database it generates an error when my emp table is updating and disconnects I will paste the error here
Updating [dbo].[emp] Msg 0, Level 11, State 0, Line 0 A severe error occurred on the current command. The results, if any, should be discarded. Msg 0, Level 20, State 0, Line 0 A severe error occurred on the current command. The results, if any, should be discarded.
Is it because any problem with the table when I run DBCC checktable(emp) , it doesn't showed any problems.Then what will be the cause
How can we find the root cause of the problem without installing a service pack as mentioned by @gbn ,how can we eliminate it. what if the problem is occurring in version having sp2 installed ,If it happens in a production server and installing service pack is the only way to resolve it ,as a dba what we can do?