﻿--Migration
SET ANSI_NULLS, ANSI_PADDING, ANSI_WARNINGS, ARITHABORT, CONCAT_NULL_YIELDS_NULL, QUOTED_IDENTIFIER ON;
SET NUMERIC_ROUNDABORT OFF;
GO

ALTER TABLE [dbo].[T_ALKALMAZOTT]
    ADD [C_ISKOZPONTILAGSZINKRONIZALT] CHAR (1) DEFAULT ('F') NOT NULL;
GO

EXEC dev.uspCreateSchemaViews 'T_ALKALMAZOTT';
GO

ALTER QUEUE auditlog.AuditQueue
WITH 
    STATUS = ON , 
    RETENTION = OFF , 
    ACTIVATION (
        STATUS = ON , 
        PROCEDURE_NAME = auditlog.usp_AuditProcessing, 
        MAX_QUEUE_READERS = 10, 
        EXECUTE AS N'kreta_tech_user'
    ), 
    POISON_MESSAGE_HANDLING (STATUS = ON);
GO
