XP SP2 fully updated, SQL 2005 DE SP1 using SA login. Store setup works fine, store works fine.
Login to admin and close store. Run sitepatchinstaller which is a success. Execute query and get what you see below. This was identical on our host (they got the same results after reading to make sure the permissions were correct). Is this related to the lack of products as Noah and others report it works perfectly every time, yet it doesn't work when the host tries it, or I try it here locally.
[1]
Dropping foreign keys from [dbo].[bvc_Product]
Msg 3728, Level 16, State 1, Line 1
'FK_bvc_Product_bvc_Product' is not a constraint.
Msg 3727, Level 16, State 0, Line 1
Could not drop constraint. See previous errors.
(1 row(s) affected)
Dropping foreign keys from [dbo].[bvc_ProductChoiceCombinations]
Dropping foreign keys from [dbo].[bvc_ProductInventory]
Dropping foreign keys from [dbo].[bvc_ProductPropertyValue]
Dropping foreign keys from [dbo].[bvc_ProductXCategory]
Dropping foreign keys from [dbo].[bvc_Sale]
Msg 3728, Level 16, State 1, Line 1
'FK_bvc_Sale_bvc_Sale' is not a constraint.
Msg 3727, Level 16, State 0, Line 1
Could not drop constraint. See previous errors.
(1 row(s) affected)
Dropping foreign keys from [dbo].[bvc_ShippingMethod_CountryRestriction]
Dropping foreign keys from [dbo].[bvc_ShippingMethod_RegionRestriction]
Dropping constraints from [dbo].[bvc_Product]
Dropping constraints from [dbo].[bvc_Product]
Msg 3725, Level 16, State 0, Line 1
The constraint 'PK_bvc_Product' is being referenced by table 'bvc_ProductXCategory', foreign key constraint 'FK_ProductXCategory_bvc_Product'.
Msg 3727, Level 16, State 0, Line 1
Could not drop constraint. See previous errors.
(1 row(s) affected)
Dropping constraints from [dbo].[bvc_Product]
Dropping constraints from [dbo].[bvc_Product]
Dropping constraints from [dbo].[bvc_Product]
Dropping constraints from [dbo].[bvc_Product]
Dropping constraints from [dbo].[bvc_ProductVolumeDiscounts]
Msg 3728, Level 16, State 1, Line 1
'DF_bvc_ProductVolumeDiscounts_Price' is not a constraint.
Msg 3727, Level 16, State 0, Line 1
Could not drop constraint. See previous errors.
(1 row(s) affected)
Dropping index [IX_bvc_Order_UserId] from [dbo].[bvc_Order]
Dropping index [IX_bvc_OrderCoupon_OrderBvin] from [dbo].[bvc_OrderCoupon]
Dropping index [IX_bvc_OrderPackage_OrderId] from [dbo].[bvc_OrderPackage]
Dropping index [IX_bvc_OrderPayment_OrderId] from [dbo].[bvc_OrderPayment]
Dropping index [IX_bvc_Product_sku] from [dbo].[bvc_Product]
Dropping index [IX_bvc_Product_ParentId] from [dbo].[bvc_Product]
Dropping index [bvc_ProductChoiceCombinations_ChoiceId_ChoiceOptionId] from [dbo].[bvc_ProductChoiceCombinations]
Dropping index [IX_bvc_ProductChoiceOptions_ProductChoiceId] from [dbo].[bvc_ProductChoiceOptions]
Dropping index [IX_bvc_ProductChoices_ProductId] from [dbo].[bvc_ProductChoices]
Dropping index [IX_bvc_ProductModifier_ProductId] from [dbo].[bvc_ProductModifier]
Dropping index [IX_bvc_ProductModifierOption_ModifierId] from [dbo].[bvc_ProductModifierOption]
Dropping index [IX_bvc_ProductPropertyChoice_PropertyBvin] from [dbo].[bvc_ProductPropertyChoice]
Dropping index [IX_bvc_ProductReview_ProductBvin] from [dbo].[bvc_ProductReview]
Dropping index [IX_bvc_RMA_OrderBvin] from [dbo].[bvc_RMA]
Altering [dbo].[bvc_ProductVolumeDiscounts]
Rebuilding [dbo].[bvc_Product]
Msg 2714, Level 16, State 4, Line 1
There is already an object named 'DF_bvc_Product_RewriteUrl' in the database.
Msg 1750, Level 16, State 0, Line 1
Could not create constraint. See previous errors.
(1 row(s) affected)
Msg 1088, Level 16, State 11, Line 1
Cannot find the object "dbo.tmp_rg_xx_bvc_Product" because it does not exist or you do not have permissions.
(1 row(s) affected)
Msg 208, Level 16, State 1, Line 1
Invalid object name 'dbo.tmp_rg_xx_bvc_Product'.
(1 row(s) affected)
Msg 1088, Level 16, State 11, Line 1
Cannot find the object "dbo.tmp_rg_xx_bvc_Product" because it does not exist or you do not have permissions.
(1 row(s) affected)
Msg 3726, Level 16, State 1, Line 1
Could not drop object 'dbo.bvc_Product' because it is referenced by a FOREIGN KEY constraint.
(1 row(s) affected)
Msg 15225, Level 11, State 1, Procedure sp_rename, Line 332
No item by the name of '[dbo].[tmp_rg_xx_bvc_Product]' could be found in the current database 'promomanagers', given that @itemtype was input as '(null)'.
Creating primary key [PK_bvc_Product] on [dbo].[bvc_Product]
Msg 1779, Level 16, State 0, Line 1
Table 'bvc_Product' already has a primary key defined on it.
Msg 1750, Level 16, State 0, Line 1
Could not create constraint. See previous errors.
(1 row(s) affected)
Creating index [IX_bvc_Product_sku] on [dbo].[bvc_Product]
Msg 1913, Level 16, State 1, Line 1
The operation failed because an index or statistics with name 'IX_bvc_Product_sku' already exists on table 'dbo.bvc_Product'.
(1 row(s) affected)
Creating index [IX_bvc_Product_ParentId] on [dbo].[bvc_Product]
Msg 1913, Level 16, State 1, Line 1
The operation failed because an index or statistics with name 'IX_bvc_Product_ParentId' already exists on table 'dbo.bvc_Product'.
(1 row(s) affected)
Creating [dbo].[bvc_ProductAvailableAndActive]
Msg 2714, Level 16, State 3, Procedure bvc_ProductAvailableAndActive, Line 61
There is already an object named 'bvc_ProductAvailableAndActive' in the database.
(1 row(s) affected)
Altering [dbo].[bvc_Product_ProductsOrderedCount_s]
Altering [dbo].[bvc_Product_ByCrossSellId_s]
Creating [dbo].[bvc_Product_ByCrossSellId_Admin_s]
Msg 2714, Level 16, State 3, Procedure bvc_Product_ByCrossSellId_Admin_s, Line 78
There is already an object named 'bvc_Product_ByCrossSellId_Admin_s' in the database.
(1 row(s) affected)
Altering [dbo].[bvc_Product_u]
Creating [dbo].[bvc_Product_ByUpSellId_Admin_s]
Msg 2714, Level 16, State 3, Procedure bvc_Product_ByUpSellId_Admin_s, Line 78
There is already an object named 'bvc_Product_ByUpSellId_Admin_s' in the database.
(1 row(s) affected)
Creating [dbo].[bvc_Product_ProductsOrderedCount_Admin_s]
Msg 2714, Level 16, State 3, Procedure bvc_Product_ProductsOrderedCount_Admin_s, Line 39
There is already an object named 'bvc_Product_ProductsOrderedCount_Admin_s' in the database.
(1 row(s) affected)
Creating [dbo].[bvc_Category_AllVisible_s]
Msg 2714, Level 16, State 3, Procedure bvc_Category_AllVisible_s, Line 100
There is already an object named 'bvc_Category_AllVisible_s' in the database.
(1 row(s) affected)
Altering [dbo].[bvc_ProductModifier_ByProduct_s]
Altering [dbo].[bvc_Product_SuggestedItems]
Altering [dbo].[bvc_ProductUpSell_Count_s]
Altering [dbo].[bvc_Product_ByCategory_s]
Creating [dbo].[bvc_ProductCrossSell_Count_Admin_s]
Msg 2714, Level 16, State 3, Procedure bvc_ProductCrossSell_Count_Admin_s, Line 22
There is already an object named 'bvc_ProductCrossSell_Count_Admin_s' in the database.
(1 row(s) affected)
Altering [dbo].[bvc_Category_All_s]
Altering [dbo].[bvc_Product_ByUpSellId_s]
Altering [dbo].[bvc_Product_ByFile_s]
Creating [dbo].[bvc_ProductUpSell_Count_Admin_s]
Msg 2714, Level 16, State 3, Procedure bvc_ProductUpSell_Count_Admin_s, Line 22
There is already an object named 'bvc_ProductUpSell_Count_Admin_s' in the database.
(1 row(s) affected)
Altering [dbo].[bvc_Product_i]
Altering [dbo].[bvc_RMA_All_s]
Altering [dbo].[bvc_ProductCrossSell_Count_s]
Creating [dbo].[bvc_Category_VisibleNeighbors_s]
Msg 2714, Level 16, State 3, Procedure bvc_Category_VisibleNeighbors_s, Line 220
There is already an object named 'bvc_Category_VisibleNeighbors_s' in the database.
(1 row(s) affected)
Altering [dbo].[bvc_Product_d]
Altering [dbo].[bvc_Product_ByCriteria_s]
Creating [dbo].[bvc_UserAccount_ByCriteria_s]
Msg 2714, Level 16, State 3, Procedure bvc_UserAccount_ByCriteria_s, Line 38
There is already an object named 'bvc_UserAccount_ByCriteria_s' in the database.
(1 row(s) affected)
Creating index [IX_bvc_Order_UserId] on [dbo].[bvc_Order]
Msg 1913, Level 16, State 1, Line 1
The operation failed because an index or statistics with name 'IX_bvc_Order_UserId' already exists on table 'dbo.bvc_Order'.
(1 row(s) affected)
Creating index [IX_bvc_OrderCoupon_OrderBvin] on [dbo].[bvc_OrderCoupon]
Msg 1913, Level 16, State 1, Line 1
The operation failed because an index or statistics with name 'IX_bvc_OrderCoupon_OrderBvin' already exists on table 'dbo.bvc_OrderCoupon'.
(1 row(s) affected)
Creating index [IX_bvc_OrderPackage_OrderId] on [dbo].[bvc_OrderPackage]
Msg 1913, Level 16, State 1, Line 1
The operation failed because an index or statistics with name 'IX_bvc_OrderPackage_OrderId' already exists on table 'dbo.bvc_OrderPackage'.
(1 row(s) affected)
Creating index [IX_bvc_OrderPayment_OrderId] on [dbo].[bvc_OrderPayment]
Msg 1913, Level 16, State 1, Line 1
The operation failed because an index or statistics with name 'IX_bvc_OrderPayment_OrderId' already exists on table 'dbo.bvc_OrderPayment'.
(1 row(s) affected)
Creating index [bvc_ProductChoiceCombinations_ChoiceId_ChoiceOptionId] on [dbo].[bvc_ProductChoiceCombinations]
Msg 1913, Level 16, State 1, Line 1
The operation failed because an index or statistics with name 'bvc_ProductChoiceCombinations_ChoiceId_ChoiceOptionId' already exists on table 'dbo.bvc_ProductChoiceCombinations'.
(1 row(s) affected)
Creating index [IX_bvc_ProductChoiceOptions_ProductChoiceId] on [dbo].[bvc_ProductChoiceOptions]
Msg 1913, Level 16, State 1, Line 1
The operation failed because an index or statistics with name 'IX_bvc_ProductChoiceOptions_ProductChoiceId' already exists on table 'dbo.bvc_ProductChoiceOptions'.
(1 row(s) affected)
Creating index [IX_bvc_ProductChoices_ProductId] on [dbo].[bvc_ProductChoices]
Msg 1913, Level 16, State 1, Line 1
The operation failed because an index or statistics with name 'IX_bvc_ProductChoices_ProductId' already exists on table 'dbo.bvc_ProductChoices'.
(1 row(s) affected)
Creating index [IX_bvc_ProductModifier_ProductId] on [dbo].[bvc_ProductModifier]
Msg 1913, Level 16, State 1, Line 1
The operation failed because an index or statistics with name 'IX_bvc_ProductModifier_ProductId' already exists on table 'dbo.bvc_ProductModifier'.
(1 row(s) affected)
Creating index [IX_bvc_ProductModifierOption_ModifierId] on [dbo].[bvc_ProductModifierOption]
Msg 1913, Level 16, State 1, Line 1
The operation failed because an index or statistics with name 'IX_bvc_ProductModifierOption_ModifierId' already exists on table 'dbo.bvc_ProductModifierOption'.
(1 row(s) affected)
Creating index [IX_bvc_ProductPropertyChoice_PropertyBvin] on [dbo].[bvc_ProductPropertyChoice]
Msg 1913, Level 16, State 1, Line 1
The operation failed because an index or statistics with name 'IX_bvc_ProductPropertyChoice_PropertyBvin' already exists on table 'dbo.bvc_ProductPropertyChoice'.
(1 row(s) affected)
Creating index [IX_bvc_ProductReview_ProductBvin] on [dbo].[bvc_ProductReview]
Msg 1913, Level 16, State 1, Line 1
The operation failed because an index or statistics with name 'IX_bvc_ProductReview_ProductBvin' already exists on table 'dbo.bvc_ProductReview'.
(1 row(s) affected)
Creating index [IX_bvc_RMA_OrderBvin] on [dbo].[bvc_RMA]
Msg 1913, Level 16, State 1, Line 1
The operation failed because an index or statistics with name 'IX_bvc_RMA_OrderBvin' already exists on table 'dbo.bvc_RMA'.
(1 row(s) affected)
Adding constraints to [dbo].[bvc_Product]
Msg 2714, Level 16, State 4, Line 1
There is already an object named 'IX_bvc_Product_id' in the database.
Msg 1750, Level 16, State 0, Line 1
Could not create constraint. See previous errors.
(1 row(s) affected)
Adding foreign keys to [dbo].[bvc_ProductChoiceCombinations]
Msg 2714, Level 16, State 4, Line 1
There is already an object named 'FK_bvc_ProductChoiceCombinations_bvc_Product' in the database.
Msg 1750, Level 16, State 0, Line 1
Could not create constraint. See previous errors.
(1 row(s) affected)
Adding foreign keys to [dbo].[bvc_ProductInventory]
Msg 2714, Level 16, State 4, Line 1
There is already an object named 'FK_bvc_ProductInventory_bvc_Product' in the database.
Msg 1750, Level 16, State 0, Line 1
Could not create constraint. See previous errors.
(1 row(s) affected)
Adding foreign keys to [dbo].[bvc_ProductPropertyValue]
Msg 2714, Level 16, State 4, Line 1
There is already an object named 'FK_bvc_ProductPropertyValue_bvc_Product' in the database.
Msg 1750, Level 16, State 0, Line 1
Could not create constraint. See previous errors.
(1 row(s) affected)
Adding foreign keys to [dbo].[bvc_ProductXCategory]
Msg 2714, Level 16, State 4, Line 1
There is already an object named 'FK_ProductXCategory_bvc_Product' in the database.
Msg 1750, Level 16, State 0, Line 1
Could not create constraint. See previous errors.
(1 row(s) affected)
Adding foreign keys to [dbo].[bvc_ShippingMethod_CountryRestriction]
Msg 2714, Level 16, State 4, Line 1
There is already an object named 'FK_bvc_ShippingMethod_CountryRestriction_bvc_Country' in the database.
Msg 1750, Level 16, State 0, Line 1
Could not create constraint. See previous errors.
(1 row(s) affected)
Adding foreign keys to [dbo].[bvc_ShippingMethod_RegionRestriction]
Msg 2714, Level 16, State 4, Line 1
There is already an object named 'FK_bvc_ShippingMethod_RegionRestriction_bvc_Region' in the database.
Msg 1750, Level 16, State 0, Line 1
Could not create constraint. See previous errors.
(1 row(s) affected)
The database update failed
[/1]