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_TableTest
(
field1 nvarchar(50) NULL,
FieldText ntext NOT NULL
) ON [PRIMARY]
TEXTIMAGE_ON [PRIMARY]
GO
IF EXISTS(SELECT * FROM dbo.TableTest)
EXEC('INSERT INTO dbo.Tmp_TableTest (field1, FieldText)
SELECT field1, FieldText FROM dbo.TableTest TABLOCKX')
GO
DROP TABLE dbo.TableTest
GO
EXECUTE sp_rename N'dbo.Tmp_TableTest', N'TableTest', 'OBJECT'
GO
COMMIT