/*
   2014. december 18.9:56:11
   User: sa
   Server: 192.168.59.120,1450
   Database: aruker
   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_vevoarak
	(
	cikk_szam dbo.cikk_szam NOT NULL,
	datum dbo.datum NOT NULL,
	vdatum dbo.datum NOT NULL,
	vevo dbo.kulcs NOT NULL,
	egyseg_ar dbo.egyseg_ar NOT NULL,
	arcsoport dbo.kulcs NOT NULL
	)  ON [PRIMARY]
GO
ALTER TABLE dbo.Tmp_vevoarak SET (LOCK_ESCALATION = TABLE)
GO
IF EXISTS(SELECT * FROM dbo.vevoarak)
	 EXEC('INSERT INTO dbo.Tmp_vevoarak (cikk_szam, datum, vdatum, vevo, egyseg_ar)
		SELECT cikk_szam, datum, vdatum, vevo, egyseg_ar FROM dbo.vevoarak WITH (HOLDLOCK TABLOCKX)')
GO
DROP TABLE dbo.vevoarak
GO
EXECUTE sp_rename N'dbo.Tmp_vevoarak', N'vevoarak', 'OBJECT' 
GO
ALTER TABLE dbo.vevoarak ADD CONSTRAINT
	PK_vevoarak PRIMARY KEY CLUSTERED 
	(
	cikk_szam,
	datum,
	vdatum,
	vevo,
	arcsoport
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

GO
COMMIT
go

insert into verzio values('upg','Ver. 2.05',dbo.mygetdatetime())
go