How to roll back an upgrade from Microsoft Business Solutions CRM 1.2 to Microsoft Dynamics CRM 3.0

--BEGIN SCRIPT--
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ASReplicationObjects]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[ASReplicationObjects]
GO
 
CREATE TABLE ASReplicationObjects
(
            name sysname,
            type char(2), 
            crdate datetime
)
 
DECLARE @objectName sysname
DECLARE @objectType sysname
 
DECLARE @sqlStatement nvarchar(1024)
DECLARE @sqlStatementBegin sysname
DECLARE @sqlStatementAndType sysname
DECLARE @sqlStatementDropTrigger sysname
DECLARE @sqlStatementDropProcedure sysname
DECLARE @sqlStatementDropView sysname
DECLARE @sqlStatementDropTable sysname
 
SET @sqlStatementBegin = N'IF EXISTS (SELECT name FROM sysobjects WHERE name = N'''
SET @sqlStatementAndType = N''' AND type=N'''
SET @sqlStatementDropTrigger = N''') DROP TRIGGER '
SET @sqlStatementDropProcedure = N''') DROP PROCEDURE '
SET @sqlStatementDropView = N''') DROP VIEW '
SET @sqlStatementDropTable = N''') DROP TABLE '
 
 
-- Delete triggers           
SET @objectType = N'TR'
insert into ASReplicationObjects 
select name, type, crdate from sysobjects where (type=@objectType)  and 
            (name like N'del_%' or name like N'ins_%'  or name like N'upd_%' ) 
            order by name
 
select count(*) from ASReplicationObjects as CountTriggers  -- debug
 
DECLARE trigger_cursor CURSOR FOR 
SELECT name FROM ASReplicationObjects WHERE type = @objectType
 
OPEN trigger_cursor
FETCH NEXT FROM trigger_cursor INTO @objectName
WHILE @@FETCH_STATUS = 0
BEGIN
   SET @sqlStatement =            @sqlStatementBegin + @objectName + @sqlStatementAndType +@objectType + @sqlStatementDropTrigger + @objectName
   PRINT @sqlStatement
   EXEC sp_executesql @stmt = @sqlStatement
   FETCH NEXT FROM trigger_cursor INTO @objectName
END
 
CLOSE trigger_cursor
DEALLOCATE trigger_cursor
 
DELETE ASReplicationObjects
 
-- Delete stored procedures       
SET @objectType = N'P'
insert into ASReplicationObjects 
select name, type, crdate from sysobjects where (type =@objectType)  and 
            (name like N'sp_cft_%' or name like N'sp_ins_%' or name like N'sp_sel_%' or name like N'sp_upd_%' or name like N'sel_%') 
            order by name
 
select count(*) from ASReplicationObjects as CountStoredProcedures_cft_ins_sel_upd   -- debug
 
DECLARE storproc_cursor CURSOR FOR 
SELECT name FROM ASReplicationObjects WHERE type = @objectType
 
OPEN storproc_cursor
FETCH NEXT FROM storproc_cursor INTO @objectName
WHILE @@FETCH_STATUS = 0
BEGIN
   SET @sqlStatement =            @sqlStatementBegin + @objectName + @sqlStatementAndType +@objectType + @sqlStatementDropProcedure + @objectName
   PRINT @sqlStatement
   EXEC sp_executesql @stmt = @sqlStatement
   FETCH NEXT FROM storproc_cursor INTO @objectName
END
 
CLOSE storproc_cursor
DEALLOCATE storproc_cursor
 
DELETE ASReplicationObjects
 
-- delete sp like %xpand_% . 53 sp for each Replication setup. - Done below
SET @objectType = N'P'
insert into ASReplicationObjects 
select name, type, crdate from sysobjects where (type =@objectType)  and 
            (name like N'%xpand_%' or name like N'%p_cft_%') 
            order by name
 
select count(*) from ASReplicationObjects as CountStoredProceduresLikeExpand  -- debug
 
DECLARE storproc_cursor2 CURSOR FOR 
SELECT name FROM ASReplicationObjects WHERE type = @objectType
 
OPEN storproc_cursor2
FETCH NEXT FROM storproc_cursor2 INTO @objectName
WHILE @@FETCH_STATUS = 0
BEGIN
   SET @sqlStatement =            @sqlStatementBegin + @objectName + @sqlStatementAndType +@objectType + @sqlStatementDropProcedure + @objectName
   PRINT @sqlStatement
   EXEC sp_executesql @stmt = @sqlStatement
   FETCH NEXT FROM storproc_cursor2 INTO @objectName
END
 
CLOSE storproc_cursor2
DEALLOCATE storproc_cursor2
 
DELETE ASReplicationObjects
 
-- Delete views  
SET @objectType = N'V'
insert into ASReplicationObjects 
select name, type, crdate from sysobjects where (type='V')  and 
            (name like N'ctsv_%' or name like N'tsvw_%' ) 
            order by name
 
select count(*) from ASReplicationObjects as CountViews  -- debug
 
DECLARE view_cursor CURSOR FOR 
SELECT name FROM ASReplicationObjects WHERE type = @objectType
 
OPEN view_cursor
FETCH NEXT FROM view_cursor INTO @objectName
WHILE @@FETCH_STATUS = 0
BEGIN
   SET @sqlStatement =            @sqlStatementBegin + @objectName + @sqlStatementAndType +@objectType + @sqlStatementDropView + @objectName
   PRINT @sqlStatement
   EXEC sp_executesql @stmt = @sqlStatement
   FETCH NEXT FROM view_cursor INTO @objectName
END
 
CLOSE view_cursor
DEALLOCATE view_cursor
 
DELETE ASReplicationObjects
 
-- Delete tables  
SET @objectType = N'U'
insert into ASReplicationObjects 
select name, type, crdate from sysobjects where (type='U')  and 
            (name like N'%onflict_%' ) 
            order by name
 
select count(*) from ASReplicationObjects as CountTables  -- debug
 
DECLARE table_cursor CURSOR FOR 
SELECT name FROM ASReplicationObjects WHERE type = @objectType
 
OPEN table_cursor
FETCH NEXT FROM table_cursor INTO @objectName
WHILE @@FETCH_STATUS = 0
BEGIN
   -- "-" in table name has a syntax problem, therefore, add [] around table name 
   SET @sqlStatement =            @sqlStatementBegin + @objectName + @sqlStatementAndType +@objectType + @sqlStatementDropTable + N'['+@objectName + N']'
   PRINT @sqlStatement
   EXEC sp_executesql @stmt = @sqlStatement
   FETCH NEXT FROM table_cursor INTO @objectName
END
CLOSE table_cursor
DEALLOCATE table_cursor
DELETE ASReplicationObjects
DROP TABLE ASReplicationObjects
--END SCRIPT--