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_tbl
	(
	fld0 int NOT NULL,
	fld1 varchar( 50 ) NULL
	)  ON [PRIMARY]
GO
IF EXISTS(SELECT * FROM dbo.tbl)
	 EXEC('INSERT INTO dbo.Tmp_tbl (fld0, fld1)
		SELECT fld0, fld1 FROM dbo.tbl TABLOCKX')
GO
DROP TABLE dbo.tbl
GO
EXECUTE sp_rename N'dbo.Tmp_tbl', N'tbl', 'OBJECT'
GO
COMMIT