Was there another error? Because the script creates that temp sp on line 3451:
--update [sename] column for product tags IF EXISTS ( SELECT * FROM sysobjects WHERE id = OBJECT_ID(N'[temp_generate_sename]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1) DROP PROCEDURE [temp_generate_sename] GO CREATE PROCEDURE [temp_generate_sename] ...
This error: Could not find stored procedure 'dbo.temp_generate_sename'. occurs for some people because the procedure is not necessarily created using the default schema.
This code in the upgrade.sql:
CREATE PROCEDURE [temp_generate_sename]
Should be:
CREATE PROCEDURE [dbo].[temp_generate_sename]
From this line onwards the procedure is referance as
[dbo].[temp_generate_sename]
In my case the procedure was generated under a local user schema because of my sql setup.
This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.
Vous avez encore des questions ou avez besoin d'aide?