﻿PRINT N'Altering Table [dbo].[T_FELHASZNALO]...';


GO
ALTER TABLE [dbo].[T_FELHASZNALO]
    ADD [C_ANYJANEVEELOTAG]    NVARCHAR (20) NULL,
        [C_SZULETESINEVELOTAG] NVARCHAR (20) NULL;


GO
PRINT N'Altering Table [dbo].[T_TANITASIORA]...';


GO
ALTER TABLE [dbo].[T_TANITASIORA]
    ADD [C_EVESORASZAM] INT NULL;


GO

EXECUTE dev.uspCreateSchemaViews 'T_FELHASZNALO, T_TANITASIORA'
EXECUTE dev.sp_Global_GenerateAsyncAuditTriggerAll
GO

ALTER QUEUE auditLog.[AuditQueue]
WITH ACTIVATION 
(
  STATUS =  ON,
  PROCEDURE_NAME =  auditLog.usp_AuditProcessing,
  MAX_QUEUE_READERS =  2,
  EXECUTE AS 'Kreta_tech_user'
);
GO

PRINT N'Update complete.';

GO