/*
   10 de outubro de 201812:49:02
   User: betrace
   Server: DEVSERVER\SQLEVOLUTION
   Database: BeProd_PLAS
   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
CREATE TABLE dbo.Tmp_Tbl_Series_OF
	(
	intID int NOT NULL IDENTITY (1, 1),
	strCodOF varchar(50) NOT NULL,
	strDescricaoOF varchar(80) NOT NULL
	)  ON [PRIMARY]
GO
ALTER TABLE dbo.Tmp_Tbl_Series_OF SET (LOCK_ESCALATION = TABLE)
GO
SET IDENTITY_INSERT dbo.Tmp_Tbl_Series_OF ON
GO
IF EXISTS(SELECT * FROM dbo.Tbl_Series_OF)
	 EXEC('INSERT INTO dbo.Tmp_Tbl_Series_OF (intID, strCodOF, strDescricaoOF)
		SELECT intID, strCodOF, strDescricaoOF FROM dbo.Tbl_Series_OF WITH (HOLDLOCK TABLOCKX)')
GO
SET IDENTITY_INSERT dbo.Tmp_Tbl_Series_OF OFF
GO
DROP TABLE dbo.Tbl_Series_OF
GO
EXECUTE sp_rename N'dbo.Tmp_Tbl_Series_OF', N'Tbl_Series_OF', 'OBJECT' 
GO
COMMIT
select Has_Perms_By_Name(N'dbo.Tbl_Series_OF', 'Object', 'ALTER') as ALT_Per, Has_Perms_By_Name(N'dbo.Tbl_Series_OF', 'Object', 'VIEW DEFINITION') as View_def_Per, Has_Perms_By_Name(N'dbo.Tbl_Series_OF', 'Object', 'CONTROL') as Contr_Per