Description |
*Database:* 01
01:57:10 PM - Warning SQL72015: The column [dbo].[tblSMUserSecurityMenuFavorite].[intUserSecurityId] is being dropped, data loss could occur.
01:57:10 PM - Warning SQL72030: If this deployment is executed, changes to [dbo].[tblEMEntityCredential] might introduce run-time errors in [dbo].[vyuPOSGetLoggedIn].
01:57:10 PM - Warning SQL72030: If this deployment is executed, changes to [dbo].[fnAESDecryptASym] might introduce run-time errors in [dbo].[uspEMImportEmployees].
01:57:10 PM - Warning SQL72030: If this deployment is executed, changes to [dbo].[fnAESEncryptASym] might introduce run-time errors in [dbo].[uspEMImportEmployees].
01:57:10 PM - Warning SQL72030: If this deployment is executed, changes to [dbo].[fnAESEncryptASym] might introduce run-time errors in [dbo].[uspEMImportCustomerEFTInfo].
01:57:10 PM - Warning SQL72030: If this deployment is executed, changes to [dbo].[uspARCreateCustomerInvoice] might introduce run-time errors in [dbo].[uspARImportInvoiceCSV].
01:57:10 PM - Warning SQL72030: If this deployment is executed, changes to [dbo].[uspARCreatePrePayment] might introduce run-time errors in [dbo].[uspARImportPayments].
01:57:10 PM - Warning SQL72030: If this deployment is executed, changes to [dbo].[uspARPostInvoice] might introduce run-time errors in [dbo].[uspTRProcessToInvoice].
01:57:10 PM - Error SQL72014: .Net SqlClient Data Provider: Msg 8134, Level 16, State 1, Line 9 Divide by zero error encountered.
01:57:10 PM - Error SQL72045: Script execution error. The executed script:
01:57:10 PM - PRINT 'BEGIN POST DEPLOYMENT';
01:57:10 PM - IF NOT EXISTS (SELECT TOP 1 1
01:57:10 PM - FROM sys.certificates
01:57:10 PM - WHERE name = 'i21EncryptionCert')
01:57:10 PM - BEGIN
01:57:10 PM - EXECUTE ('
01:57:10 PM - CREATE CERTIFICATE i21EncryptionCert
01:57:10 PM - ENCRYPTION BY PASSWORD = ''neYwLw+SCUq84dAAd9xuM1AFotK5QzL4Vx4VjYUemUY=''
01:57:10 PM - WITH SUBJECT = ''i21 Encryption Certificate''
01:57:10 PM - ');
01:57:10 PM - END
01:57:10 PM - IF NOT EXISTS (SELECT TOP 1 1
01:57:10 PM - FROM sys.symmetric_keys
01:57:10 PM - WHERE name = 'i21EncryptionSymKey')
01:57:10 PM - BEGIN
01:57:10 PM - EXECUTE ('
01:57:10 PM - CREATE SYMMETRIC KEY i21EncryptionSymKey
01:57:10 PM - WITH ALGORITHM = AES_256
01:57:10 PM - ENCRYPTION BY CERTIFICATE i21EncryptionCert
01:57:10 PM - ');
01:57:10 PM - END
01:57:10 PM - IF NOT EXISTS (SELECT TOP 1 1
01:57:10 PM - FROM sys.asymmetric_keys
01:57:10 PM - WHERE name = 'i21EncryptionASymKeyPwd')
01:57:10 PM - BEGIN
01:57:10 PM - EXECUTE ('
01:57:10 PM - CREATE ASYMMETRIC KEY i21EncryptionASymKeyPwd
01:57:10 PM - WITH ALGORITHM = RSA_2048
01:57:10 PM - ENCRYPTION BY PASSWORD = ''neYwLw+SCUq84dAAd9xuM1AFotK5QzL4Vx4VjYUemUY=''
01:57:10 PM - ');
01:57:10 PM - END
01:57:10 PM - IF
FINISH RUNNING SCRIPTS FOR DEV183001
|