Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Receiving Error 1944 when Rebuilding an index Expand / Collapse
Author
Message
Posted Thursday, August 7, 2014 1:27 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Today @ 3:16 PM
Points: 590, Visits: 6,832
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.




-
Post #1600852
Posted Thursday, August 7, 2014 1:49 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, August 15, 2014 12:28 PM
Points: 7, Visits: 23
Andrew Kernodle (8/7/2014)
(...) That certainly does make it a good bit more important!


i see what you did there
Post #1600866
Posted Thursday, August 7, 2014 1:57 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Today @ 3:16 PM
Points: 590, Visits: 6,832
D'oh, that was totally unintentional . I guess I've absorbed the ability to subconsciously fire off bad programming puns after trawling these forums enough



-
Post #1600869
Posted Friday, August 8, 2014 5:17 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, August 15, 2014 12:28 PM
Points: 7, 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.
Post #1601355
Posted Saturday, August 9, 2014 5:23 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Today @ 3:16 PM
Points: 590, Visits: 6,832
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!




-
Post #1601385
Posted Friday, August 15, 2014 11:57 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, August 15, 2014 12:28 PM
Points: 7, Visits: 23
we've now confirmed that CU13 fixes the bug
Post #1603809
Posted Friday, August 15, 2014 12:19 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 3:05 PM
Points: 17,814, Visits: 15,741
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
Post #1603824
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse