Rj2W6C3a

1/*
2Script created by SQL Compare version 7.1.0 from Red Gate Software Ltd at 4/1/2009 12:02:13 PM
3Run this script on localhost\sqlexpress.CodeCampServerVersioned to make it the same as localhost\sqlexpress.CodeCampServer
4Please back up your database before running this script
5*/
6SET NUMERIC_ROUNDABORT OFF
7GO
8SET ANSI_PADDING, ANSI_WARNINGS, CONCAT_NULL_YIELDS_NULL, ARITHABORT, QUOTED_IDENTIFIER, ANSI_NULLS ON
9GO
10IF EXISTS (SELECT * FROM tempdb..sysobjects WHERE id=OBJECT_ID('tempdb..#tmpErrors')) DROP TABLE #tmpErrors
11GO
12CREATE TABLE #tmpErrors (Error int)
13GO
14SET XACT_ABORT ON
15GO
16SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
17GO
18BEGIN TRANSACTION
19GO
20PRINT N'Altering [dbo].[Users]'
21GO
22ALTER TABLE [dbo].[Users] DROP
23COLUMN [UserGroupId]
24GO
25IF @@ERROR<>0 AND @@TRANCOUNT>0 ROLLBACK TRANSACTION
26GO
27IF @@TRANCOUNT=0 BEGIN INSERT INTO #tmpErrors (Error) SELECT 1 BEGIN TRANSACTION END
28GO
29PRINT N'Creating [dbo].[UserGroupAdminUsers]'
30GO
31CREATE TABLE [dbo].[UserGroupAdminUsers]
32(
33[UserGroupId] [uniqueidentifier] NOT NULL,
34[UserID] [uniqueidentifier] NOT NULL
35) ON [PRIMARY]
36GO
37IF @@ERROR<>0 AND @@TRANCOUNT>0 ROLLBACK TRANSACTION
38GO
39IF @@TRANCOUNT=0 BEGIN INSERT INTO #tmpErrors (Error) SELECT 1 BEGIN TRANSACTION END
40GO
41IF EXISTS (SELECT * FROM #tmpErrors) ROLLBACK TRANSACTION
42GO
43IF @@TRANCOUNT>0 BEGIN
44PRINT 'The database update succeeded'
45COMMIT TRANSACTION
46END
47ELSE PRINT 'The database update failed'
48GO
49DROP TABLE #tmpErrors
50GO