/*
   quarta-feira, 24 de Março de 20103:52:29
   User: sa
   Server: ELEANOR\ELEANOR
   Database: BeProd_JCL
   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_M05_MovimentosExpedicaoCab
	(
	intIdMovimentoExp int NOT NULL IDENTITY (1, 1),
	dtmDataExpediçao datetime NOT NULL,
	strCodCliente nvarchar(50) NOT NULL,
	strMatricula nvarchar(50) NULL,
	strObs nvarchar(50) NULL,
	strUser nvarchar(50) NOT NULL,
	dtmData datetime NOT NULL,
	StrDocERP nvarchar(50) NULL
	)  ON [PRIMARY]
GO
SET IDENTITY_INSERT dbo.Tmp_M05_MovimentosExpedicaoCab ON
GO
IF EXISTS(SELECT * FROM dbo.M05_MovimentosExpedicaoCab)
	 EXEC('INSERT INTO dbo.Tmp_M05_MovimentosExpedicaoCab (intIdMovimentoExp, dtmDataExpediçao, strCodCliente, strMatricula, strObs, strUser, dtmData, StrDocERP)
		SELECT intIdMovimentoExp, dtmDataExpediçao, strCodCliente, strMatricula, strObs, strUser, dtmData, StrDocERP FROM dbo.M05_MovimentosExpedicaoCab WITH (HOLDLOCK TABLOCKX)')
GO
SET IDENTITY_INSERT dbo.Tmp_M05_MovimentosExpedicaoCab OFF
GO
DROP TABLE dbo.M05_MovimentosExpedicaoCab
GO
EXECUTE sp_rename N'dbo.Tmp_M05_MovimentosExpedicaoCab', N'M05_MovimentosExpedicaoCab', 'OBJECT' 
GO
ALTER TABLE dbo.M05_MovimentosExpedicaoCab ADD CONSTRAINT
	PK_M05_MovimentosExpedicaoCab PRIMARY KEY CLUSTERED 
	(
	intIdMovimentoExp
	) 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.M05_MovimentosExpedicaoCab', 'Object', 'ALTER') as ALT_Per, Has_Perms_By_Name(N'dbo.M05_MovimentosExpedicaoCab', 'Object', 'VIEW DEFINITION') as View_def_Per, Has_Perms_By_Name(N'dbo.M05_MovimentosExpedicaoCab', 'Object', 'CONTROL') as Contr_Per