/* Para evitar posibles problemas de pérdida de datos, debe revisar este script detalladamente antes de ejecutarlo fuera del contexto del diseñador de base de datos.*/ 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.MA_CUENTAS SET (LOCK_ESCALATION = TABLE) GO COMMIT select Has_Perms_By_Name(N'dbo.MA_CUENTAS', 'Object', 'ALTER') as ALT_Per, Has_Perms_By_Name(N'dbo.MA_CUENTAS', 'Object', 'VIEW DEFINITION') as View_def_Per, Has_Perms_By_Name(N'dbo.MA_CUENTAS', 'Object', 'CONTROL') as Contr_Per BEGIN TRANSACTION GO ALTER TABLE dbo.C_MV_Cpte WITH NOCHECK ADD CONSTRAINT FK_C_MV_Cpte_MA_CUENTAS FOREIGN KEY ( CUENTA ) REFERENCES dbo.MA_CUENTAS ( CODIGO ) ON UPDATE NO ACTION ON DELETE NO ACTION GO ALTER TABLE dbo.C_MV_Cpte SET (LOCK_ESCALATION = TABLE) GO COMMIT select Has_Perms_By_Name(N'dbo.C_MV_Cpte', 'Object', 'ALTER') as ALT_Per, Has_Perms_By_Name(N'dbo.C_MV_Cpte', 'Object', 'VIEW DEFINITION') as View_def_Per, Has_Perms_By_Name(N'dbo.C_MV_Cpte', 'Object', 'CONTROL') as Contr_Per