BEGIN TRANSACTION
SET QUOTED_IDENTIFIER ON
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
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
CREATE TABLE dbo.Tmp_t_Tabelle
	(
	PK int NOT NULL IDENTITY (1, 1),
	Felda char(10) NULL,
	Feldb char(10) NULL
	)  ON [PRIMARY]
GO
SET IDENTITY_INSERT dbo.Tmp_t_Tabelle ON
GO
IF EXISTS(SELECT * FROM dbo.t_Tabelle)
	 EXEC('INSERT INTO dbo.Tmp_t_Tabelle (PK, Felda, Feldb)
		SELECT PK, Felda, Feldb FROM dbo.t_Tabelle TABLOCKX')
GO
SET IDENTITY_INSERT dbo.Tmp_t_Tabelle OFF
GO
DROP TABLE dbo.t_Tabelle
GO
EXECUTE sp_rename N'dbo.Tmp_t_Tabelle', N't_Tabelle', 'OBJECT'
GO
COMMIT

Cu

Wolfgang