以下是enterprise manager处理的脚本(改变表TB_0的字段we的IDENTITY属性)
BEGIN TRANSACTION
SET QUOTED_IDENTIFIER ON
GO
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
GO
COMMIT
BEGIN TRANSACTION
CREATE TABLE dbo.Tmp_TB_0
(
we int NOT NULL IDENTITY (1, 1)
) ON [PRIMARY]
GO
SET IDENTITY_INSERT dbo.Tmp_TB_0 ON
GO
IF EXISTS(SELECT * FROM dbo.TB_0)
EXEC('INSERT INTO dbo.Tmp_TB_0(we)
SELECT we FROM dbo.TB_0 TABLOCKX')
GO
SET IDENTITY_INSERT dbo.Tmp_TB_0 OFF
GO
DROP TABLE dbo.TB_0
GO
EXECUTE sp_rename 'dbo.Tmp_TB_0', 'TB_0'
GO
COMMIT