SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Receiving Error 1944 when Rebuilding an index


Receiving Error 1944 when Rebuilding an index

Author
Message
Andrew Kernodle
Andrew Kernodle
SSC Eights!
SSC Eights! (802 reputation)SSC Eights! (802 reputation)SSC Eights! (802 reputation)SSC Eights! (802 reputation)SSC Eights! (802 reputation)SSC Eights! (802 reputation)SSC Eights! (802 reputation)SSC Eights! (802 reputation)

Group: General Forum Members
Points: 802 Visits: 8135
Oh, I see! I thought the problem might only come up in relatively niche circumstances with bits, but it looks like it's a lot more widespread than that. That certainly does make it a good bit more important!

I'll tinker with it on my side a bit more, then; I don't foresee it being a problem in my current environment, but there could be a case when remembering this sort of thing will be handy.

- :-D
millerrich
millerrich
SSC Rookie
SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)

Group: General Forum Members
Points: 27 Visits: 23
Andrew Kernodle (8/7/2014)
(...) That certainly does make it a good bit more important!


i see what you did there ;-)
Andrew Kernodle
Andrew Kernodle
SSC Eights!
SSC Eights! (802 reputation)SSC Eights! (802 reputation)SSC Eights! (802 reputation)SSC Eights! (802 reputation)SSC Eights! (802 reputation)SSC Eights! (802 reputation)SSC Eights! (802 reputation)SSC Eights! (802 reputation)

Group: General Forum Members
Points: 802 Visits: 8135
D'oh, that was totally unintentional :-P. I guess I've absorbed the ability to subconsciously fire off bad programming puns after trawling these forums enough :-D

- :-D
millerrich
millerrich
SSC Rookie
SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)

Group: General Forum Members
Points: 27 Visits: 23
microsoft reports that this bug was identified and fixed in the latest 2008 R2 SP2 cumulative update (CU13, build 10.50.4319.0, see http://support.microsoft.com/kb/2957174 for details).

we're currently on 2008 R2 SP2 CU7, so it looks like catching up on the CUs will resolve the problem for us.
Andrew Kernodle
Andrew Kernodle
SSC Eights!
SSC Eights! (802 reputation)SSC Eights! (802 reputation)SSC Eights! (802 reputation)SSC Eights! (802 reputation)SSC Eights! (802 reputation)SSC Eights! (802 reputation)SSC Eights! (802 reputation)SSC Eights! (802 reputation)

Group: General Forum Members
Points: 802 Visits: 8135
Ah, I see. Good to know it wasn't intended functionality, and that there's a fix out there. My company is on 2008 R2 SP1, and we're probably never moving past that due to vendor restrictions, so it's something I'll have to keep in mind.

Thanks for posting back with your findings!

- :-D
millerrich
millerrich
SSC Rookie
SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)

Group: General Forum Members
Points: 27 Visits: 23
we've now confirmed that CU13 fixes the bug
SQLRNNR
SQLRNNR
SSC-Dedicated
SSC-Dedicated (33K reputation)SSC-Dedicated (33K reputation)SSC-Dedicated (33K reputation)SSC-Dedicated (33K reputation)SSC-Dedicated (33K reputation)SSC-Dedicated (33K reputation)SSC-Dedicated (33K reputation)SSC-Dedicated (33K reputation)

Group: General Forum Members
Points: 33364 Visits: 18560
Woohoo - good to hear.



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw

Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search