Description |
*This issue relates to i21 Help Desk ticket:* [ HDTN-273096 - Customer Upgrade 01,99, TE to 22.12.0412.952|https://helpdesk.irely.com/iRelyi21live/#/HD/Ticket/?ticket=HDTN-273096]
* *** Could not deploy package.
* Error SQL72014: .Net SqlClient Data Provider: Msg 547, Level 16, State 0, Line 1 The DELETE statement conflicted with the REFERENCE constraint "FK_tblTFTerminalControlNumber_tblTFTaxAuthority". The conflict occurred in database "testTE", table "dbo.tblTFTerminalControlNumber", column 'intTaxAuthorityId'.
* Error SQL72045: Script execution error. The executed script:
* IF (ISNULL(CAST (SERVERPROPERTY('ProductMajorVersion') AS INT), 0) >= 15)
* BEGIN
* PRINT 'START: SET SCALAR UDF INLINING TO OFF';
* EXECUTE ('ALTER DATABASE SCOPED CONFIGURATION SET TSQL_SCALAR_UDF_INLINING = OFF');
* PRINT 'END: SET SCALAR UDF INLINING TO OFF';
* END
* GO
* PRINT 'Create a temp recur procedure';
* IF EXISTS (SELECT *
* FROM sys.objects
* WHERE type = 'P'
* AND name = 'uspTempRecur')
* BEGIN
* EXECUTE ('DROP PROCEDURE uspTempRecur');
* END
* EXECUTE ('
* CREATE PROCEDURE uspTempRecur
* @ObjectName NVARCHAR(MAX)
* AS
* BEGIN
* set nocount on
* DECLARE @ObjectList TABLE(
* name nvarchar(max)
* )
* DECLARE @CurrentObject NVARCHAR(MAX)
* insert into @ObjectList
* select distinct o.name as ObjName
* from sys.sql_dependencies d
* join sys.objects o on o.object_id=d.object_id
* join sys.objects r on r.object_id=d.referenced_major_id
* where d.class=1
* AND r.name = @ObjectName
* while exists(select top 1 1 fr
|