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
The question has been closed Aug 04 '10 at 12:03 AM by Cyborg for the following reason:
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!
answered Aug 02 '10 at 05:48 AM