Microsoft KB Archive/326755

= INFO: If You Change Commerce Server Stored Procedures, the Installation Is No Longer Supported =

Article ID: 326755

Article Last Modified on 9/24/2003

-

APPLIES TO


 * Microsoft Commerce Server 2002 Standard Edition
 * Microsoft Commerce Server 2000 Standard Edition

-



This article was previously published under Q326755



SUMMARY
If you change any stored procedures that Commerce Server 2000 or 2002 sets up, you put the whole installation in an unsupported state. If you have to have technical support, and you have customized the installation, it may be determined that Microsoft cannot provide support.

There are many reasons that Microsoft does not support this practice. To customize the product can have varying results that range from making the product unstable only under specific conditions, to breaking Commerce Server completely. Another important note is that when a service pack updates a stored procedure, the newer copy overwrites the customized stored procedure, which removes any customizations. Also, if you experience problems because of changes that you have made to stored procedures, Microsoft Product Support Services cannot help you to make any additional changes to restore the product to its original state.

Additional query words: plutonium proc_delete_pupdbscript proc_insert_pupdbscript proc_select_pupdbscript OrderSummaryProc sp_AddCatalogDefinitionProperty sp_AddPricingCategory sp_AddRelationship sp_AddVariant sp_AlterCatalogAttributes sp_AlterClassTypesToProduct sp_AlterClassTypesToProductFamily sp_AlterPropertyInFullTextTables sp_AlterPropertyLength sp_camp_item_archive sp_CheckCatalog sp_CheckDeleteExpr sp_CheckExprExprDeps sp_CheckExprStore sp_clean_archived_campaigns sp_clean_delete_campaign sp_clean_delete_campitem sp_clean_delete_customer sp_CreateCatalogProcedures sp_CreateFullTextCatalog sp_CreateProperty sp_CreateTriggers sp_cs_campitem_add sp_cs_campitem_delete sp_cs_campitem_update sp_cs_mail_add sp_cs_mail_delete sp_cs_mail_schedid sp_cs_mail_update sp_DelDataMember sp_DelDataObject sp_DelDataSource sp_DeleteAllCatalogs sp_DeleteCampaign sp_DeleteCampaignItem sp_DeleteCatalog sp_DeleteCatalogDefinition sp_DeleteCustomer sp_DeleteGlobalData sp_DelProfile sp_DelProfileCatalog sp_DelProfileGroup sp_DelProfileGroupHelper sp_DelProfileHelper sp_DelProfileProperty sp_DelProfilePropHelper sp_dm_item_delete sp_dm_item_edit sp_dm_item_new sp_DropAllFullTextCatalogs sp_DropCatalogProcedures sp_DropFullTextCatalog sp_EnsureEmptyStore sp_ExprIDFromName sp_ExprNameFromID sp_GenerateFullTextIndexesForImport sp_GetAncestorCategories sp_GetBaseCatalogName sp_GetCampItemGUID sp_GetCatalogsInCatalogSet sp_GetCategoryProperties sp_GetCustomPrice sp_GetDataSourceDepends sp_GetDataSourceInfo sp_getDefinitionProperties sp_GetDescendantProducts sp_GetDescendantProducts_for_CustomPricing sp_GetExprInfo sp_gethierarchy sp_GetProductProperties sp_GetProductsForCatalog sp_GetProductsForCSVExport sp_GetProductsForExport sp_GetProductVariantProperties sp_GetProfileCatalogInfo sp_GetProfileCatalogs sp_GetProfileDomains sp_GetProfileInfo sp_GetProfileMemAttrs sp_GetProfileMember sp_GetProfileProps sp_GetProfileSources sp_GetPropertiesForCatalog sp_GetResults sp_GetResults_for_AllColumns sp_GetRootCategories sp_GetShippingRateProc sp_getSQLVersion sp_GetSuccessfulCatalogs sp_ImportExprInfo sp_InsertAdItem sp_InsertCampaign sp_InsertCampaignItem sp_InsertCatalogGlobal sp_InsertCatalogsBeingExported sp_InsertCatalogStatus sp_InsertCPValue sp_InsertCreative sp_InsertCustomCatalog sp_InsertCustomCatalogInCatalogGlobal sp_InsertCustomer sp_InsertCustomPrice sp_InsertDefinition sp_InsertDefinitionProperties sp_InsertDiscount sp_InsertDiscountMisc sp_InsertEnumValues sp_InsertHierarchy sp_InsertPageGroup sp_InsertPageGroupMain sp_InsertTargetGroup sp_InsertTargetGroupMain sp_InsertTargetMain sp_InsertUsedDefinition sp_IsCatalogPresent sp_IsCatalogPropertyRemovable sp_IsCustomCatalogPresent sp_IsDefinitionPresent sp_IsDefinitionPropPresent sp_IsDefinitionUsedInCatalog sp_IsEnumPresent sp_IsFamilyDefinition sp_IsProductvalid sp_IsPropertyPresent sp_IsPropertyPresentInDefinition sp_IsPropertyUID sp_IsPropertyUsedInDefinition sp_RemoveDefinitionFromCatalog sp_RemoveRelationship sp_RenameCatalogDefinition sp_RenameCatalogProperty sp_RenameExpr sp_SpecSearch sp_UndeleteCampaign sp_UndeleteCampaignItem sp_UndeleteCustomer sp_update_performance_total sp_update_vdir sp_UpdateAdItem sp_UpdateCampaign sp_UpdateCampaignItem sp_UpdateCreative sp_UpdateCustomer sp_UpdateDiscount sp_UpdateDiscountMisc sp_UpdateExprModDate sp_UpdateFreeTextSearchTables sp_UpdateFreeTextSearchTables2000 sp_UpdateTargetGroupMain sp_UpdateTargetMain

Keywords: kbinfo kbfix kbnofix KB326755

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.