|
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
(comments are locked)
|
The question has been closed Aug 04 '10 at 12:03 AM by Cyborg for the following reason:
|
There are a few references to this error on MS Support - I would review these and see if they fit your situation/edition/version. Thanks @Kev Riley, The article is having hotfix and Service packs, but i already had Servicepack 2 installed for my SQL Server 2005.
Aug 02 '10 at 03:57 AM
Cyborg
The articles also mention log entries in the SQL Server logs - do you get any further info there?
Aug 02 '10 at 04:49 AM
Kev Riley ♦♦
while installing the service packs will my server be in offline?
Aug 02 '10 at 05:01 AM
Cyborg
(comments are locked)
|
|
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! sharp intake of breath - that sounds dangerous!
Aug 02 '10 at 09:22 AM
Kev Riley ♦♦
Can I ask why you have such a job?
Aug 02 '10 at 09:50 AM
TimothyAWiseman
That is dangerous. Someone once decided to use a sledgehammer to crack a nut, when they really should have spent some time finding why the nut wouldn't crack.
Aug 02 '10 at 10:02 AM
Matt Whitfield ♦♦
@TimothyAWiseman Maybe the job exists simply to teach every developer to write efficient queries: either it runs in less then 30 minutes or it is killed :)
Aug 02 '10 at 12:17 PM
Oleg
@TimothyAWiseman, I dont know why these kind of job exists on the Production Server.
Aug 02 '10 at 08:16 PM
Cyborg
(comments are locked)
|
