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_testTabelle
	(
	TestSpalte nvarchar(150) COLLATE Latin1_General_CS_AS NULL
	)  ON [PRIMARY]
GO
IF EXISTS(SELECT * FROM dbo.testTabelle)
	 EXEC('INSERT INTO dbo.Tmp_testTabelle (TestSpalte)
		SELECT TestSpalte FROM dbo.testTabelle TABLOCKX')
GO
DROP TABLE dbo.testTabelle
GO
EXECUTE sp_rename N'dbo.Tmp_testTabelle', N'testTabelle', 'OBJECT'
GO
COMMIT

Gru?

Markus
____________________________________
VB, SQL, Access, VBA, HTML, PHP, JavaScript