/*
   2014. október 10.14:09:40
   User: sa
   Server: 81.182.240.255,9137
   Database: aruker_teszt
   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_cikk_leiras
	(
	cikk_szam dbo.cikk_szam NOT NULL,
	leiras1 varchar(2048) NOT NULL,
	leiras2 varchar(2048) NOT NULL
	)  ON [PRIMARY]
GO
ALTER TABLE dbo.Tmp_cikk_leiras SET (LOCK_ESCALATION = TABLE)
GO
IF EXISTS(SELECT * FROM dbo.cikk_leiras)
	 EXEC('INSERT INTO dbo.Tmp_cikk_leiras (cikk_szam, leiras1, leiras2)
		SELECT cikk_szam, leiras1, leiras2 FROM dbo.cikk_leiras WITH (HOLDLOCK TABLOCKX)')
GO
DROP TABLE dbo.cikk_leiras
GO
EXECUTE sp_rename N'dbo.Tmp_cikk_leiras', N'cikk_leiras', 'OBJECT' 
GO
ALTER TABLE dbo.cikk_leiras ADD CONSTRAINT
	PK_cikk_leiras PRIMARY KEY CLUSTERED 
	(
	cikk_szam
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

GO
COMMIT