/* 17 de dezembro de 202415:26:44 User: sa Server: SCR-DEV\MSSQL22 Database: BeProd_REIMAN_Debug Application: */ /* To prevent any potential data loss issues, you should review this script in detail before running it outside the context of the database designer.*/ BEGIN TRANSACTION SET QUOTED_IDENTIFIER ON SET ARITHABORT ON SET NUMERIC_ROUNDABORT OFF SET CONCAT_NULL_YIELDS_NULL ON SET ANSI_NULLS ON SET ANSI_PADDING ON SET ANSI_WARNINGS ON COMMIT BEGIN TRANSACTION GO ALTER TABLE dbo.Mov_SSCC_Printed_x64 ADD intVolume int NOT NULL CONSTRAINT DF_Mov_SSCC_Printed_x64_intVolume DEFAULT 1, intTotalVolumes int NOT NULL CONSTRAINT DF_Mov_SSCC_Printed_x64_intTotalVolumes DEFAULT 1 GO ALTER TABLE dbo.Mov_SSCC_Printed_x64 SET (LOCK_ESCALATION = TABLE) GO COMMIT select Has_Perms_By_Name(N'dbo.Mov_SSCC_Printed_x64', 'Object', 'ALTER') as ALT_Per, Has_Perms_By_Name(N'dbo.Mov_SSCC_Printed_x64', 'Object', 'VIEW DEFINITION') as View_def_Per, Has_Perms_By_Name(N'dbo.Mov_SSCC_Printed_x64', 'Object', 'CONTROL') as Contr_Per