I am trying to prepare my server for application of WSS and MOSS SP2 by performing some much needed maintenance per the last user group I attended. I ran the stored procedure provided in KB943345.Below isa short snippet of what I get (over and over, throughout the DB). It ran far too fast to accomplish anything and sure enough, I checked defrag levels before and after and they are the same. **************2009-08-05T11:09:04.897: dbo.UserInfo_PK is now being rebuilt.2009-08-05T11:09:04.897: RebuildingMsg 1712, Level 16, State 1, Line 1Online index operations can only be performed in Enterprise edition of SQL Server.2009-08-05T11:09:04.897: Done2009-08-05T11:09:04.897: dbo.UserInfo_SID is now being rebuilt.2009-08-05T11:09:04.897: RebuildingMsg 1712, Level 16, State 1, Line 1Online index operations can only be performed in Enterprise edition of SQL Server.2009-08-05T11:09:04.897: Done****************************All the KBs I could find said ONLY to run this script. But it doesn't work for me. Help!!!!TIA...

Since I had no takers on this one, I opened a support case with Microsoft. SharePoint support turned me over to SQL support, where the stored procedure was modified to work with the Standard edition of SQL Server 2005. SharePoint support said that the KB would be updated based on the support case. I'm sure I'm not alone!

Since I had no takers on this one, I opened a support case with Microsoft. SharePoint support turned me over to SQL support, where the stored procedure was modified to work with the Standard edition of SQL Server 2005. SharePoint support said that the KB would be updated based on the support case. I'm sure I'm not alone! You definitely aren't alone. Can you tell us what the change was? I'm on SQL 2008 Standard. The SP doesn't seem to do anything at all after throwing the error.

I just tried to use the script in the KB article and received the same error. Can you post the changes to the scipt?

Can someone please provide a version of the script from KB943345 that will work on SQL Server STANDARD ?