RandyWang 1 Posted February 21, 2018 Share Posted February 21, 2018 hi 2.Delete all stored procedures, functions, views from your era_db. Use the following sql syntax to delete all stored procedures, functions, views EXEC sp_MSForEachTable 'ALTER TABLE ? NOCHECK CONSTRAINT ALL' declare @sql varchar(max)=''; select @sql=@sql+'DROP VIEW '+name +';' from sys.views; exec(@sql); EXEC sp_MSForEachTable 'ALTER TABLE ? NOCHECK CONSTRAINT ALL' declare @sql varchar(max)=''; select @sql=@sql+'DROP Function '+name +';' from sys.objects o where type='TF'; Exec (@sql); EXEC sp_MSForEachTable 'ALTER TABLE ? NOCHECK CONSTRAINT ALL' declare @sql varchar(max)=''; select @sql=@sql+'DROP PROC '+name +';' from sys.procedures; exec(@sql); but run the script according to your database type. It recreates all stored procedures in era_db,show this message 訊息 2714,層級 16,狀態 3,程序 ufn_uuid_str_to_binary,行 11 There is already an object named 'ufn_uuid_str_to_binary' in the database. 訊息 2714,層級 16,狀態 3,程序 ufn_uuid_str_to_id,行 16 There is already an object named 'ufn_uuid_str_to_id' in the database. 訊息 2714,層級 16,狀態 3,程序 ufn_create_hour_interval,行 4 There is already an object named 'ufn_create_hour_interval' in the database. 訊息 2714,層級 16,狀態 3,程序 ufn_create_day_interval,行 4 There is already an object named 'ufn_create_day_interval' in the database. 訊息 2714,層級 16,狀態 3,程序 ufn_interval_2,行 13 There is already an object named 'ufn_interval_2' in the database. 訊息 2714,層級 16,狀態 3,程序 ufn_interval_4,行 15 There is already an object named 'ufn_interval_4' in the database. 訊息 2714,層級 16,狀態 3,程序 ufn_interval_6,行 17 There is already an object named 'ufn_interval_6' in the database. May be a data table is not deleted? Restoring of the crashed database after upgrade from 6.4 to 6.5 The procedure for debugging should be performed after 6.4 to 6.5 or before upgrading Thank you for your reply Link to comment Share on other sites More sharing options...
Recommended Posts