Error en transaccion

Hola,
quisiera que me ayudaran con el siguiente script que me funciona bien
para sql server 2005 pero no funciona en 2000,

el error que saca es
mens 170, nivel 15, estado 1, linea 5
linea 5: sintaxis incorrecta cerca de ' ( '

USE database

BEGIN TRANSACTION
SET QUOTED_IDENTIFIER ON
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
GO
ALTER TABLE dbo.svmpactivity
DROP CONSTRAINT DF__svmpactiv__idmap__29CC2871
GO
ALTER TABLE dbo.svmpactivity
DROP CONSTRAINT DF__svmpactiv__index__2AC04CAA
GO
ALTER TABLE dbo.svmpactivity
DROP CONSTRAINT DF__svmpactivi__name__2BB470E3
GO
ALTER TABLE dbo.svmpactivity
DROP CONSTRAINT DF__svmpactiv__owner__2CA8951C
GO
CREATE TABLE dbo.Tmp_svmpactivity
(
id int NOT NULL IDENTITY (1, 1),
idmap int NOT NULL,
version int NOT NULL,
[index] int NOT NULL,
name varchar(100) NOT NULL,
owner int NOT NULL,
description text NULL
) ON [PRIMARY]
TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE dbo.Tmp_svmpactivity ADD CONSTRAINT
DF__svmpactiv__idmap__29CC2871 DEFAULT ('0') FOR idmap
GO
ALTER TABLE dbo.Tmp_svmpactivity ADD CONSTRAINT
DF__svmpactiv__index__2AC04CAA DEFAULT ('0') FOR [index]
GO
ALTER TABLE dbo.Tmp_svmpactivity ADD CONSTRAINT
DF__svmpactivi__name__2BB470E3 DEFAULT ('') FOR name
GO
ALTER TABLE dbo.Tmp_svmpactivity ADD CONSTRAINT
DF__svmpactiv__owner__2CA8951C DEFAULT ('1') FOR owner
GO
SET IDENTITY_INSERT dbo.Tmp_svmpactivity ON
GO
IF EXISTS(SELECT * FROM dbo.svmpactivity)
EXEC('INSERT INTO dbo.Tmp_svmpactivity (id, idmap, [index], name,
owner, description)
SELECT id, idmap, [index], name, owner, description FROM
dbo.svmpactivity WITH (HOLDLOCK TABLOCKX)')
GO
SET IDENTITY_INSERT dbo.Tmp_svmpactivity OFF
GO
DROP TABLE dbo.svmpactivity
GO
EXECUTE sp_rename N'dbo.Tmp_svmpactivity', N'svmpactivity', 'OBJECT'
GO
ALTER TABLE dbo.svmpactivity ADD CONSTRAINT
PK__svmpactivity__28D80438 PRIMARY KEY CLUSTERED
(
id
) WITH( PAD_INDEX = OFF, FILLFACTOR = 90, STATISTICS_NORECOMPUTE > OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS > ON) ON [PRIMARY]

GO
COMMIT