When i tried to rebuild on my Server using ALTER INDEX ALL, the query runs about 1hr and returning an error Msg 0, Level 11, State 0, Line 0 A severe error occurred on the current command. The results, if any, should be discarded. What does this mean? any help will be greatly appreciated. More info: Rebuild Using ONLINE Option, The server is a publisher (Trans Replication) Thanks & Regards
Hi all! I found the problem, actually there was a job that was scheduled to run every 30 min to kill all the session that are 30 min old, so my session become a victim for that job. Thanks for your response!