SET NUMERIC_ROUNDABORT OFF GO SET ANSI_PADDING, ANSI_WARNINGS, CONCAT_NULL_YIELDS_NULL, ARITHABORT, QUOTED_IDENTIFIER, ANSI_NULLS ON GO USE [WebContent] GO EXEC sp_droprolemember N'MSmerge_PAL_role', N'MSmerge_CA8792F2B9BE4A6C9660CDFA3B0B4E6E' GO PRINT N'Dropping constraints from [dbo].[Customer]' GO ALTER TABLE [dbo].[Customer] DROP CONSTRAINT [repl_identity_range_B8179088_FB32_4439_9FFE_1DB1DB6829FC] GO PRINT N'Dropping constraints from [dbo].[Customer]' GO ALTER TABLE [dbo].[Customer] DROP CONSTRAINT [PK__Customer__A4AE64D82CE326F2] GO PRINT N'Dropping constraints from [dbo].[Customer]' GO ALTER TABLE [dbo].[Customer] DROP CONSTRAINT [MSmerge_df_rowguid_D11C92FB69D54C888707917AEF29D080] GO PRINT N'Dropping constraints from [dbo].[Product]' GO ALTER TABLE [dbo].[Product] DROP CONSTRAINT [PK__Product__B40CC6CD3D686EF8] GO PRINT N'Dropping index [MSmerge_index_245575913] from [dbo].[Customer]' GO DROP INDEX [MSmerge_index_245575913] ON [dbo].[Customer] GO PRINT N'Dropping trigger [dbo].[MSmerge_del_B8179088FB3244399FFE1DB1DB6829FC] from [dbo].[Customer]' GO DROP TRIGGER [dbo].[MSmerge_del_B8179088FB3244399FFE1DB1DB6829FC] GO PRINT N'Dropping trigger [dbo].[MSmerge_ins_B8179088FB3244399FFE1DB1DB6829FC] from [dbo].[Customer]' GO DROP TRIGGER [dbo].[MSmerge_ins_B8179088FB3244399FFE1DB1DB6829FC] GO PRINT N'Dropping trigger [dbo].[MSmerge_upd_B8179088FB3244399FFE1DB1DB6829FC] from [dbo].[Customer]' GO DROP TRIGGER [dbo].[MSmerge_upd_B8179088FB3244399FFE1DB1DB6829FC] GO PRINT N'Dropping [dbo].[sp_MSdel_dboProduct]' GO DROP PROCEDURE [dbo].[sp_MSdel_dboProduct] GO PRINT N'Dropping [dbo].[sp_MSupd_dboProduct]' GO DROP PROCEDURE [dbo].[sp_MSupd_dboProduct] GO PRINT N'Dropping [dbo].[sp_MSins_dboProduct]' GO DROP PROCEDURE [dbo].[sp_MSins_dboProduct] GO PRINT N'Altering [dbo].[Customer]' GO ALTER TABLE [dbo].[Customer] ALTER COLUMN [rowguid] DROP ROWGUIDCOL GO ALTER TABLE [dbo].[Customer] ADD [TitleID] [tinyint] NULL GO ALTER TABLE [dbo].[Customer] DROP COLUMN [rowguid] GO ALTER TABLE [dbo].[Customer] ALTER COLUMN [CustomerId] DROP NOT FOR REPLICATION GO PRINT N'Creating primary key [PK__Customer__A4AE64D82CE326F2] on [dbo].[Customer]' GO ALTER TABLE [dbo].[Customer] ADD CONSTRAINT [PK__Customer__A4AE64D82CE326F2] PRIMARY KEY CLUSTERED ([CustomerId]) GO PRINT N'Creating [dbo].[GetCustomer]' GO CREATE PROCEDURE [dbo].[GetCustomer] @CustomerID INTEGER AS SELECT Firstname,Lastname,TitleID FROM dbo.Customer WHERE CustomerID = @CustomerID GO PRINT N'Altering [dbo].[Product]' GO ALTER TABLE [dbo].[Product] ALTER COLUMN [ProductId] DROP NOT FOR REPLICATION GO PRINT N'Creating primary key [PK__Product__B40CC6CDC08944FD] on [dbo].[Product]' GO ALTER TABLE [dbo].[Product] ADD CONSTRAINT [PK__Product__B40CC6CDC08944FD] PRIMARY KEY CLUSTERED ([ProductId]) GO PRINT N'Dropping roles' GO DROP ROLE [MSmerge_PAL_role] GO DROP ROLE [MSmerge_CA8792F2B9BE4A6C9660CDFA3B0B4E6E] GO PRINT N'Dropping schemata' GO DROP SCHEMA [MSmerge_PAL_role] GO /* Start of RedGate SQL Source Control versioning database-level extended properties. */ DECLARE @RG_SC_VERSION BIGINT SET @RG_SC_VERSION = 6 IF EXISTS (SELECT 1 FROM fn_listextendedproperty(N'SQLSourceControl Database Revision', NULL, NULL, NULL, NULL, NULL, NULL)) EXEC sp_dropextendedproperty N'SQLSourceControl Database Revision', NULL, NULL, NULL, NULL, NULL, NULL EXEC sp_addextendedproperty N'SQLSourceControl Database Revision', @RG_SC_VERSION, NULL, NULL, NULL, NULL, NULL, NULL GO IF EXISTS (SELECT 1 FROM fn_listextendedproperty(N'SQLSourceControl Scripts Location', NULL, NULL, NULL, NULL, NULL, NULL)) EXEC sp_dropextendedproperty N'SQLSourceControl Scripts Location', NULL, NULL, NULL, NULL, NULL, NULL EXEC sp_addextendedproperty N'SQLSourceControl Scripts Location', N' file:///C:/Users/BALLY/AppData/Local/Red Gate/SQL Source Control 3/EvaluationRepositories/WebContentDev/WebContentDev/ ', NULL, NULL, NULL, NULL, NULL, NULL GO IF EXISTS (SELECT 1 FROM fn_listextendedproperty(N'SQLSourceControl Migration Scripts Location', NULL, NULL, NULL, NULL, NULL, NULL)) EXEC sp_dropextendedproperty N'SQLSourceControl Migration Scripts Location', NULL, NULL, NULL, NULL, NULL, NULL EXEC sp_addextendedproperty N'SQLSourceControl Migration Scripts Location', N' file:///C:/Users/BALLY/AppData/Local/Red Gate/SQL Source Control 3/EvaluationRepositories/WebContentDev/Migrations/ ', NULL, NULL, NULL, NULL, NULL, NULL GO /* End of RedGate SQL Source Control versioning database-level extended properties. */