question

Cyborg avatar image
Cyborg asked

Index Rebuild Error

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
sql-server-2005indexrebuild
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Kev Riley avatar image
Kev Riley answered
There are a few references to this error on MS Support - I would review these and see if they fit your situation/edition/version.
4 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Thanks @Kev Riley, The article is having hotfix and Service packs, but i already had Servicepack 2 installed for my SQL Server 2005.
0 Likes 0 ·
The articles also mention log entries in the SQL Server logs - do you get any further info there?
0 Likes 0 ·
while installing the service packs will my server be in offline?
0 Likes 0 ·
@Cyborg... In a single server env then yes it will be offline, but if you are using some high availability options (i.e. clustering), then it is possible to do a live update.
0 Likes 0 ·
Cyborg avatar image
Cyborg answered
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!
5 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

*sharp intake of breath* - that sounds dangerous!
4 Likes 4 ·
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.
1 Like 1 ·
Can I ask why you have such a job?
0 Likes 0 ·
@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 :)
0 Likes 0 ·
@TimothyAWiseman, I dont know why these kind of job exists on the Production Server.
0 Likes 0 ·