/*
   terça-feira, 31 de Agosto de 201017:32:24
   User: sa
   Server: ELEANOR\ELEANOR
   Database: BeProd_000
   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_Mov_SSCC_Cab
	(
	IntId int NOT NULL IDENTITY (1, 1),
	StrSSCC nvarchar(50) NULL,
	StrCodObra nvarchar(50) NULL,
	StrCodArtigo nvarchar(50) NULL,
	StrDescArtigo nvarchar(MAX) NULL,
	FltQtdInicial float(53) NULL,
	FltQtdActual float(53) NULL,
	FltArea float(53) NULL,
	FltPeso float(53) NULL,
	IntIdCabRecepcao int NULL,
	DtmDataEntrada datetime NULL,
	StrUser nvarchar(50) NULL,
	StrUltimaTarefa nvarchar(50) NULL,
	StrEstado nvarchar(100) NULL,
	StrDocExpedicao nvarchar(50) NULL,
	DtmDataExpedicao datetime NULL,
	StrUserExpedicao nvarchar(50) NULL,
	DtmDataRegisto datetime NOT NULL,
	StrUserRegisto nvarchar(50) NOT NULL,
	DtmDataAlteracao datetime NULL,
	StrUserAlteracao nvarchar(50) NULL
	)  ON [PRIMARY]
	 TEXTIMAGE_ON [PRIMARY]
GO
SET IDENTITY_INSERT dbo.Tmp_Mov_SSCC_Cab ON
GO
IF EXISTS(SELECT * FROM dbo.Mov_SSCC_Cab)
	 EXEC('INSERT INTO dbo.Tmp_Mov_SSCC_Cab (IntId, StrSSCC, StrCodObra, StrCodArtigo, StrDescArtigo, FltQtdInicial, FltQtdActual, FltArea, FltPeso, DtmDataEntrada, StrUser, StrUltimaTarefa, StrEstado, StrDocExpedicao, DtmDataExpedicao, StrUserExpedicao, DtmDataRegisto, StrUserRegisto, DtmDataAlteracao, StrUserAlteracao)
		SELECT IntId, StrSSCC, StrCodObra, StrCodArtigo, StrDescArtigo, FltQtdInicial, FltQtdActual, FltArea, FltPeso, DtmDataEntrada, StrUser, StrUltimaTarefa, StrEstado, StrDocExpedicao, DtmDataExpedicao, StrUserExpedicao, DtmDataRegisto, StrUserRegisto, DtmDataAlteracao, StrUserAlteracao FROM dbo.Mov_SSCC_Cab WITH (HOLDLOCK TABLOCKX)')
GO
SET IDENTITY_INSERT dbo.Tmp_Mov_SSCC_Cab OFF
GO
DROP TABLE dbo.Mov_SSCC_Cab
GO
EXECUTE sp_rename N'dbo.Tmp_Mov_SSCC_Cab', N'Mov_SSCC_Cab', 'OBJECT' 
GO
ALTER TABLE dbo.Mov_SSCC_Cab ADD CONSTRAINT
	PK_Mov_SSCC_Cab PRIMARY KEY CLUSTERED 
	(
	IntId
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

GO
COMMIT
select Has_Perms_By_Name(N'dbo.Mov_SSCC_Cab', 'Object', 'ALTER') as ALT_Per, Has_Perms_By_Name(N'dbo.Mov_SSCC_Cab', 'Object', 'VIEW DEFINITION') as View_def_Per, Has_Perms_By_Name(N'dbo.Mov_SSCC_Cab', 'Object', 'CONTROL') as Contr_Per