XML Parsing Line1, character 58 semicolon expected
pauldes
Posts: 2
I am running a data compare where I have selected specific tables. I receive the following error when executing:
XML Parsing Line1, character 58 semicolon expected
And the following is a copy of the SQL generated by SQL Data Compare:
/*
Script created by SQL Data Compare version 5.2.0.40 from Red Gate Software Ltd at 8/27/2007 5:51:34 AM
Run this script on (local).EmptyClient0
This script will make changes to (local).EmptyClient0 to make it the same as (local).Client0
Note that this script will carry out all DELETE commands for all tables first, then all the UPDATES and then all the INSERTS
It will disable foreign key constraints at the beginning of the script, and re-enable them at the end
*/
SET NUMERIC_ROUNDABORT OFF
GO
SET XACT_ABORT, ANSI_PADDING, ANSI_WARNINGS, CONCAT_NULL_YIELDS_NULL, ARITHABORT, QUOTED_IDENTIFIER, ANSI_NULLS, NOCOUNT ON
GO
-- Pointer used for text / image updates. This might not be needed, but is declared here just in case
DECLARE @pv binary(16)
BEGIN TRANSACTION
-- Drop constraints from [dbo].[User_Choice_Names]
ALTER TABLE [dbo].[User_Choice_Names] DROP CONSTRAINT [FK_User_Choice_Names_Levels]
-- Drop constraints from [dbo].[User_Choice_Choices]
ALTER TABLE [dbo].[User_Choice_Choices] DROP CONSTRAINT [FK_User_Choice_Choices_Levels]
ALTER TABLE [dbo].[User_Choice_Choices] DROP CONSTRAINT [FK_User_Choice_Choices_User_Choice_Names]
-- Drop constraints from [dbo].[Time_Zone]
ALTER TABLE [dbo].[Time_Zone] DROP CONSTRAINT [FK_Time_Zone_Levels]
-- Drop constraints from [dbo].[TableNames]
ALTER TABLE [dbo].[TableNames] DROP CONSTRAINT [FK_TableNames_Levels]
-- Drop constraints from [dbo].[States]
ALTER TABLE [dbo].[States] DROP CONSTRAINT [FK_States_Country_Lookup]
ALTER TABLE [dbo].[States] DROP CONSTRAINT [FK_States_Firm]
ALTER TABLE [dbo].[States] DROP CONSTRAINT [FK_States_Levels]
-- Drop constraints from [dbo].[Levels]
ALTER TABLE [dbo].[Levels] DROP CONSTRAINT [FK_Parent_Levels]
-- Drop constraints from [dbo].[Currency_]
ALTER TABLE [dbo].[Currency_] DROP CONSTRAINT [FK_Currency__Levels]
-- Drop constraints from [dbo].[Countries]
ALTER TABLE [dbo].[Countries] DROP CONSTRAINT [FK_Countries_Levels]
ALTER TABLE [dbo].[Countries] DROP CONSTRAINT [FK_Country_Lookup_Currency_]
-- Drop constraints from [dbo].[Counties]
ALTER TABLE [dbo].[Counties] DROP CONSTRAINT [FK_Counties_Firm]
ALTER TABLE [dbo].[Counties] DROP CONSTRAINT [FK_Counties_Levels]
ALTER TABLE [dbo].[Counties] DROP CONSTRAINT [FK_Counties_States]
-- Drop constraints from [dbo].[Cost_Center]
ALTER TABLE [dbo].[Cost_Center] DROP CONSTRAINT [FK_Cost_Centers_Cost_Center_Category]
ALTER TABLE [dbo].[Cost_Center] DROP CONSTRAINT [FK_Cost_Centers_Levels]
-- Drop constraints from [dbo].[CheckList_Step]
ALTER TABLE [dbo].[CheckList_Step] DROP CONSTRAINT [FK_Action_Plan_Step_Action_Plan]
ALTER TABLE [dbo].[CheckList_Step] DROP CONSTRAINT [FK_CheckList_Step_Levels]
-- Drop constraints from [dbo].[CheckList]
ALTER TABLE [dbo].[CheckList] DROP CONSTRAINT [FK_Action_Plan_Employee]
ALTER TABLE [dbo].[CheckList] DROP CONSTRAINT [FK_Action_Plan_Firm]
ALTER TABLE [dbo].[CheckList] DROP CONSTRAINT [FK_CheckList_Levels]
-- Delete 2 rows from [dbo].[User_Choice_Choices]
DELETE FROM [dbo].[User_Choice_Choices] WHERE [User_Choice_Choices_Id]=60
DELETE FROM [dbo].[User_Choice_Choices] WHERE [User_Choice_Choices_Id]=62
-- Delete 1 row from [dbo].[Countries]
DELETE FROM [dbo].[Countries] WHERE [Country_Id]=10
-- Update 17 rows in [dbo].[User_Choice_Choices]
UPDATE [dbo].[User_Choice_Choices] SET [User_Choice_String_Name]=N'2', [Edit_Date]='20070422 08:44:36.107', [Edit_UserId]=1 WHERE [User_Choice_Choices_Id]=7
UPDATE [dbo].[User_Choice_Choices] SET [User_Choice_String_Name]=N'4', [Edit_Date]='20070422 08:44:45.420' WHERE [User_Choice_Choices_Id]=13
UPDATE [dbo].[User_Choice_Choices] SET [User_Choice_String_Name]=N'1', [Edit_Date]='20070422 08:44:31.280' WHERE [User_Choice_Choices_Id]=20
UPDATE [dbo].[User_Choice_Choices] SET [User_Choice_String_Name]=N'3', [Edit_Date]='20070422 08:44:40.763' WHERE [User_Choice_Choices_Id]=21
UPDATE [dbo].[User_Choice_Choices] SET [Edit_Date]='20070502 17:24:50.967', [Edit_UserId]=5 WHERE [User_Choice_Choices_Id]=83
UPDATE [dbo].[User_Choice_Choices] SET [Ordinal]=6, [Edit_Date]='20070127 19:45:47.480' WHERE [User_Choice_Choices_Id]=100
UPDATE [dbo].[User_Choice_Choices] SET [User_Choice_String_Name]=N'Document Ref.', [Edit_Date]='20070403 05:20:37.170' WHERE [User_Choice_Choices_Id]=147
UPDATE [dbo].[User_Choice_Choices] SET [User_Choice_String_Name]=N'Evidence Ref.', [Edit_Date]='20070403 05:20:55.827' WHERE [User_Choice_Choices_Id]=148
UPDATE [dbo].[User_Choice_Choices] SET [User_Choice_String_Name]=N'Fact', [Edit_Date]='20070403 05:21:10.920' WHERE [User_Choice_Choices_Id]=149
UPDATE [dbo].[User_Choice_Choices] SET [User_Choice_String_Name]=N'Issue', [Edit_Date]='20070403 05:21:21.420' WHERE [User_Choice_Choices_Id]=150
UPDATE [dbo].[User_Choice_Choices] SET [User_Choice_String_Name]=N'Deposition', [Edit_Date]='20070531 10:34:03.107' WHERE [User_Choice_Choices_Id]=155
UPDATE [dbo].[User_Choice_Choices] SET [User_Choice_String_Name]=N'Dispute', [Edit_Date]='20070403 05:16:26.293' WHERE [User_Choice_Choices_Id]=156
UPDATE [dbo].[User_Choice_Choices] SET [User_Choice_String_Name]=N'Discovery', [Edit_Date]='20070403 05:17:47.607' WHERE [User_Choice_Choices_Id]=157
UPDATE [dbo].[User_Choice_Choices] SET [Ordinal]=5, [User_Choice_String_Name]=N'Evidence', [Edit_Date]='20070403 05:19:21.733' WHERE [User_Choice_Choices_Id]=158
UPDATE [dbo].[User_Choice_Choices] SET [Ordinal]=4, [User_Choice_String_Name]=N'Documentation', [Edit_Date]='20070403 05:19:11.687' WHERE [User_Choice_Choices_Id]=159
UPDATE [dbo].[User_Choice_Choices] SET [Edit_Date]='20070807 00:24:52.937', [Edit_UserId]=7 WHERE [User_Choice_Choices_Id]=172
UPDATE [dbo].[User_Choice_Choices] SET [Edit_Date]='20070807 00:29:52.450', [Edit_UserId]=7 WHERE [User_Choice_Choices_Id]=173
-- Update 2 rows in [dbo].[Time_Zone]
UPDATE [dbo].[Time_Zone] SET [TZI]=N'', [Edit_Date]='20070816 13:59:29.607', [Edit_UserId]=7, [Level_Id]=1 WHERE [Time_Zone_Id]=17
UPDATE [dbo].[Time_Zone] SET [TZI]=N'', [Edit_Date]='20070531 10:40:41.233', [Level_Id]=1 WHERE [Time_Zone_Id]=21
-- Update 1 row in [dbo].[TableNames]
UPDATE [dbo].[TableNames] SET [IconFileId]=51 WHERE [TableId]=103
-- Update 60 rows in [dbo].[States]
UPDATE [dbo].[States] SET [Edit_Date]='20070531 10:40:01.187', [Edit_UserId]=1, [PortalId]=0, [Level_Id]=1 WHERE [States_Id]=2
UPDATE [dbo].[States] SET [PortalId]=0 WHERE [States_Id]=3
UPDATE [dbo].[States] SET [PortalId]=0 WHERE [States_Id]=4
UPDATE [dbo].[States] SET [PortalId]=0 WHERE [States_Id]=5
UPDATE [dbo].[States] SET [PortalId]=0 WHERE [States_Id]=6
UPDATE [dbo].[States] SET [PortalId]=0 WHERE [States_Id]=7
UPDATE [dbo].[States] SET [PortalId]=0 WHERE [States_Id]=8
UPDATE [dbo].[States] SET [PortalId]=0 WHERE [States_Id]=9
UPDATE [dbo].[States] SET [PortalId]=0 WHERE [States_Id]=10
UPDATE [dbo].[States] SET [Edit_Date]='20070816 13:58:31.043', [Edit_UserId]=7, [PortalId]=0, [Level_Id]=1 WHERE [States_Id]=11
UPDATE [dbo].[States] SET [PortalId]=0 WHERE [States_Id]=12
UPDATE [dbo].[States] SET [PortalId]=0 WHERE [States_Id]=13
UPDATE [dbo].[States] SET [PortalId]=0 WHERE [States_Id]=14
UPDATE [dbo].[States] SET [PortalId]=0 WHERE [States_Id]=15
UPDATE [dbo].[States] SET [PortalId]=0 WHERE [States_Id]=16
UPDATE [dbo].[States] SET [PortalId]=0 WHERE [States_Id]=17
UPDATE [dbo].[States] SET [PortalId]=0 WHERE [States_Id]=18
UPDATE [dbo].[States] SET [PortalId]=0 WHERE [States_Id]=19
UPDATE [dbo].[States] SET [PortalId]=0 WHERE [States_Id]=20
UPDATE [dbo].[States] SET [PortalId]=0 WHERE [States_Id]=21
UPDATE [dbo].[States] SET [PortalId]=0 WHERE [States_Id]=22
UPDATE [dbo].[States] SET [PortalId]=0 WHERE [States_Id]=23
UPDATE [dbo].[States] SET [PortalId]=0 WHERE [States_Id]=24
UPDATE [dbo].[States] SET [PortalId]=0 WHERE [States_Id]=25
UPDATE [dbo].[States] SET [PortalId]=0 WHERE [States_Id]=26
UPDATE [dbo].[States] SET [PortalId]=0 WHERE [States_Id]=27
UPDATE [dbo].[States] SET [PortalId]=0 WHERE [States_Id]=28
UPDATE [dbo].[States] SET [PortalId]=0 WHERE [States_Id]=29
UPDATE [dbo].[States] SET [PortalId]=0 WHERE [States_Id]=30
UPDATE [dbo].[States] SET [PortalId]=0 WHERE [States_Id]=31
UPDATE [dbo].[States] SET [PortalId]=0 WHERE [States_Id]=32
UPDATE [dbo].[States] SET [PortalId]=0 WHERE [States_Id]=33
UPDATE [dbo].[States] SET [PortalId]=0 WHERE [States_Id]=34
UPDATE [dbo].[States] SET [PortalId]=0 WHERE [States_Id]=35
UPDATE [dbo].[States] SET [PortalId]=0 WHERE [States_Id]=36
UPDATE [dbo].[States] SET [PortalId]=0 WHERE [States_Id]=37
UPDATE [dbo].[States] SET [PortalId]=0 WHERE [States_Id]=38
UPDATE [dbo].[States] SET [PortalId]=0 WHERE [States_Id]=39
UPDATE [dbo].[States] SET [PortalId]=0 WHERE [States_Id]=40
UPDATE [dbo].[States] SET [PortalId]=0 WHERE [States_Id]=41
UPDATE [dbo].[States] SET [PortalId]=0 WHERE [States_Id]=42
UPDATE [dbo].[States] SET [PortalId]=0 WHERE [States_Id]=43
UPDATE [dbo].[States] SET [PortalId]=0 WHERE [States_Id]=44
UPDATE [dbo].[States] SET [PortalId]=0 WHERE [States_Id]=45
UPDATE [dbo].[States] SET [PortalId]=0 WHERE [States_Id]=46
UPDATE [dbo].[States] SET [PortalId]=0 WHERE [States_Id]=47
UPDATE [dbo].[States] SET [PortalId]=0 WHERE [States_Id]=48
UPDATE [dbo].[States] SET [PortalId]=0 WHERE [States_Id]=49
UPDATE [dbo].[States] SET [PortalId]=0 WHERE [States_Id]=50
UPDATE [dbo].[States] SET [PortalId]=0 WHERE [States_Id]=51
UPDATE [dbo].[States] SET [PortalId]=0 WHERE [States_Id]=52
UPDATE [dbo].[States] SET [PortalId]=0 WHERE [States_Id]=53
UPDATE [dbo].[States] SET [PortalId]=0 WHERE [States_Id]=54
UPDATE [dbo].[States] SET [PortalId]=0 WHERE [States_Id]=55
UPDATE [dbo].[States] SET [PortalId]=0 WHERE [States_Id]=56
UPDATE [dbo].[States] SET [PortalId]=0 WHERE [States_Id]=57
UPDATE [dbo].[States] SET [PortalId]=0 WHERE [States_Id]=58
UPDATE [dbo].[States] SET [PortalId]=0 WHERE [States_Id]=59
UPDATE [dbo].[States] SET [PortalId]=0 WHERE [States_Id]=60
UPDATE [dbo].[States] SET [PortalId]=0 WHERE [States_Id]=61
-- Update 1 row in [dbo].[Levels]
UPDATE [dbo].[Levels] SET [Name]=N'Level One', [Create_Date]='20060101 00:00:00.000', [Edit_Date]='20060101 00:00:00.000', [PortalId]=NULL WHERE [Level_Id]=1
-- Update 3 rows in [dbo].[Currency_]
UPDATE [dbo].[Currency_] SET [Currency_Symbol]=N'', [Edit_Date]='20070531 10:38:09.030', [Level_Id]=1 WHERE [Currency_Id]=1
UPDATE [dbo].[Currency_] SET [Currency_Symbol]=N'', [Edit_Date]='20070816 13:55:13.980', [Edit_UserId]=7, [Level_Id]=1 WHERE [Currency_Id]=12
UPDATE [dbo].[Currency_] SET [Currency_Symbol]=N'$', [Edit_Date]='20070816 13:54:47.997', [Edit_UserId]=7, [Level_Id]=1 WHERE [Currency_Id]=89
-- Update 2 rows in [dbo].[Countries]
UPDATE [dbo].[Countries] SET [Currency_Id]=1, [Phone_Code]=85, [Edit_Date]='20070817 01:49:04.483', [Edit_UserId]=17, [Level_Id]=1 WHERE [Country_Id]=1
UPDATE [dbo].[Countries] SET [Currency_Id]=2, [Phone_Code]=0, [Edit_Date]='20070601 04:53:00.797', [Edit_UserId]=17, [Level_Id]=1 WHERE [Country_Id]=3
-- Update 1 row in [dbo].[Counties]
UPDATE [dbo].[Counties] SET [Edit_Date]='20070806 23:58:20.437', [Edit_UserId]=7, [Level_Id]=1 WHERE [Counties_Id]=329
-- Add 9 rows to [dbo].[LevelRelationships]
INSERT INTO [dbo].[LevelRelationships] ([Level_ID], [Parent_Level_ID], [Depth]) VALUES (2, 1, 0)
INSERT INTO [dbo].[LevelRelationships] ([Level_ID], [Parent_Level_ID], [Depth]) VALUES (3, 1, 0)
INSERT INTO [dbo].[LevelRelationships] ([Level_ID], [Parent_Level_ID], [Depth]) VALUES (4, 2, 1)
INSERT INTO [dbo].[LevelRelationships] ([Level_ID], [Parent_Level_ID], [Depth]) VALUES (4, 1, 0)
INSERT INTO [dbo].[LevelRelationships] ([Level_ID], [Parent_Level_ID], [Depth]) VALUES (5, 3, 1)
INSERT INTO [dbo].[LevelRelationships] ([Level_ID], [Parent_Level_ID], [Depth]) VALUES (5, 1, 0)
INSERT INTO [dbo].[LevelRelationships] ([Level_ID], [Parent_Level_ID], [Depth]) VALUES (6, 5, 2)
INSERT INTO [dbo].[LevelRelationships] ([Level_ID], [Parent_Level_ID], [Depth]) VALUES (6, 3, 1)
INSERT INTO [dbo].[LevelRelationships] ([Level_ID], [Parent_Level_ID], [Depth]) VALUES (6, 1, 0)
-- Add 1 row to [dbo].[CheckList]
SET IDENTITY_INSERT [dbo].[CheckList] ON
INSERT INTO [dbo].[CheckList] ([Checklist_Id], [Author_Id], [Firm_Id], [Create_Date], [Edit_Date], [CheckList_Name], [Description], [Modification_Date], [Type], [Category], [State], [County], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (18, 8, 1, '20070816 11:28:16.607', '20070816 11:28:16.607', N'Motion to Dismiss', N'Motion to Dismiss Practices', NULL, N'Hearing', N'Official Court Process', N'TX', N'', 7, 7, 0, 1)
SET IDENTITY_INSERT [dbo].[CheckList] OFF
-- Add 4 rows to [dbo].[CheckList_Step]
SET IDENTITY_INSERT [dbo].[CheckList_Step] ON
INSERT INTO [dbo].[CheckList_Step] ([Checklist_Step_Id], [Checklist_Id], [Checklist_Step_Name], [Date_Offset], [Priority], [Type], [Description], [Notes], [Access_Type], [Activity_Type], [Ordinal], [Primary_Item], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (18, 18, N'Motion to Dismiss Hearing', 0, N'1', NULL, N'Motion Hearing Date', N'Activity Notes go here for Motion Hearing Date', N'Public', N'Court Date', 7, 1, '20070816 11:39:53.920', '20070816 11:39:53.920', 7, 7, 0, 1)
INSERT INTO [dbo].[CheckList_Step] ([Checklist_Step_Id], [Checklist_Id], [Checklist_Step_Name], [Date_Offset], [Priority], [Type], [Description], [Notes], [Access_Type], [Activity_Type], [Ordinal], [Primary_Item], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (21, 18, N'Prepare Arguments', 4, N'1', NULL, N'Create Arguments', N'Prep work', N'Public', N'Appointment', 5, NULL, '20070816 11:42:20.000', '20070816 11:44:19.827', 7, 7, 0, 1)
INSERT INTO [dbo].[CheckList_Step] ([Checklist_Step_Id], [Checklist_Id], [Checklist_Step_Name], [Date_Offset], [Priority], [Type], [Description], [Notes], [Access_Type], [Activity_Type], [Ordinal], [Primary_Item], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (22, 18, N'File Hearing Docs with Court', 10, N'1', NULL, N'Preparing Docs For Hearing', N'Preparing Docs For Hearing', N'Public', N'Appointment', 3, NULL, '20070816 11:43:54.590', '20070816 11:43:54.590', 7, 7, 0, 1)
INSERT INTO [dbo].[CheckList_Step] ([Checklist_Step_Id], [Checklist_Id], [Checklist_Step_Name], [Date_Offset], [Priority], [Type], [Description], [Notes], [Access_Type], [Activity_Type], [Ordinal], [Primary_Item], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (23, 18, N'Prepare Application for Motion', 15, N'1', NULL, N'Application for Motion', N'More stuff to do', N'Public', N'Appointment', 1, NULL, '20070816 11:45:52.937', '20070816 11:45:52.937', 7, 7, 0, 1)
SET IDENTITY_INSERT [dbo].[CheckList_Step] OFF
-- Add 5 rows to [dbo].[Cost_Center]
SET IDENTITY_INSERT [dbo].[Cost_Center] ON
INSERT INTO [dbo].[Cost_Center] ([Cost_Center_Id], [Cost_Center_Category_Id], [Name], [Code], [Create_Date], [Edit_Date], [Create_UserId], [Edit_UserId], [PortalId], [Level_Id]) VALUES (0, NULL, N'Car', N'C1', '20070103 10:31:35.000', '20070103 10:31:35.000', 1, 1, 0, 1)
INSERT INTO [dbo].[Cost_Center] ([Cost_Center_Id], [Cost_Center_Category_Id], [Name], [Code], [Create_Date], [Edit_Date], [Create_UserId], [Edit_UserId], [PortalId], [Level_Id]) VALUES (1, NULL, N'Phone', N'P1', '20070103 10:31:35.000', '20070103 10:31:35.000', 1, 1, 0, 1)
INSERT INTO [dbo].[Cost_Center] ([Cost_Center_Id], [Cost_Center_Category_Id], [Name], [Code], [Create_Date], [Edit_Date], [Create_UserId], [Edit_UserId], [PortalId], [Level_Id]) VALUES (2, NULL, N'Food', N'F1', '20070103 10:31:35.000', '20070103 10:31:35.000', 1, 1, 0, 1)
INSERT INTO [dbo].[Cost_Center] ([Cost_Center_Id], [Cost_Center_Category_Id], [Name], [Code], [Create_Date], [Edit_Date], [Create_UserId], [Edit_UserId], [PortalId], [Level_Id]) VALUES (3, NULL, N'Hotel', N'H1', '20070103 10:31:35.000', '20070103 10:31:35.000', 1, 1, 0, 1)
INSERT INTO [dbo].[Cost_Center] ([Cost_Center_Id], [Cost_Center_Category_Id], [Name], [Code], [Create_Date], [Edit_Date], [Create_UserId], [Edit_UserId], [PortalId], [Level_Id]) VALUES (4, NULL, N'Entertainment', N'E1', '20070103 10:31:35.000', '20070103 10:31:35.000', 1, 1, 0, 1)
SET IDENTITY_INSERT [dbo].[Cost_Center] OFF
-- Add 5 rows to [dbo].[Levels]
SET IDENTITY_INSERT [dbo].[Levels] ON
INSERT INTO [dbo].[Levels] ([Level_Id], [Parent_Level_Id], [Name], [Description], [Create_Date], [Edit_Date], [Create_UserId], [Edit_UserId], [PortalId]) VALUES (2, 1, N'Level Two', NULL, '20060101 00:00:00.000', '20060101 00:00:00.000', 1, 1, NULL)
INSERT INTO [dbo].[Levels] ([Level_Id], [Parent_Level_Id], [Name], [Description], [Create_Date], [Edit_Date], [Create_UserId], [Edit_UserId], [PortalId]) VALUES (3, 1, N'Level Three', NULL, '20060101 00:00:00.000', '20060101 00:00:00.000', 1, 1, NULL)
INSERT INTO [dbo].[Levels] ([Level_Id], [Parent_Level_Id], [Name], [Description], [Create_Date], [Edit_Date], [Create_UserId], [Edit_UserId], [PortalId]) VALUES (4, 2, N'Level Four', NULL, '20060101 00:00:00.000', '20060101 00:00:00.000', 1, 1, NULL)
INSERT INTO [dbo].[Levels] ([Level_Id], [Parent_Level_Id], [Name], [Description], [Create_Date], [Edit_Date], [Create_UserId], [Edit_UserId], [PortalId]) VALUES (5, 3, N'Level Five', NULL, '20060101 00:00:00.000', '20060101 00:00:00.000', 1, 1, NULL)
INSERT INTO [dbo].[Levels] ([Level_Id], [Parent_Level_Id], [Name], [Description], [Create_Date], [Edit_Date], [Create_UserId], [Edit_UserId], [PortalId]) VALUES (6, 5, N'Level Six', NULL, NULL, NULL, NULL, NULL, NULL)
SET IDENTITY_INSERT [dbo].[Levels] OFF
-- Add 62 rows to [dbo].[User_Choice_Choices]
SET IDENTITY_INSERT [dbo].[User_Choice_Choices] ON
INSERT INTO [dbo].[User_Choice_Choices] ([User_Choice_Choices_Id], [User_Choice_Names_Id], [Ordinal], [User_Choice_String_Name], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (221, 35, 5, N'Court Associate', '20070127 19:45:41.030', '20070127 19:45:41.030', 1, 1, 0, 1)
INSERT INTO [dbo].[User_Choice_Choices] ([User_Choice_Choices_Id], [User_Choice_Names_Id], [Ordinal], [User_Choice_String_Name], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (222, 65, 1, N'Open', '20070204 08:45:21.030', '20070204 08:45:21.030', 1, 1, 0, 1)
INSERT INTO [dbo].[User_Choice_Choices] ([User_Choice_Choices_Id], [User_Choice_Names_Id], [Ordinal], [User_Choice_String_Name], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (223, 65, 2, N'Submitted', '20070204 08:45:28.030', '20070204 08:45:28.030', 1, 1, 0, 1)
INSERT INTO [dbo].[User_Choice_Choices] ([User_Choice_Choices_Id], [User_Choice_Names_Id], [Ordinal], [User_Choice_String_Name], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (224, 65, 3, N'Approved', '20070204 08:45:35.030', '20070204 08:45:35.030', 1, 1, 0, 1)
INSERT INTO [dbo].[User_Choice_Choices] ([User_Choice_Choices_Id], [User_Choice_Names_Id], [Ordinal], [User_Choice_String_Name], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (225, 65, 4, N'Paid', '20070204 08:45:41.577', '20070204 08:45:41.577', 1, 1, 0, 1)
INSERT INTO [dbo].[User_Choice_Choices] ([User_Choice_Choices_Id], [User_Choice_Names_Id], [Ordinal], [User_Choice_String_Name], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (226, 66, 1, N'Hot', '20070213 04:06:05.233', '20070213 04:06:05.233', 17, 17, 0, 1)
INSERT INTO [dbo].[User_Choice_Choices] ([User_Choice_Choices_Id], [User_Choice_Names_Id], [Ordinal], [User_Choice_String_Name], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (227, 66, 2, N'Medium', '20070213 04:08:09.967', '20070213 04:08:09.967', 5, 5, 0, 1)
INSERT INTO [dbo].[User_Choice_Choices] ([User_Choice_Choices_Id], [User_Choice_Names_Id], [Ordinal], [User_Choice_String_Name], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (228, 66, 3, N'Low', '20070213 04:08:17.670', '20070213 04:08:17.670', 5, 5, 0, 1)
INSERT INTO [dbo].[User_Choice_Choices] ([User_Choice_Choices_Id], [User_Choice_Names_Id], [Ordinal], [User_Choice_String_Name], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (229, 67, 1, N'Web', '20070213 04:10:06.873', '20070213 04:10:06.873', 5, 5, 0, 1)
INSERT INTO [dbo].[User_Choice_Choices] ([User_Choice_Choices_Id], [User_Choice_Names_Id], [Ordinal], [User_Choice_String_Name], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (230, 67, 2, N'Call In', '20070213 04:10:17.437', '20070213 04:10:17.437', 5, 5, 0, 1)
INSERT INTO [dbo].[User_Choice_Choices] ([User_Choice_Choices_Id], [User_Choice_Names_Id], [Ordinal], [User_Choice_String_Name], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (231, 67, 3, N'Referral', '20070213 04:10:29.263', '20070213 04:10:29.263', 5, 5, 0, 1)
INSERT INTO [dbo].[User_Choice_Choices] ([User_Choice_Choices_Id], [User_Choice_Names_Id], [Ordinal], [User_Choice_String_Name], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (232, 68, 1, N'In Progress', '20070213 04:10:49.530', '20070213 04:10:49.530', 5, 5, 0, 1)
INSERT INTO [dbo].[User_Choice_Choices] ([User_Choice_Choices_Id], [User_Choice_Names_Id], [Ordinal], [User_Choice_String_Name], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (233, 68, 2, N'On Hold', '20070213 04:10:58.483', '20070213 04:10:58.483', 5, 5, 0, 1)
INSERT INTO [dbo].[User_Choice_Choices] ([User_Choice_Choices_Id], [User_Choice_Names_Id], [Ordinal], [User_Choice_String_Name], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (234, 68, 3, N'Archived', '20070213 04:11:12.077', '20070213 04:11:12.077', 5, 5, 0, 1)
INSERT INTO [dbo].[User_Choice_Choices] ([User_Choice_Choices_Id], [User_Choice_Names_Id], [Ordinal], [User_Choice_String_Name], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (235, 68, 4, N'Processed', '20070213 04:11:22.200', '20070213 04:11:22.200', 5, 5, 0, 1)
INSERT INTO [dbo].[User_Choice_Choices] ([User_Choice_Choices_Id], [User_Choice_Names_Id], [Ordinal], [User_Choice_String_Name], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (236, 69, 1, N'Custody', '20070213 04:12:03.217', '20070213 04:12:03.217', 5, 5, 0, 1)
INSERT INTO [dbo].[User_Choice_Choices] ([User_Choice_Choices_Id], [User_Choice_Names_Id], [Ordinal], [User_Choice_String_Name], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (237, 69, 2, N'Bankruptcy', '20070213 04:12:20.653', '20070213 04:12:20.653', 5, 5, 0, 1)
INSERT INTO [dbo].[User_Choice_Choices] ([User_Choice_Choices_Id], [User_Choice_Names_Id], [Ordinal], [User_Choice_String_Name], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (238, 69, 3, N'Divorce', '20070213 04:12:30.903', '20070213 04:12:30.903', 5, 5, 0, 1)
INSERT INTO [dbo].[User_Choice_Choices] ([User_Choice_Choices_Id], [User_Choice_Names_Id], [Ordinal], [User_Choice_String_Name], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (239, 69, 4, N'Civil', '20070213 04:12:41.013', '20070213 04:12:41.013', 5, 5, 0, 1)
INSERT INTO [dbo].[User_Choice_Choices] ([User_Choice_Choices_Id], [User_Choice_Names_Id], [Ordinal], [User_Choice_String_Name], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (240, 49, 6, N'Other', '20070403 05:19:31.763', '20070403 05:19:31.763', 1, 1, 0, 1)
INSERT INTO [dbo].[User_Choice_Choices] ([User_Choice_Choices_Id], [User_Choice_Names_Id], [Ordinal], [User_Choice_String_Name], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (241, 49, 7, N'Transcript', '20070403 05:19:40.500', '20070403 05:19:40.500', 1, 1, 0, 1)
INSERT INTO [dbo].[User_Choice_Choices] ([User_Choice_Choices_Id], [User_Choice_Names_Id], [Ordinal], [User_Choice_String_Name], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (242, 49, 8, N'Violation', '20070403 05:19:48.873', '20070403 05:19:48.873', 1, 1, 0, 1)
INSERT INTO [dbo].[User_Choice_Choices] ([User_Choice_Choices_Id], [User_Choice_Names_Id], [Ordinal], [User_Choice_String_Name], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (243, 49, 9, N'Witness', '20070403 05:19:56.700', '20070403 05:19:56.700', 1, 1, 0, 1)
INSERT INTO [dbo].[User_Choice_Choices] ([User_Choice_Choices_Id], [User_Choice_Names_Id], [Ordinal], [User_Choice_String_Name], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (244, 47, 5, N'Note', '20070403 05:21:30.390', '20070403 05:21:30.390', 1, 1, 0, 1)
INSERT INTO [dbo].[User_Choice_Choices] ([User_Choice_Choices_Id], [User_Choice_Names_Id], [Ordinal], [User_Choice_String_Name], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (245, 47, 6, N'Other', '20070403 05:21:36.950', '20070403 05:21:36.950', 1, 1, 0, 1)
INSERT INTO [dbo].[User_Choice_Choices] ([User_Choice_Choices_Id], [User_Choice_Names_Id], [Ordinal], [User_Choice_String_Name], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (246, 47, 7, N'Research', '20070403 05:21:46.733', '20070403 05:21:46.733', 1, 1, 0, 1)
INSERT INTO [dbo].[User_Choice_Choices] ([User_Choice_Choices_Id], [User_Choice_Names_Id], [Ordinal], [User_Choice_String_Name], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (247, 70, 1, N'In Progress', '20070421 10:41:06.640', '20070421 10:41:06.640', 1, 1, 0, 1)
INSERT INTO [dbo].[User_Choice_Choices] ([User_Choice_Choices_Id], [User_Choice_Names_Id], [Ordinal], [User_Choice_String_Name], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (248, 70, 2, N'Resolved', '20070421 10:41:17.310', '20070421 10:41:17.310', 1, 1, 0, 1)
INSERT INTO [dbo].[User_Choice_Choices] ([User_Choice_Choices_Id], [User_Choice_Names_Id], [Ordinal], [User_Choice_String_Name], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (249, 70, 3, N'Outstanding', '20070421 10:41:26.700', '20070421 10:41:26.700', 1, 1, 0, 1)
INSERT INTO [dbo].[User_Choice_Choices] ([User_Choice_Choices_Id], [User_Choice_Names_Id], [Ordinal], [User_Choice_String_Name], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (250, 70, 4, N'Court Accepted', '20070421 10:41:39.467', '20070421 10:41:39.467', 1, 1, 0, 1)
INSERT INTO [dbo].[User_Choice_Choices] ([User_Choice_Choices_Id], [User_Choice_Names_Id], [Ordinal], [User_Choice_String_Name], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (251, 70, 5, N'Mutually Accepted', '20070421 10:41:49.263', '20070421 10:41:49.263', 1, 1, 0, 1)
INSERT INTO [dbo].[User_Choice_Choices] ([User_Choice_Choices_Id], [User_Choice_Names_Id], [Ordinal], [User_Choice_String_Name], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (252, 70, 6, N'Disputed Us', '20070421 10:42:00.640', '20070421 10:42:00.640', 1, 1, 0, 1)
INSERT INTO [dbo].[User_Choice_Choices] ([User_Choice_Choices_Id], [User_Choice_Names_Id], [Ordinal], [User_Choice_String_Name], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (253, 70, 7, N'Disputed Them', '20070421 10:42:08.640', '20070421 10:42:08.640', 1, 1, 0, 1)
INSERT INTO [dbo].[User_Choice_Choices] ([User_Choice_Choices_Id], [User_Choice_Names_Id], [Ordinal], [User_Choice_String_Name], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (254, 2, 5, N'5', '20070422 08:44:48.607', '20070422 08:44:48.607', 1, 1, 0, 1)
INSERT INTO [dbo].[User_Choice_Choices] ([User_Choice_Choices_Id], [User_Choice_Names_Id], [Ordinal], [User_Choice_String_Name], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (255, 71, 1, N'Alltel', '20070422 09:05:30.717', '20070422 09:05:30.717', 1, 1, 0, 1)
INSERT INTO [dbo].[User_Choice_Choices] ([User_Choice_Choices_Id], [User_Choice_Names_Id], [Ordinal], [User_Choice_String_Name], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (256, 71, 2, N'AT&T', '20070422 09:05:37.983', '20070422 09:05:37.983', 1, 1, 0, 1)
INSERT INTO [dbo].[User_Choice_Choices] ([User_Choice_Choices_Id], [User_Choice_Names_Id], [Ordinal], [User_Choice_String_Name], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (257, 71, 3, N'Bell Atlantic', '20070422 09:05:47.357', '20070422 09:05:47.357', 1, 1, 0, 1)
INSERT INTO [dbo].[User_Choice_Choices] ([User_Choice_Choices_Id], [User_Choice_Names_Id], [Ordinal], [User_Choice_String_Name], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (258, 71, 4, N'Bell Canada', '20070422 09:05:56.483', '20070422 09:05:56.483', 1, 1, 0, 1)
INSERT INTO [dbo].[User_Choice_Choices] ([User_Choice_Choices_Id], [User_Choice_Names_Id], [Ordinal], [User_Choice_String_Name], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (259, 71, 5, N'Cellular One', '20070422 09:06:04.500', '20070422 09:06:04.500', 1, 1, 0, 1)
INSERT INTO [dbo].[User_Choice_Choices] ([User_Choice_Choices_Id], [User_Choice_Names_Id], [Ordinal], [User_Choice_String_Name], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (260, 71, 6, N'CellularOneTX', '20070422 09:06:13.793', '20070422 09:06:13.793', 1, 1, 0, 1)
INSERT INTO [dbo].[User_Choice_Choices] ([User_Choice_Choices_Id], [User_Choice_Names_Id], [Ordinal], [User_Choice_String_Name], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (261, 71, 7, N'Cingular', '20070422 09:06:19.437', '20070422 09:06:19.437', 1, 1, 0, 1)
INSERT INTO [dbo].[User_Choice_Choices] ([User_Choice_Choices_Id], [User_Choice_Names_Id], [Ordinal], [User_Choice_String_Name], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (262, 71, 8, N'Fido', '20070422 09:06:24.840', '20070422 09:06:24.840', 1, 1, 0, 1)
INSERT INTO [dbo].[User_Choice_Choices] ([User_Choice_Choices_Id], [User_Choice_Names_Id], [Ordinal], [User_Choice_String_Name], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (263, 71, 9, N'HickoryTech', '20070422 09:06:35.793', '20070422 09:06:35.793', 1, 1, 0, 1)
INSERT INTO [dbo].[User_Choice_Choices] ([User_Choice_Choices_Id], [User_Choice_Names_Id], [Ordinal], [User_Choice_String_Name], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (264, 71, 10, N'Nextel', '20070422 09:06:44.840', '20070422 09:06:44.840', 1, 1, 0, 1)
INSERT INTO [dbo].[User_Choice_Choices] ([User_Choice_Choices_Id], [User_Choice_Names_Id], [Ordinal], [User_Choice_String_Name], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (265, 71, 11, N'Qwest', '20070422 09:06:54.030', '20070422 09:06:54.030', 1, 1, 0, 1)
INSERT INTO [dbo].[User_Choice_Choices] ([User_Choice_Choices_Id], [User_Choice_Names_Id], [Ordinal], [User_Choice_String_Name], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (266, 71, 12, N'SprintPCS', '20070422 09:07:00.263', '20070422 09:07:00.263', 1, 1, 0, 1)
INSERT INTO [dbo].[User_Choice_Choices] ([User_Choice_Choices_Id], [User_Choice_Names_Id], [Ordinal], [User_Choice_String_Name], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (267, 71, 13, N'SureWest', '20070422 09:07:07.200', '20070422 09:07:07.200', 1, 1, 0, 1)
INSERT INTO [dbo].[User_Choice_Choices] ([User_Choice_Choices_Id], [User_Choice_Names_Id], [Ordinal], [User_Choice_String_Name], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (268, 71, 14, N'TelusMobility', '20070422 09:07:14.467', '20070422 09:07:14.467', 1, 1, 0, 1)
INSERT INTO [dbo].[User_Choice_Choices] ([User_Choice_Choices_Id], [User_Choice_Names_Id], [Ordinal], [User_Choice_String_Name], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (269, 71, 15, N'TMobile', '20070422 09:07:19.763', '20070422 09:07:19.763', 1, 1, 0, 1)
INSERT INTO [dbo].[User_Choice_Choices] ([User_Choice_Choices_Id], [User_Choice_Names_Id], [Ordinal], [User_Choice_String_Name], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (270, 71, 16, N'Verizon', '20070422 09:07:25.763', '20070422 09:07:25.763', 1, 1, 0, 1)
INSERT INTO [dbo].[User_Choice_Choices] ([User_Choice_Choices_Id], [User_Choice_Names_Id], [Ordinal], [User_Choice_String_Name], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (271, 73, 1, N'Documentation', '20070503 08:05:18.967', '20070730 12:54:24.577', 7, 17, 0, 1)
INSERT INTO [dbo].[User_Choice_Choices] ([User_Choice_Choices_Id], [User_Choice_Names_Id], [Ordinal], [User_Choice_String_Name], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (272, 73, 2, N'Preparation', '20070503 08:05:26.280', '20070730 12:54:32.950', 7, 17, 0, 1)
INSERT INTO [dbo].[User_Choice_Choices] ([User_Choice_Choices_Id], [User_Choice_Names_Id], [Ordinal], [User_Choice_String_Name], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (273, 73, 3, N'Official Court Process', '20070503 08:05:32.140', '20070730 12:54:45.530', 7, 17, 0, 1)
INSERT INTO [dbo].[User_Choice_Choices] ([User_Choice_Choices_Id], [User_Choice_Names_Id], [Ordinal], [User_Choice_String_Name], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (274, 73, 4, N'Internal Process', '20070503 08:05:39.483', '20070730 12:54:54.640', 7, 17, 0, 1)
INSERT INTO [dbo].[User_Choice_Choices] ([User_Choice_Choices_Id], [User_Choice_Names_Id], [Ordinal], [User_Choice_String_Name], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (275, 72, 1, N'Case Docket', '20070503 08:05:55.700', '20070730 12:52:07.560', 7, 17, 0, 1)
INSERT INTO [dbo].[User_Choice_Choices] ([User_Choice_Choices_Id], [User_Choice_Names_Id], [Ordinal], [User_Choice_String_Name], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (276, 72, 2, N'Trial', '20070503 08:06:02.093', '20070730 12:50:51.950', 7, 17, 0, 1)
INSERT INTO [dbo].[User_Choice_Choices] ([User_Choice_Choices_Id], [User_Choice_Names_Id], [Ordinal], [User_Choice_String_Name], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (277, 72, 3, N'Hearing', '20070503 08:06:07.090', '20070730 12:51:00.340', 7, 17, 0, 1)
INSERT INTO [dbo].[User_Choice_Choices] ([User_Choice_Choices_Id], [User_Choice_Names_Id], [Ordinal], [User_Choice_String_Name], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (278, 72, 4, N'Deposition', '20070503 08:06:11.717', '20070730 12:52:21.903', 7, 17, 0, 1)
INSERT INTO [dbo].[User_Choice_Choices] ([User_Choice_Choices_Id], [User_Choice_Names_Id], [Ordinal], [User_Choice_String_Name], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (284, 57, 0, N'Amex', '20070816 13:45:52.153', '20070816 13:45:52.153', 7, 7, 0, 1)
INSERT INTO [dbo].[User_Choice_Choices] ([User_Choice_Choices_Id], [User_Choice_Names_Id], [Ordinal], [User_Choice_String_Name], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (285, 28, 0, N'Legal Form', '20070816 13:46:31.500', '20070816 13:46:31.500', 7, 7, 0, 1)
INSERT INTO [dbo].[User_Choice_Choices] ([User_Choice_Choices_Id], [User_Choice_Names_Id], [Ordinal], [User_Choice_String_Name], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (286, 28, 0, N'More Form', '20070816 13:46:53.933', '20070816 13:46:53.933', 7, 7, 0, 1)
INSERT INTO [dbo].[User_Choice_Choices] ([User_Choice_Choices_Id], [User_Choice_Names_Id], [Ordinal], [User_Choice_String_Name], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (287, 28, 0, N'Cheese Cake', '20070816 13:47:08.343', '20070816 13:47:08.343', 7, 7, 0, 1)
SET IDENTITY_INSERT [dbo].[User_Choice_Choices] OFF
-- Add 9 rows to [dbo].[User_Choice_Names]
SET IDENTITY_INSERT [dbo].[User_Choice_Names] ON
INSERT INTO [dbo].[User_Choice_Names] ([User_Choice_Names_Id], [User_Choice_Name], [UnEditable], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (65, N'Expense Status', NULL, '20070204 08:45:06.390', '20070204 08:45:06.390', 1, 1, 0, 1)
INSERT INTO [dbo].[User_Choice_Names] ([User_Choice_Names_Id], [User_Choice_Name], [UnEditable], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (66, N'Lead Quality', NULL, '20070213 04:03:34.060', '20070213 04:03:34.060', 17, 17, 0, 1)
INSERT INTO [dbo].[User_Choice_Names] ([User_Choice_Names_Id], [User_Choice_Name], [UnEditable], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (67, N'Lead Source', NULL, '20070213 04:04:19.200', '20070213 04:04:19.200', 17, 17, 0, 1)
INSERT INTO [dbo].[User_Choice_Names] ([User_Choice_Names_Id], [User_Choice_Name], [UnEditable], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (68, N'Lead Status', NULL, '20070213 04:05:05.590', '20070213 04:05:05.590', 17, 17, 0, 1)
INSERT INTO [dbo].[User_Choice_Names] ([User_Choice_Names_Id], [User_Choice_Name], [UnEditable], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (69, N'Lead Type', NULL, '20070213 04:11:41.420', '20070213 04:11:41.420', 5, 5, 0, 1)
INSERT INTO [dbo].[User_Choice_Names] ([User_Choice_Names_Id], [User_Choice_Name], [UnEditable], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (70, N'Issue Status', NULL, '20070421 10:40:48.467', '20070421 10:40:48.467', 1, 1, 0, 1)
INSERT INTO [dbo].[User_Choice_Names] ([User_Choice_Names_Id], [User_Choice_Name], [UnEditable], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (71, N'Cell Phone Providers', NULL, '20070422 09:05:18.437', '20070422 09:05:18.437', 1, 1, 0, 1)
INSERT INTO [dbo].[User_Choice_Names] ([User_Choice_Names_Id], [User_Choice_Name], [UnEditable], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (72, N'BP Type', NULL, '20070503 08:04:55.140', '20070503 08:04:55.140', 17, 17, 0, 1)
INSERT INTO [dbo].[User_Choice_Names] ([User_Choice_Names_Id], [User_Choice_Name], [UnEditable], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (73, N'BP Category', NULL, '20070503 08:05:04.200', '20070503 08:05:04.200', 17, 17, 0, 1)
SET IDENTITY_INSERT [dbo].[User_Choice_Names] OFF
-- Add constraints to [dbo].[User_Choice_Names]
ALTER TABLE [dbo].[User_Choice_Names] WITH NOCHECK ADD CONSTRAINT [FK_User_Choice_Names_Levels] FOREIGN KEY ([Level_Id]) REFERENCES [dbo].[Levels] ([Level_Id])
-- Add constraints to [dbo].[User_Choice_Choices]
ALTER TABLE [dbo].[User_Choice_Choices] WITH NOCHECK ADD CONSTRAINT [FK_User_Choice_Choices_Levels] FOREIGN KEY ([Level_Id]) REFERENCES [dbo].[Levels] ([Level_Id]) NOT FOR REPLICATION
ALTER TABLE [dbo].[User_Choice_Choices] NOCHECK CONSTRAINT [FK_User_Choice_Choices_Levels]
ALTER TABLE [dbo].[User_Choice_Choices] WITH NOCHECK ADD CONSTRAINT [FK_User_Choice_Choices_User_Choice_Names] FOREIGN KEY ([User_Choice_Names_Id]) REFERENCES [dbo].[User_Choice_Names] ([User_Choice_Names_Id]) NOT FOR REPLICATION
ALTER TABLE [dbo].[User_Choice_Choices] NOCHECK CONSTRAINT [FK_User_Choice_Choices_User_Choice_Names]
-- Add constraints to [dbo].[Time_Zone]
ALTER TABLE [dbo].[Time_Zone] ADD CONSTRAINT [FK_Time_Zone_Levels] FOREIGN KEY ([Level_Id]) REFERENCES [dbo].[Levels] ([Level_Id])
-- Add constraints to [dbo].[TableNames]
ALTER TABLE [dbo].[TableNames] ADD CONSTRAINT [FK_TableNames_Levels] FOREIGN KEY ([Level_Id]) REFERENCES [dbo].[Levels] ([Level_Id])
-- Add constraints to [dbo].[States]
ALTER TABLE [dbo].[States] WITH NOCHECK ADD CONSTRAINT [FK_States_Country_Lookup] FOREIGN KEY ([Country_Id]) REFERENCES [dbo].[Countries] ([Country_Id])
ALTER TABLE [dbo].[States] WITH NOCHECK ADD CONSTRAINT [FK_States_Firm] FOREIGN KEY ([Firm_Id]) REFERENCES [dbo].[Firm] ([Firm_Id]) NOT FOR REPLICATION
ALTER TABLE [dbo].[States] NOCHECK CONSTRAINT [FK_States_Firm]
ALTER TABLE [dbo].[States] ADD CONSTRAINT [FK_States_Levels] FOREIGN KEY ([Level_Id]) REFERENCES [dbo].[Levels] ([Level_Id])
-- Add constraints to [dbo].[Levels]
ALTER TABLE [dbo].[Levels] WITH NOCHECK ADD CONSTRAINT [FK_Parent_Levels] FOREIGN KEY ([Parent_Level_Id]) REFERENCES [dbo].[Levels] ([Level_Id])
-- Add constraints to [dbo].[Currency_]
ALTER TABLE [dbo].[Currency_] ADD CONSTRAINT [FK_Currency__Levels] FOREIGN KEY ([Level_Id]) REFERENCES [dbo].[Levels] ([Level_Id])
-- Add constraints to [dbo].[Countries]
ALTER TABLE [dbo].[Countries] WITH NOCHECK ADD CONSTRAINT [FK_Countries_Levels] FOREIGN KEY ([Level_Id]) REFERENCES [dbo].[Levels] ([Level_Id])
ALTER TABLE [dbo].[Countries] WITH NOCHECK ADD CONSTRAINT [FK_Country_Lookup_Currency_] FOREIGN KEY ([Currency_Id]) REFERENCES [dbo].[Currency_] ([Currency_Id])
-- Add constraints to [dbo].[Counties]
ALTER TABLE [dbo].[Counties] WITH NOCHECK ADD CONSTRAINT [FK_Counties_Firm] FOREIGN KEY ([Firm_Id]) REFERENCES [dbo].[Firm] ([Firm_Id]) NOT FOR REPLICATION
ALTER TABLE [dbo].[Counties] NOCHECK CONSTRAINT [FK_Counties_Firm]
ALTER TABLE [dbo].[Counties] ADD CONSTRAINT [FK_Counties_Levels] FOREIGN KEY ([Level_Id]) REFERENCES [dbo].[Levels] ([Level_Id])
ALTER TABLE [dbo].[Counties] WITH NOCHECK ADD CONSTRAINT [FK_Counties_States] FOREIGN KEY ([State_Id]) REFERENCES [dbo].[States] ([States_Id])
-- Add constraints to [dbo].[Cost_Center]
ALTER TABLE [dbo].[Cost_Center] WITH NOCHECK ADD CONSTRAINT [FK_Cost_Centers_Cost_Center_Category] FOREIGN KEY ([Cost_Center_Category_Id]) REFERENCES [dbo].[Cost_Center_Category] ([Cost_Center_Category_Id])
ALTER TABLE [dbo].[Cost_Center] WITH NOCHECK ADD CONSTRAINT [FK_Cost_Centers_Levels] FOREIGN KEY ([Level_Id]) REFERENCES [dbo].[Levels] ([Level_Id])
-- Add constraints to [dbo].[CheckList_Step]
ALTER TABLE [dbo].[CheckList_Step] WITH NOCHECK ADD CONSTRAINT [FK_Action_Plan_Step_Action_Plan] FOREIGN KEY ([Checklist_Id]) REFERENCES [dbo].[CheckList] ([Checklist_Id])
ALTER TABLE [dbo].[CheckList_Step] ADD CONSTRAINT [FK_CheckList_Step_Levels] FOREIGN KEY ([Level_Id]) REFERENCES [dbo].[Levels] ([Level_Id])
-- Add constraints to [dbo].[CheckList]
ALTER TABLE [dbo].[CheckList] WITH NOCHECK ADD CONSTRAINT [FK_Action_Plan_Employee] FOREIGN KEY ([Author_Id]) REFERENCES [dbo].[Employee] ([Employee_Id])
ALTER TABLE [dbo].[CheckList] WITH NOCHECK ADD CONSTRAINT [FK_Action_Plan_Firm] FOREIGN KEY ([Firm_Id]) REFERENCES [dbo].[Firm] ([Firm_Id])
ALTER TABLE [dbo].[CheckList] ADD CONSTRAINT [FK_CheckList_Levels] FOREIGN KEY ([Level_Id]) REFERENCES [dbo].[Levels] ([Level_Id])
COMMIT TRANSACTION
XML Parsing Line1, character 58 semicolon expected
And the following is a copy of the SQL generated by SQL Data Compare:
/*
Script created by SQL Data Compare version 5.2.0.40 from Red Gate Software Ltd at 8/27/2007 5:51:34 AM
Run this script on (local).EmptyClient0
This script will make changes to (local).EmptyClient0 to make it the same as (local).Client0
Note that this script will carry out all DELETE commands for all tables first, then all the UPDATES and then all the INSERTS
It will disable foreign key constraints at the beginning of the script, and re-enable them at the end
*/
SET NUMERIC_ROUNDABORT OFF
GO
SET XACT_ABORT, ANSI_PADDING, ANSI_WARNINGS, CONCAT_NULL_YIELDS_NULL, ARITHABORT, QUOTED_IDENTIFIER, ANSI_NULLS, NOCOUNT ON
GO
-- Pointer used for text / image updates. This might not be needed, but is declared here just in case
DECLARE @pv binary(16)
BEGIN TRANSACTION
-- Drop constraints from [dbo].[User_Choice_Names]
ALTER TABLE [dbo].[User_Choice_Names] DROP CONSTRAINT [FK_User_Choice_Names_Levels]
-- Drop constraints from [dbo].[User_Choice_Choices]
ALTER TABLE [dbo].[User_Choice_Choices] DROP CONSTRAINT [FK_User_Choice_Choices_Levels]
ALTER TABLE [dbo].[User_Choice_Choices] DROP CONSTRAINT [FK_User_Choice_Choices_User_Choice_Names]
-- Drop constraints from [dbo].[Time_Zone]
ALTER TABLE [dbo].[Time_Zone] DROP CONSTRAINT [FK_Time_Zone_Levels]
-- Drop constraints from [dbo].[TableNames]
ALTER TABLE [dbo].[TableNames] DROP CONSTRAINT [FK_TableNames_Levels]
-- Drop constraints from [dbo].[States]
ALTER TABLE [dbo].[States] DROP CONSTRAINT [FK_States_Country_Lookup]
ALTER TABLE [dbo].[States] DROP CONSTRAINT [FK_States_Firm]
ALTER TABLE [dbo].[States] DROP CONSTRAINT [FK_States_Levels]
-- Drop constraints from [dbo].[Levels]
ALTER TABLE [dbo].[Levels] DROP CONSTRAINT [FK_Parent_Levels]
-- Drop constraints from [dbo].[Currency_]
ALTER TABLE [dbo].[Currency_] DROP CONSTRAINT [FK_Currency__Levels]
-- Drop constraints from [dbo].[Countries]
ALTER TABLE [dbo].[Countries] DROP CONSTRAINT [FK_Countries_Levels]
ALTER TABLE [dbo].[Countries] DROP CONSTRAINT [FK_Country_Lookup_Currency_]
-- Drop constraints from [dbo].[Counties]
ALTER TABLE [dbo].[Counties] DROP CONSTRAINT [FK_Counties_Firm]
ALTER TABLE [dbo].[Counties] DROP CONSTRAINT [FK_Counties_Levels]
ALTER TABLE [dbo].[Counties] DROP CONSTRAINT [FK_Counties_States]
-- Drop constraints from [dbo].[Cost_Center]
ALTER TABLE [dbo].[Cost_Center] DROP CONSTRAINT [FK_Cost_Centers_Cost_Center_Category]
ALTER TABLE [dbo].[Cost_Center] DROP CONSTRAINT [FK_Cost_Centers_Levels]
-- Drop constraints from [dbo].[CheckList_Step]
ALTER TABLE [dbo].[CheckList_Step] DROP CONSTRAINT [FK_Action_Plan_Step_Action_Plan]
ALTER TABLE [dbo].[CheckList_Step] DROP CONSTRAINT [FK_CheckList_Step_Levels]
-- Drop constraints from [dbo].[CheckList]
ALTER TABLE [dbo].[CheckList] DROP CONSTRAINT [FK_Action_Plan_Employee]
ALTER TABLE [dbo].[CheckList] DROP CONSTRAINT [FK_Action_Plan_Firm]
ALTER TABLE [dbo].[CheckList] DROP CONSTRAINT [FK_CheckList_Levels]
-- Delete 2 rows from [dbo].[User_Choice_Choices]
DELETE FROM [dbo].[User_Choice_Choices] WHERE [User_Choice_Choices_Id]=60
DELETE FROM [dbo].[User_Choice_Choices] WHERE [User_Choice_Choices_Id]=62
-- Delete 1 row from [dbo].[Countries]
DELETE FROM [dbo].[Countries] WHERE [Country_Id]=10
-- Update 17 rows in [dbo].[User_Choice_Choices]
UPDATE [dbo].[User_Choice_Choices] SET [User_Choice_String_Name]=N'2', [Edit_Date]='20070422 08:44:36.107', [Edit_UserId]=1 WHERE [User_Choice_Choices_Id]=7
UPDATE [dbo].[User_Choice_Choices] SET [User_Choice_String_Name]=N'4', [Edit_Date]='20070422 08:44:45.420' WHERE [User_Choice_Choices_Id]=13
UPDATE [dbo].[User_Choice_Choices] SET [User_Choice_String_Name]=N'1', [Edit_Date]='20070422 08:44:31.280' WHERE [User_Choice_Choices_Id]=20
UPDATE [dbo].[User_Choice_Choices] SET [User_Choice_String_Name]=N'3', [Edit_Date]='20070422 08:44:40.763' WHERE [User_Choice_Choices_Id]=21
UPDATE [dbo].[User_Choice_Choices] SET [Edit_Date]='20070502 17:24:50.967', [Edit_UserId]=5 WHERE [User_Choice_Choices_Id]=83
UPDATE [dbo].[User_Choice_Choices] SET [Ordinal]=6, [Edit_Date]='20070127 19:45:47.480' WHERE [User_Choice_Choices_Id]=100
UPDATE [dbo].[User_Choice_Choices] SET [User_Choice_String_Name]=N'Document Ref.', [Edit_Date]='20070403 05:20:37.170' WHERE [User_Choice_Choices_Id]=147
UPDATE [dbo].[User_Choice_Choices] SET [User_Choice_String_Name]=N'Evidence Ref.', [Edit_Date]='20070403 05:20:55.827' WHERE [User_Choice_Choices_Id]=148
UPDATE [dbo].[User_Choice_Choices] SET [User_Choice_String_Name]=N'Fact', [Edit_Date]='20070403 05:21:10.920' WHERE [User_Choice_Choices_Id]=149
UPDATE [dbo].[User_Choice_Choices] SET [User_Choice_String_Name]=N'Issue', [Edit_Date]='20070403 05:21:21.420' WHERE [User_Choice_Choices_Id]=150
UPDATE [dbo].[User_Choice_Choices] SET [User_Choice_String_Name]=N'Deposition', [Edit_Date]='20070531 10:34:03.107' WHERE [User_Choice_Choices_Id]=155
UPDATE [dbo].[User_Choice_Choices] SET [User_Choice_String_Name]=N'Dispute', [Edit_Date]='20070403 05:16:26.293' WHERE [User_Choice_Choices_Id]=156
UPDATE [dbo].[User_Choice_Choices] SET [User_Choice_String_Name]=N'Discovery', [Edit_Date]='20070403 05:17:47.607' WHERE [User_Choice_Choices_Id]=157
UPDATE [dbo].[User_Choice_Choices] SET [Ordinal]=5, [User_Choice_String_Name]=N'Evidence', [Edit_Date]='20070403 05:19:21.733' WHERE [User_Choice_Choices_Id]=158
UPDATE [dbo].[User_Choice_Choices] SET [Ordinal]=4, [User_Choice_String_Name]=N'Documentation', [Edit_Date]='20070403 05:19:11.687' WHERE [User_Choice_Choices_Id]=159
UPDATE [dbo].[User_Choice_Choices] SET [Edit_Date]='20070807 00:24:52.937', [Edit_UserId]=7 WHERE [User_Choice_Choices_Id]=172
UPDATE [dbo].[User_Choice_Choices] SET [Edit_Date]='20070807 00:29:52.450', [Edit_UserId]=7 WHERE [User_Choice_Choices_Id]=173
-- Update 2 rows in [dbo].[Time_Zone]
UPDATE [dbo].[Time_Zone] SET [TZI]=N'', [Edit_Date]='20070816 13:59:29.607', [Edit_UserId]=7, [Level_Id]=1 WHERE [Time_Zone_Id]=17
UPDATE [dbo].[Time_Zone] SET [TZI]=N'', [Edit_Date]='20070531 10:40:41.233', [Level_Id]=1 WHERE [Time_Zone_Id]=21
-- Update 1 row in [dbo].[TableNames]
UPDATE [dbo].[TableNames] SET [IconFileId]=51 WHERE [TableId]=103
-- Update 60 rows in [dbo].[States]
UPDATE [dbo].[States] SET [Edit_Date]='20070531 10:40:01.187', [Edit_UserId]=1, [PortalId]=0, [Level_Id]=1 WHERE [States_Id]=2
UPDATE [dbo].[States] SET [PortalId]=0 WHERE [States_Id]=3
UPDATE [dbo].[States] SET [PortalId]=0 WHERE [States_Id]=4
UPDATE [dbo].[States] SET [PortalId]=0 WHERE [States_Id]=5
UPDATE [dbo].[States] SET [PortalId]=0 WHERE [States_Id]=6
UPDATE [dbo].[States] SET [PortalId]=0 WHERE [States_Id]=7
UPDATE [dbo].[States] SET [PortalId]=0 WHERE [States_Id]=8
UPDATE [dbo].[States] SET [PortalId]=0 WHERE [States_Id]=9
UPDATE [dbo].[States] SET [PortalId]=0 WHERE [States_Id]=10
UPDATE [dbo].[States] SET [Edit_Date]='20070816 13:58:31.043', [Edit_UserId]=7, [PortalId]=0, [Level_Id]=1 WHERE [States_Id]=11
UPDATE [dbo].[States] SET [PortalId]=0 WHERE [States_Id]=12
UPDATE [dbo].[States] SET [PortalId]=0 WHERE [States_Id]=13
UPDATE [dbo].[States] SET [PortalId]=0 WHERE [States_Id]=14
UPDATE [dbo].[States] SET [PortalId]=0 WHERE [States_Id]=15
UPDATE [dbo].[States] SET [PortalId]=0 WHERE [States_Id]=16
UPDATE [dbo].[States] SET [PortalId]=0 WHERE [States_Id]=17
UPDATE [dbo].[States] SET [PortalId]=0 WHERE [States_Id]=18
UPDATE [dbo].[States] SET [PortalId]=0 WHERE [States_Id]=19
UPDATE [dbo].[States] SET [PortalId]=0 WHERE [States_Id]=20
UPDATE [dbo].[States] SET [PortalId]=0 WHERE [States_Id]=21
UPDATE [dbo].[States] SET [PortalId]=0 WHERE [States_Id]=22
UPDATE [dbo].[States] SET [PortalId]=0 WHERE [States_Id]=23
UPDATE [dbo].[States] SET [PortalId]=0 WHERE [States_Id]=24
UPDATE [dbo].[States] SET [PortalId]=0 WHERE [States_Id]=25
UPDATE [dbo].[States] SET [PortalId]=0 WHERE [States_Id]=26
UPDATE [dbo].[States] SET [PortalId]=0 WHERE [States_Id]=27
UPDATE [dbo].[States] SET [PortalId]=0 WHERE [States_Id]=28
UPDATE [dbo].[States] SET [PortalId]=0 WHERE [States_Id]=29
UPDATE [dbo].[States] SET [PortalId]=0 WHERE [States_Id]=30
UPDATE [dbo].[States] SET [PortalId]=0 WHERE [States_Id]=31
UPDATE [dbo].[States] SET [PortalId]=0 WHERE [States_Id]=32
UPDATE [dbo].[States] SET [PortalId]=0 WHERE [States_Id]=33
UPDATE [dbo].[States] SET [PortalId]=0 WHERE [States_Id]=34
UPDATE [dbo].[States] SET [PortalId]=0 WHERE [States_Id]=35
UPDATE [dbo].[States] SET [PortalId]=0 WHERE [States_Id]=36
UPDATE [dbo].[States] SET [PortalId]=0 WHERE [States_Id]=37
UPDATE [dbo].[States] SET [PortalId]=0 WHERE [States_Id]=38
UPDATE [dbo].[States] SET [PortalId]=0 WHERE [States_Id]=39
UPDATE [dbo].[States] SET [PortalId]=0 WHERE [States_Id]=40
UPDATE [dbo].[States] SET [PortalId]=0 WHERE [States_Id]=41
UPDATE [dbo].[States] SET [PortalId]=0 WHERE [States_Id]=42
UPDATE [dbo].[States] SET [PortalId]=0 WHERE [States_Id]=43
UPDATE [dbo].[States] SET [PortalId]=0 WHERE [States_Id]=44
UPDATE [dbo].[States] SET [PortalId]=0 WHERE [States_Id]=45
UPDATE [dbo].[States] SET [PortalId]=0 WHERE [States_Id]=46
UPDATE [dbo].[States] SET [PortalId]=0 WHERE [States_Id]=47
UPDATE [dbo].[States] SET [PortalId]=0 WHERE [States_Id]=48
UPDATE [dbo].[States] SET [PortalId]=0 WHERE [States_Id]=49
UPDATE [dbo].[States] SET [PortalId]=0 WHERE [States_Id]=50
UPDATE [dbo].[States] SET [PortalId]=0 WHERE [States_Id]=51
UPDATE [dbo].[States] SET [PortalId]=0 WHERE [States_Id]=52
UPDATE [dbo].[States] SET [PortalId]=0 WHERE [States_Id]=53
UPDATE [dbo].[States] SET [PortalId]=0 WHERE [States_Id]=54
UPDATE [dbo].[States] SET [PortalId]=0 WHERE [States_Id]=55
UPDATE [dbo].[States] SET [PortalId]=0 WHERE [States_Id]=56
UPDATE [dbo].[States] SET [PortalId]=0 WHERE [States_Id]=57
UPDATE [dbo].[States] SET [PortalId]=0 WHERE [States_Id]=58
UPDATE [dbo].[States] SET [PortalId]=0 WHERE [States_Id]=59
UPDATE [dbo].[States] SET [PortalId]=0 WHERE [States_Id]=60
UPDATE [dbo].[States] SET [PortalId]=0 WHERE [States_Id]=61
-- Update 1 row in [dbo].[Levels]
UPDATE [dbo].[Levels] SET [Name]=N'Level One', [Create_Date]='20060101 00:00:00.000', [Edit_Date]='20060101 00:00:00.000', [PortalId]=NULL WHERE [Level_Id]=1
-- Update 3 rows in [dbo].[Currency_]
UPDATE [dbo].[Currency_] SET [Currency_Symbol]=N'', [Edit_Date]='20070531 10:38:09.030', [Level_Id]=1 WHERE [Currency_Id]=1
UPDATE [dbo].[Currency_] SET [Currency_Symbol]=N'', [Edit_Date]='20070816 13:55:13.980', [Edit_UserId]=7, [Level_Id]=1 WHERE [Currency_Id]=12
UPDATE [dbo].[Currency_] SET [Currency_Symbol]=N'$', [Edit_Date]='20070816 13:54:47.997', [Edit_UserId]=7, [Level_Id]=1 WHERE [Currency_Id]=89
-- Update 2 rows in [dbo].[Countries]
UPDATE [dbo].[Countries] SET [Currency_Id]=1, [Phone_Code]=85, [Edit_Date]='20070817 01:49:04.483', [Edit_UserId]=17, [Level_Id]=1 WHERE [Country_Id]=1
UPDATE [dbo].[Countries] SET [Currency_Id]=2, [Phone_Code]=0, [Edit_Date]='20070601 04:53:00.797', [Edit_UserId]=17, [Level_Id]=1 WHERE [Country_Id]=3
-- Update 1 row in [dbo].[Counties]
UPDATE [dbo].[Counties] SET [Edit_Date]='20070806 23:58:20.437', [Edit_UserId]=7, [Level_Id]=1 WHERE [Counties_Id]=329
-- Add 9 rows to [dbo].[LevelRelationships]
INSERT INTO [dbo].[LevelRelationships] ([Level_ID], [Parent_Level_ID], [Depth]) VALUES (2, 1, 0)
INSERT INTO [dbo].[LevelRelationships] ([Level_ID], [Parent_Level_ID], [Depth]) VALUES (3, 1, 0)
INSERT INTO [dbo].[LevelRelationships] ([Level_ID], [Parent_Level_ID], [Depth]) VALUES (4, 2, 1)
INSERT INTO [dbo].[LevelRelationships] ([Level_ID], [Parent_Level_ID], [Depth]) VALUES (4, 1, 0)
INSERT INTO [dbo].[LevelRelationships] ([Level_ID], [Parent_Level_ID], [Depth]) VALUES (5, 3, 1)
INSERT INTO [dbo].[LevelRelationships] ([Level_ID], [Parent_Level_ID], [Depth]) VALUES (5, 1, 0)
INSERT INTO [dbo].[LevelRelationships] ([Level_ID], [Parent_Level_ID], [Depth]) VALUES (6, 5, 2)
INSERT INTO [dbo].[LevelRelationships] ([Level_ID], [Parent_Level_ID], [Depth]) VALUES (6, 3, 1)
INSERT INTO [dbo].[LevelRelationships] ([Level_ID], [Parent_Level_ID], [Depth]) VALUES (6, 1, 0)
-- Add 1 row to [dbo].[CheckList]
SET IDENTITY_INSERT [dbo].[CheckList] ON
INSERT INTO [dbo].[CheckList] ([Checklist_Id], [Author_Id], [Firm_Id], [Create_Date], [Edit_Date], [CheckList_Name], [Description], [Modification_Date], [Type], [Category], [State], [County], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (18, 8, 1, '20070816 11:28:16.607', '20070816 11:28:16.607', N'Motion to Dismiss', N'Motion to Dismiss Practices', NULL, N'Hearing', N'Official Court Process', N'TX', N'', 7, 7, 0, 1)
SET IDENTITY_INSERT [dbo].[CheckList] OFF
-- Add 4 rows to [dbo].[CheckList_Step]
SET IDENTITY_INSERT [dbo].[CheckList_Step] ON
INSERT INTO [dbo].[CheckList_Step] ([Checklist_Step_Id], [Checklist_Id], [Checklist_Step_Name], [Date_Offset], [Priority], [Type], [Description], [Notes], [Access_Type], [Activity_Type], [Ordinal], [Primary_Item], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (18, 18, N'Motion to Dismiss Hearing', 0, N'1', NULL, N'Motion Hearing Date', N'Activity Notes go here for Motion Hearing Date', N'Public', N'Court Date', 7, 1, '20070816 11:39:53.920', '20070816 11:39:53.920', 7, 7, 0, 1)
INSERT INTO [dbo].[CheckList_Step] ([Checklist_Step_Id], [Checklist_Id], [Checklist_Step_Name], [Date_Offset], [Priority], [Type], [Description], [Notes], [Access_Type], [Activity_Type], [Ordinal], [Primary_Item], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (21, 18, N'Prepare Arguments', 4, N'1', NULL, N'Create Arguments', N'Prep work', N'Public', N'Appointment', 5, NULL, '20070816 11:42:20.000', '20070816 11:44:19.827', 7, 7, 0, 1)
INSERT INTO [dbo].[CheckList_Step] ([Checklist_Step_Id], [Checklist_Id], [Checklist_Step_Name], [Date_Offset], [Priority], [Type], [Description], [Notes], [Access_Type], [Activity_Type], [Ordinal], [Primary_Item], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (22, 18, N'File Hearing Docs with Court', 10, N'1', NULL, N'Preparing Docs For Hearing', N'Preparing Docs For Hearing', N'Public', N'Appointment', 3, NULL, '20070816 11:43:54.590', '20070816 11:43:54.590', 7, 7, 0, 1)
INSERT INTO [dbo].[CheckList_Step] ([Checklist_Step_Id], [Checklist_Id], [Checklist_Step_Name], [Date_Offset], [Priority], [Type], [Description], [Notes], [Access_Type], [Activity_Type], [Ordinal], [Primary_Item], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (23, 18, N'Prepare Application for Motion', 15, N'1', NULL, N'Application for Motion', N'More stuff to do', N'Public', N'Appointment', 1, NULL, '20070816 11:45:52.937', '20070816 11:45:52.937', 7, 7, 0, 1)
SET IDENTITY_INSERT [dbo].[CheckList_Step] OFF
-- Add 5 rows to [dbo].[Cost_Center]
SET IDENTITY_INSERT [dbo].[Cost_Center] ON
INSERT INTO [dbo].[Cost_Center] ([Cost_Center_Id], [Cost_Center_Category_Id], [Name], [Code], [Create_Date], [Edit_Date], [Create_UserId], [Edit_UserId], [PortalId], [Level_Id]) VALUES (0, NULL, N'Car', N'C1', '20070103 10:31:35.000', '20070103 10:31:35.000', 1, 1, 0, 1)
INSERT INTO [dbo].[Cost_Center] ([Cost_Center_Id], [Cost_Center_Category_Id], [Name], [Code], [Create_Date], [Edit_Date], [Create_UserId], [Edit_UserId], [PortalId], [Level_Id]) VALUES (1, NULL, N'Phone', N'P1', '20070103 10:31:35.000', '20070103 10:31:35.000', 1, 1, 0, 1)
INSERT INTO [dbo].[Cost_Center] ([Cost_Center_Id], [Cost_Center_Category_Id], [Name], [Code], [Create_Date], [Edit_Date], [Create_UserId], [Edit_UserId], [PortalId], [Level_Id]) VALUES (2, NULL, N'Food', N'F1', '20070103 10:31:35.000', '20070103 10:31:35.000', 1, 1, 0, 1)
INSERT INTO [dbo].[Cost_Center] ([Cost_Center_Id], [Cost_Center_Category_Id], [Name], [Code], [Create_Date], [Edit_Date], [Create_UserId], [Edit_UserId], [PortalId], [Level_Id]) VALUES (3, NULL, N'Hotel', N'H1', '20070103 10:31:35.000', '20070103 10:31:35.000', 1, 1, 0, 1)
INSERT INTO [dbo].[Cost_Center] ([Cost_Center_Id], [Cost_Center_Category_Id], [Name], [Code], [Create_Date], [Edit_Date], [Create_UserId], [Edit_UserId], [PortalId], [Level_Id]) VALUES (4, NULL, N'Entertainment', N'E1', '20070103 10:31:35.000', '20070103 10:31:35.000', 1, 1, 0, 1)
SET IDENTITY_INSERT [dbo].[Cost_Center] OFF
-- Add 5 rows to [dbo].[Levels]
SET IDENTITY_INSERT [dbo].[Levels] ON
INSERT INTO [dbo].[Levels] ([Level_Id], [Parent_Level_Id], [Name], [Description], [Create_Date], [Edit_Date], [Create_UserId], [Edit_UserId], [PortalId]) VALUES (2, 1, N'Level Two', NULL, '20060101 00:00:00.000', '20060101 00:00:00.000', 1, 1, NULL)
INSERT INTO [dbo].[Levels] ([Level_Id], [Parent_Level_Id], [Name], [Description], [Create_Date], [Edit_Date], [Create_UserId], [Edit_UserId], [PortalId]) VALUES (3, 1, N'Level Three', NULL, '20060101 00:00:00.000', '20060101 00:00:00.000', 1, 1, NULL)
INSERT INTO [dbo].[Levels] ([Level_Id], [Parent_Level_Id], [Name], [Description], [Create_Date], [Edit_Date], [Create_UserId], [Edit_UserId], [PortalId]) VALUES (4, 2, N'Level Four', NULL, '20060101 00:00:00.000', '20060101 00:00:00.000', 1, 1, NULL)
INSERT INTO [dbo].[Levels] ([Level_Id], [Parent_Level_Id], [Name], [Description], [Create_Date], [Edit_Date], [Create_UserId], [Edit_UserId], [PortalId]) VALUES (5, 3, N'Level Five', NULL, '20060101 00:00:00.000', '20060101 00:00:00.000', 1, 1, NULL)
INSERT INTO [dbo].[Levels] ([Level_Id], [Parent_Level_Id], [Name], [Description], [Create_Date], [Edit_Date], [Create_UserId], [Edit_UserId], [PortalId]) VALUES (6, 5, N'Level Six', NULL, NULL, NULL, NULL, NULL, NULL)
SET IDENTITY_INSERT [dbo].[Levels] OFF
-- Add 62 rows to [dbo].[User_Choice_Choices]
SET IDENTITY_INSERT [dbo].[User_Choice_Choices] ON
INSERT INTO [dbo].[User_Choice_Choices] ([User_Choice_Choices_Id], [User_Choice_Names_Id], [Ordinal], [User_Choice_String_Name], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (221, 35, 5, N'Court Associate', '20070127 19:45:41.030', '20070127 19:45:41.030', 1, 1, 0, 1)
INSERT INTO [dbo].[User_Choice_Choices] ([User_Choice_Choices_Id], [User_Choice_Names_Id], [Ordinal], [User_Choice_String_Name], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (222, 65, 1, N'Open', '20070204 08:45:21.030', '20070204 08:45:21.030', 1, 1, 0, 1)
INSERT INTO [dbo].[User_Choice_Choices] ([User_Choice_Choices_Id], [User_Choice_Names_Id], [Ordinal], [User_Choice_String_Name], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (223, 65, 2, N'Submitted', '20070204 08:45:28.030', '20070204 08:45:28.030', 1, 1, 0, 1)
INSERT INTO [dbo].[User_Choice_Choices] ([User_Choice_Choices_Id], [User_Choice_Names_Id], [Ordinal], [User_Choice_String_Name], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (224, 65, 3, N'Approved', '20070204 08:45:35.030', '20070204 08:45:35.030', 1, 1, 0, 1)
INSERT INTO [dbo].[User_Choice_Choices] ([User_Choice_Choices_Id], [User_Choice_Names_Id], [Ordinal], [User_Choice_String_Name], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (225, 65, 4, N'Paid', '20070204 08:45:41.577', '20070204 08:45:41.577', 1, 1, 0, 1)
INSERT INTO [dbo].[User_Choice_Choices] ([User_Choice_Choices_Id], [User_Choice_Names_Id], [Ordinal], [User_Choice_String_Name], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (226, 66, 1, N'Hot', '20070213 04:06:05.233', '20070213 04:06:05.233', 17, 17, 0, 1)
INSERT INTO [dbo].[User_Choice_Choices] ([User_Choice_Choices_Id], [User_Choice_Names_Id], [Ordinal], [User_Choice_String_Name], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (227, 66, 2, N'Medium', '20070213 04:08:09.967', '20070213 04:08:09.967', 5, 5, 0, 1)
INSERT INTO [dbo].[User_Choice_Choices] ([User_Choice_Choices_Id], [User_Choice_Names_Id], [Ordinal], [User_Choice_String_Name], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (228, 66, 3, N'Low', '20070213 04:08:17.670', '20070213 04:08:17.670', 5, 5, 0, 1)
INSERT INTO [dbo].[User_Choice_Choices] ([User_Choice_Choices_Id], [User_Choice_Names_Id], [Ordinal], [User_Choice_String_Name], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (229, 67, 1, N'Web', '20070213 04:10:06.873', '20070213 04:10:06.873', 5, 5, 0, 1)
INSERT INTO [dbo].[User_Choice_Choices] ([User_Choice_Choices_Id], [User_Choice_Names_Id], [Ordinal], [User_Choice_String_Name], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (230, 67, 2, N'Call In', '20070213 04:10:17.437', '20070213 04:10:17.437', 5, 5, 0, 1)
INSERT INTO [dbo].[User_Choice_Choices] ([User_Choice_Choices_Id], [User_Choice_Names_Id], [Ordinal], [User_Choice_String_Name], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (231, 67, 3, N'Referral', '20070213 04:10:29.263', '20070213 04:10:29.263', 5, 5, 0, 1)
INSERT INTO [dbo].[User_Choice_Choices] ([User_Choice_Choices_Id], [User_Choice_Names_Id], [Ordinal], [User_Choice_String_Name], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (232, 68, 1, N'In Progress', '20070213 04:10:49.530', '20070213 04:10:49.530', 5, 5, 0, 1)
INSERT INTO [dbo].[User_Choice_Choices] ([User_Choice_Choices_Id], [User_Choice_Names_Id], [Ordinal], [User_Choice_String_Name], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (233, 68, 2, N'On Hold', '20070213 04:10:58.483', '20070213 04:10:58.483', 5, 5, 0, 1)
INSERT INTO [dbo].[User_Choice_Choices] ([User_Choice_Choices_Id], [User_Choice_Names_Id], [Ordinal], [User_Choice_String_Name], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (234, 68, 3, N'Archived', '20070213 04:11:12.077', '20070213 04:11:12.077', 5, 5, 0, 1)
INSERT INTO [dbo].[User_Choice_Choices] ([User_Choice_Choices_Id], [User_Choice_Names_Id], [Ordinal], [User_Choice_String_Name], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (235, 68, 4, N'Processed', '20070213 04:11:22.200', '20070213 04:11:22.200', 5, 5, 0, 1)
INSERT INTO [dbo].[User_Choice_Choices] ([User_Choice_Choices_Id], [User_Choice_Names_Id], [Ordinal], [User_Choice_String_Name], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (236, 69, 1, N'Custody', '20070213 04:12:03.217', '20070213 04:12:03.217', 5, 5, 0, 1)
INSERT INTO [dbo].[User_Choice_Choices] ([User_Choice_Choices_Id], [User_Choice_Names_Id], [Ordinal], [User_Choice_String_Name], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (237, 69, 2, N'Bankruptcy', '20070213 04:12:20.653', '20070213 04:12:20.653', 5, 5, 0, 1)
INSERT INTO [dbo].[User_Choice_Choices] ([User_Choice_Choices_Id], [User_Choice_Names_Id], [Ordinal], [User_Choice_String_Name], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (238, 69, 3, N'Divorce', '20070213 04:12:30.903', '20070213 04:12:30.903', 5, 5, 0, 1)
INSERT INTO [dbo].[User_Choice_Choices] ([User_Choice_Choices_Id], [User_Choice_Names_Id], [Ordinal], [User_Choice_String_Name], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (239, 69, 4, N'Civil', '20070213 04:12:41.013', '20070213 04:12:41.013', 5, 5, 0, 1)
INSERT INTO [dbo].[User_Choice_Choices] ([User_Choice_Choices_Id], [User_Choice_Names_Id], [Ordinal], [User_Choice_String_Name], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (240, 49, 6, N'Other', '20070403 05:19:31.763', '20070403 05:19:31.763', 1, 1, 0, 1)
INSERT INTO [dbo].[User_Choice_Choices] ([User_Choice_Choices_Id], [User_Choice_Names_Id], [Ordinal], [User_Choice_String_Name], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (241, 49, 7, N'Transcript', '20070403 05:19:40.500', '20070403 05:19:40.500', 1, 1, 0, 1)
INSERT INTO [dbo].[User_Choice_Choices] ([User_Choice_Choices_Id], [User_Choice_Names_Id], [Ordinal], [User_Choice_String_Name], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (242, 49, 8, N'Violation', '20070403 05:19:48.873', '20070403 05:19:48.873', 1, 1, 0, 1)
INSERT INTO [dbo].[User_Choice_Choices] ([User_Choice_Choices_Id], [User_Choice_Names_Id], [Ordinal], [User_Choice_String_Name], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (243, 49, 9, N'Witness', '20070403 05:19:56.700', '20070403 05:19:56.700', 1, 1, 0, 1)
INSERT INTO [dbo].[User_Choice_Choices] ([User_Choice_Choices_Id], [User_Choice_Names_Id], [Ordinal], [User_Choice_String_Name], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (244, 47, 5, N'Note', '20070403 05:21:30.390', '20070403 05:21:30.390', 1, 1, 0, 1)
INSERT INTO [dbo].[User_Choice_Choices] ([User_Choice_Choices_Id], [User_Choice_Names_Id], [Ordinal], [User_Choice_String_Name], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (245, 47, 6, N'Other', '20070403 05:21:36.950', '20070403 05:21:36.950', 1, 1, 0, 1)
INSERT INTO [dbo].[User_Choice_Choices] ([User_Choice_Choices_Id], [User_Choice_Names_Id], [Ordinal], [User_Choice_String_Name], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (246, 47, 7, N'Research', '20070403 05:21:46.733', '20070403 05:21:46.733', 1, 1, 0, 1)
INSERT INTO [dbo].[User_Choice_Choices] ([User_Choice_Choices_Id], [User_Choice_Names_Id], [Ordinal], [User_Choice_String_Name], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (247, 70, 1, N'In Progress', '20070421 10:41:06.640', '20070421 10:41:06.640', 1, 1, 0, 1)
INSERT INTO [dbo].[User_Choice_Choices] ([User_Choice_Choices_Id], [User_Choice_Names_Id], [Ordinal], [User_Choice_String_Name], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (248, 70, 2, N'Resolved', '20070421 10:41:17.310', '20070421 10:41:17.310', 1, 1, 0, 1)
INSERT INTO [dbo].[User_Choice_Choices] ([User_Choice_Choices_Id], [User_Choice_Names_Id], [Ordinal], [User_Choice_String_Name], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (249, 70, 3, N'Outstanding', '20070421 10:41:26.700', '20070421 10:41:26.700', 1, 1, 0, 1)
INSERT INTO [dbo].[User_Choice_Choices] ([User_Choice_Choices_Id], [User_Choice_Names_Id], [Ordinal], [User_Choice_String_Name], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (250, 70, 4, N'Court Accepted', '20070421 10:41:39.467', '20070421 10:41:39.467', 1, 1, 0, 1)
INSERT INTO [dbo].[User_Choice_Choices] ([User_Choice_Choices_Id], [User_Choice_Names_Id], [Ordinal], [User_Choice_String_Name], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (251, 70, 5, N'Mutually Accepted', '20070421 10:41:49.263', '20070421 10:41:49.263', 1, 1, 0, 1)
INSERT INTO [dbo].[User_Choice_Choices] ([User_Choice_Choices_Id], [User_Choice_Names_Id], [Ordinal], [User_Choice_String_Name], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (252, 70, 6, N'Disputed Us', '20070421 10:42:00.640', '20070421 10:42:00.640', 1, 1, 0, 1)
INSERT INTO [dbo].[User_Choice_Choices] ([User_Choice_Choices_Id], [User_Choice_Names_Id], [Ordinal], [User_Choice_String_Name], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (253, 70, 7, N'Disputed Them', '20070421 10:42:08.640', '20070421 10:42:08.640', 1, 1, 0, 1)
INSERT INTO [dbo].[User_Choice_Choices] ([User_Choice_Choices_Id], [User_Choice_Names_Id], [Ordinal], [User_Choice_String_Name], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (254, 2, 5, N'5', '20070422 08:44:48.607', '20070422 08:44:48.607', 1, 1, 0, 1)
INSERT INTO [dbo].[User_Choice_Choices] ([User_Choice_Choices_Id], [User_Choice_Names_Id], [Ordinal], [User_Choice_String_Name], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (255, 71, 1, N'Alltel', '20070422 09:05:30.717', '20070422 09:05:30.717', 1, 1, 0, 1)
INSERT INTO [dbo].[User_Choice_Choices] ([User_Choice_Choices_Id], [User_Choice_Names_Id], [Ordinal], [User_Choice_String_Name], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (256, 71, 2, N'AT&T', '20070422 09:05:37.983', '20070422 09:05:37.983', 1, 1, 0, 1)
INSERT INTO [dbo].[User_Choice_Choices] ([User_Choice_Choices_Id], [User_Choice_Names_Id], [Ordinal], [User_Choice_String_Name], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (257, 71, 3, N'Bell Atlantic', '20070422 09:05:47.357', '20070422 09:05:47.357', 1, 1, 0, 1)
INSERT INTO [dbo].[User_Choice_Choices] ([User_Choice_Choices_Id], [User_Choice_Names_Id], [Ordinal], [User_Choice_String_Name], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (258, 71, 4, N'Bell Canada', '20070422 09:05:56.483', '20070422 09:05:56.483', 1, 1, 0, 1)
INSERT INTO [dbo].[User_Choice_Choices] ([User_Choice_Choices_Id], [User_Choice_Names_Id], [Ordinal], [User_Choice_String_Name], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (259, 71, 5, N'Cellular One', '20070422 09:06:04.500', '20070422 09:06:04.500', 1, 1, 0, 1)
INSERT INTO [dbo].[User_Choice_Choices] ([User_Choice_Choices_Id], [User_Choice_Names_Id], [Ordinal], [User_Choice_String_Name], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (260, 71, 6, N'CellularOneTX', '20070422 09:06:13.793', '20070422 09:06:13.793', 1, 1, 0, 1)
INSERT INTO [dbo].[User_Choice_Choices] ([User_Choice_Choices_Id], [User_Choice_Names_Id], [Ordinal], [User_Choice_String_Name], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (261, 71, 7, N'Cingular', '20070422 09:06:19.437', '20070422 09:06:19.437', 1, 1, 0, 1)
INSERT INTO [dbo].[User_Choice_Choices] ([User_Choice_Choices_Id], [User_Choice_Names_Id], [Ordinal], [User_Choice_String_Name], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (262, 71, 8, N'Fido', '20070422 09:06:24.840', '20070422 09:06:24.840', 1, 1, 0, 1)
INSERT INTO [dbo].[User_Choice_Choices] ([User_Choice_Choices_Id], [User_Choice_Names_Id], [Ordinal], [User_Choice_String_Name], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (263, 71, 9, N'HickoryTech', '20070422 09:06:35.793', '20070422 09:06:35.793', 1, 1, 0, 1)
INSERT INTO [dbo].[User_Choice_Choices] ([User_Choice_Choices_Id], [User_Choice_Names_Id], [Ordinal], [User_Choice_String_Name], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (264, 71, 10, N'Nextel', '20070422 09:06:44.840', '20070422 09:06:44.840', 1, 1, 0, 1)
INSERT INTO [dbo].[User_Choice_Choices] ([User_Choice_Choices_Id], [User_Choice_Names_Id], [Ordinal], [User_Choice_String_Name], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (265, 71, 11, N'Qwest', '20070422 09:06:54.030', '20070422 09:06:54.030', 1, 1, 0, 1)
INSERT INTO [dbo].[User_Choice_Choices] ([User_Choice_Choices_Id], [User_Choice_Names_Id], [Ordinal], [User_Choice_String_Name], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (266, 71, 12, N'SprintPCS', '20070422 09:07:00.263', '20070422 09:07:00.263', 1, 1, 0, 1)
INSERT INTO [dbo].[User_Choice_Choices] ([User_Choice_Choices_Id], [User_Choice_Names_Id], [Ordinal], [User_Choice_String_Name], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (267, 71, 13, N'SureWest', '20070422 09:07:07.200', '20070422 09:07:07.200', 1, 1, 0, 1)
INSERT INTO [dbo].[User_Choice_Choices] ([User_Choice_Choices_Id], [User_Choice_Names_Id], [Ordinal], [User_Choice_String_Name], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (268, 71, 14, N'TelusMobility', '20070422 09:07:14.467', '20070422 09:07:14.467', 1, 1, 0, 1)
INSERT INTO [dbo].[User_Choice_Choices] ([User_Choice_Choices_Id], [User_Choice_Names_Id], [Ordinal], [User_Choice_String_Name], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (269, 71, 15, N'TMobile', '20070422 09:07:19.763', '20070422 09:07:19.763', 1, 1, 0, 1)
INSERT INTO [dbo].[User_Choice_Choices] ([User_Choice_Choices_Id], [User_Choice_Names_Id], [Ordinal], [User_Choice_String_Name], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (270, 71, 16, N'Verizon', '20070422 09:07:25.763', '20070422 09:07:25.763', 1, 1, 0, 1)
INSERT INTO [dbo].[User_Choice_Choices] ([User_Choice_Choices_Id], [User_Choice_Names_Id], [Ordinal], [User_Choice_String_Name], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (271, 73, 1, N'Documentation', '20070503 08:05:18.967', '20070730 12:54:24.577', 7, 17, 0, 1)
INSERT INTO [dbo].[User_Choice_Choices] ([User_Choice_Choices_Id], [User_Choice_Names_Id], [Ordinal], [User_Choice_String_Name], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (272, 73, 2, N'Preparation', '20070503 08:05:26.280', '20070730 12:54:32.950', 7, 17, 0, 1)
INSERT INTO [dbo].[User_Choice_Choices] ([User_Choice_Choices_Id], [User_Choice_Names_Id], [Ordinal], [User_Choice_String_Name], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (273, 73, 3, N'Official Court Process', '20070503 08:05:32.140', '20070730 12:54:45.530', 7, 17, 0, 1)
INSERT INTO [dbo].[User_Choice_Choices] ([User_Choice_Choices_Id], [User_Choice_Names_Id], [Ordinal], [User_Choice_String_Name], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (274, 73, 4, N'Internal Process', '20070503 08:05:39.483', '20070730 12:54:54.640', 7, 17, 0, 1)
INSERT INTO [dbo].[User_Choice_Choices] ([User_Choice_Choices_Id], [User_Choice_Names_Id], [Ordinal], [User_Choice_String_Name], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (275, 72, 1, N'Case Docket', '20070503 08:05:55.700', '20070730 12:52:07.560', 7, 17, 0, 1)
INSERT INTO [dbo].[User_Choice_Choices] ([User_Choice_Choices_Id], [User_Choice_Names_Id], [Ordinal], [User_Choice_String_Name], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (276, 72, 2, N'Trial', '20070503 08:06:02.093', '20070730 12:50:51.950', 7, 17, 0, 1)
INSERT INTO [dbo].[User_Choice_Choices] ([User_Choice_Choices_Id], [User_Choice_Names_Id], [Ordinal], [User_Choice_String_Name], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (277, 72, 3, N'Hearing', '20070503 08:06:07.090', '20070730 12:51:00.340', 7, 17, 0, 1)
INSERT INTO [dbo].[User_Choice_Choices] ([User_Choice_Choices_Id], [User_Choice_Names_Id], [Ordinal], [User_Choice_String_Name], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (278, 72, 4, N'Deposition', '20070503 08:06:11.717', '20070730 12:52:21.903', 7, 17, 0, 1)
INSERT INTO [dbo].[User_Choice_Choices] ([User_Choice_Choices_Id], [User_Choice_Names_Id], [Ordinal], [User_Choice_String_Name], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (284, 57, 0, N'Amex', '20070816 13:45:52.153', '20070816 13:45:52.153', 7, 7, 0, 1)
INSERT INTO [dbo].[User_Choice_Choices] ([User_Choice_Choices_Id], [User_Choice_Names_Id], [Ordinal], [User_Choice_String_Name], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (285, 28, 0, N'Legal Form', '20070816 13:46:31.500', '20070816 13:46:31.500', 7, 7, 0, 1)
INSERT INTO [dbo].[User_Choice_Choices] ([User_Choice_Choices_Id], [User_Choice_Names_Id], [Ordinal], [User_Choice_String_Name], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (286, 28, 0, N'More Form', '20070816 13:46:53.933', '20070816 13:46:53.933', 7, 7, 0, 1)
INSERT INTO [dbo].[User_Choice_Choices] ([User_Choice_Choices_Id], [User_Choice_Names_Id], [Ordinal], [User_Choice_String_Name], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (287, 28, 0, N'Cheese Cake', '20070816 13:47:08.343', '20070816 13:47:08.343', 7, 7, 0, 1)
SET IDENTITY_INSERT [dbo].[User_Choice_Choices] OFF
-- Add 9 rows to [dbo].[User_Choice_Names]
SET IDENTITY_INSERT [dbo].[User_Choice_Names] ON
INSERT INTO [dbo].[User_Choice_Names] ([User_Choice_Names_Id], [User_Choice_Name], [UnEditable], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (65, N'Expense Status', NULL, '20070204 08:45:06.390', '20070204 08:45:06.390', 1, 1, 0, 1)
INSERT INTO [dbo].[User_Choice_Names] ([User_Choice_Names_Id], [User_Choice_Name], [UnEditable], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (66, N'Lead Quality', NULL, '20070213 04:03:34.060', '20070213 04:03:34.060', 17, 17, 0, 1)
INSERT INTO [dbo].[User_Choice_Names] ([User_Choice_Names_Id], [User_Choice_Name], [UnEditable], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (67, N'Lead Source', NULL, '20070213 04:04:19.200', '20070213 04:04:19.200', 17, 17, 0, 1)
INSERT INTO [dbo].[User_Choice_Names] ([User_Choice_Names_Id], [User_Choice_Name], [UnEditable], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (68, N'Lead Status', NULL, '20070213 04:05:05.590', '20070213 04:05:05.590', 17, 17, 0, 1)
INSERT INTO [dbo].[User_Choice_Names] ([User_Choice_Names_Id], [User_Choice_Name], [UnEditable], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (69, N'Lead Type', NULL, '20070213 04:11:41.420', '20070213 04:11:41.420', 5, 5, 0, 1)
INSERT INTO [dbo].[User_Choice_Names] ([User_Choice_Names_Id], [User_Choice_Name], [UnEditable], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (70, N'Issue Status', NULL, '20070421 10:40:48.467', '20070421 10:40:48.467', 1, 1, 0, 1)
INSERT INTO [dbo].[User_Choice_Names] ([User_Choice_Names_Id], [User_Choice_Name], [UnEditable], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (71, N'Cell Phone Providers', NULL, '20070422 09:05:18.437', '20070422 09:05:18.437', 1, 1, 0, 1)
INSERT INTO [dbo].[User_Choice_Names] ([User_Choice_Names_Id], [User_Choice_Name], [UnEditable], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (72, N'BP Type', NULL, '20070503 08:04:55.140', '20070503 08:04:55.140', 17, 17, 0, 1)
INSERT INTO [dbo].[User_Choice_Names] ([User_Choice_Names_Id], [User_Choice_Name], [UnEditable], [Create_Date], [Edit_Date], [Edit_UserId], [Create_UserId], [PortalId], [Level_Id]) VALUES (73, N'BP Category', NULL, '20070503 08:05:04.200', '20070503 08:05:04.200', 17, 17, 0, 1)
SET IDENTITY_INSERT [dbo].[User_Choice_Names] OFF
-- Add constraints to [dbo].[User_Choice_Names]
ALTER TABLE [dbo].[User_Choice_Names] WITH NOCHECK ADD CONSTRAINT [FK_User_Choice_Names_Levels] FOREIGN KEY ([Level_Id]) REFERENCES [dbo].[Levels] ([Level_Id])
-- Add constraints to [dbo].[User_Choice_Choices]
ALTER TABLE [dbo].[User_Choice_Choices] WITH NOCHECK ADD CONSTRAINT [FK_User_Choice_Choices_Levels] FOREIGN KEY ([Level_Id]) REFERENCES [dbo].[Levels] ([Level_Id]) NOT FOR REPLICATION
ALTER TABLE [dbo].[User_Choice_Choices] NOCHECK CONSTRAINT [FK_User_Choice_Choices_Levels]
ALTER TABLE [dbo].[User_Choice_Choices] WITH NOCHECK ADD CONSTRAINT [FK_User_Choice_Choices_User_Choice_Names] FOREIGN KEY ([User_Choice_Names_Id]) REFERENCES [dbo].[User_Choice_Names] ([User_Choice_Names_Id]) NOT FOR REPLICATION
ALTER TABLE [dbo].[User_Choice_Choices] NOCHECK CONSTRAINT [FK_User_Choice_Choices_User_Choice_Names]
-- Add constraints to [dbo].[Time_Zone]
ALTER TABLE [dbo].[Time_Zone] ADD CONSTRAINT [FK_Time_Zone_Levels] FOREIGN KEY ([Level_Id]) REFERENCES [dbo].[Levels] ([Level_Id])
-- Add constraints to [dbo].[TableNames]
ALTER TABLE [dbo].[TableNames] ADD CONSTRAINT [FK_TableNames_Levels] FOREIGN KEY ([Level_Id]) REFERENCES [dbo].[Levels] ([Level_Id])
-- Add constraints to [dbo].[States]
ALTER TABLE [dbo].[States] WITH NOCHECK ADD CONSTRAINT [FK_States_Country_Lookup] FOREIGN KEY ([Country_Id]) REFERENCES [dbo].[Countries] ([Country_Id])
ALTER TABLE [dbo].[States] WITH NOCHECK ADD CONSTRAINT [FK_States_Firm] FOREIGN KEY ([Firm_Id]) REFERENCES [dbo].[Firm] ([Firm_Id]) NOT FOR REPLICATION
ALTER TABLE [dbo].[States] NOCHECK CONSTRAINT [FK_States_Firm]
ALTER TABLE [dbo].[States] ADD CONSTRAINT [FK_States_Levels] FOREIGN KEY ([Level_Id]) REFERENCES [dbo].[Levels] ([Level_Id])
-- Add constraints to [dbo].[Levels]
ALTER TABLE [dbo].[Levels] WITH NOCHECK ADD CONSTRAINT [FK_Parent_Levels] FOREIGN KEY ([Parent_Level_Id]) REFERENCES [dbo].[Levels] ([Level_Id])
-- Add constraints to [dbo].[Currency_]
ALTER TABLE [dbo].[Currency_] ADD CONSTRAINT [FK_Currency__Levels] FOREIGN KEY ([Level_Id]) REFERENCES [dbo].[Levels] ([Level_Id])
-- Add constraints to [dbo].[Countries]
ALTER TABLE [dbo].[Countries] WITH NOCHECK ADD CONSTRAINT [FK_Countries_Levels] FOREIGN KEY ([Level_Id]) REFERENCES [dbo].[Levels] ([Level_Id])
ALTER TABLE [dbo].[Countries] WITH NOCHECK ADD CONSTRAINT [FK_Country_Lookup_Currency_] FOREIGN KEY ([Currency_Id]) REFERENCES [dbo].[Currency_] ([Currency_Id])
-- Add constraints to [dbo].[Counties]
ALTER TABLE [dbo].[Counties] WITH NOCHECK ADD CONSTRAINT [FK_Counties_Firm] FOREIGN KEY ([Firm_Id]) REFERENCES [dbo].[Firm] ([Firm_Id]) NOT FOR REPLICATION
ALTER TABLE [dbo].[Counties] NOCHECK CONSTRAINT [FK_Counties_Firm]
ALTER TABLE [dbo].[Counties] ADD CONSTRAINT [FK_Counties_Levels] FOREIGN KEY ([Level_Id]) REFERENCES [dbo].[Levels] ([Level_Id])
ALTER TABLE [dbo].[Counties] WITH NOCHECK ADD CONSTRAINT [FK_Counties_States] FOREIGN KEY ([State_Id]) REFERENCES [dbo].[States] ([States_Id])
-- Add constraints to [dbo].[Cost_Center]
ALTER TABLE [dbo].[Cost_Center] WITH NOCHECK ADD CONSTRAINT [FK_Cost_Centers_Cost_Center_Category] FOREIGN KEY ([Cost_Center_Category_Id]) REFERENCES [dbo].[Cost_Center_Category] ([Cost_Center_Category_Id])
ALTER TABLE [dbo].[Cost_Center] WITH NOCHECK ADD CONSTRAINT [FK_Cost_Centers_Levels] FOREIGN KEY ([Level_Id]) REFERENCES [dbo].[Levels] ([Level_Id])
-- Add constraints to [dbo].[CheckList_Step]
ALTER TABLE [dbo].[CheckList_Step] WITH NOCHECK ADD CONSTRAINT [FK_Action_Plan_Step_Action_Plan] FOREIGN KEY ([Checklist_Id]) REFERENCES [dbo].[CheckList] ([Checklist_Id])
ALTER TABLE [dbo].[CheckList_Step] ADD CONSTRAINT [FK_CheckList_Step_Levels] FOREIGN KEY ([Level_Id]) REFERENCES [dbo].[Levels] ([Level_Id])
-- Add constraints to [dbo].[CheckList]
ALTER TABLE [dbo].[CheckList] WITH NOCHECK ADD CONSTRAINT [FK_Action_Plan_Employee] FOREIGN KEY ([Author_Id]) REFERENCES [dbo].[Employee] ([Employee_Id])
ALTER TABLE [dbo].[CheckList] WITH NOCHECK ADD CONSTRAINT [FK_Action_Plan_Firm] FOREIGN KEY ([Firm_Id]) REFERENCES [dbo].[Firm] ([Firm_Id])
ALTER TABLE [dbo].[CheckList] ADD CONSTRAINT [FK_CheckList_Levels] FOREIGN KEY ([Level_Id]) REFERENCES [dbo].[Levels] ([Level_Id])
COMMIT TRANSACTION
Comments
I'd check your data for the failing data as you know your schema better than I do.
HTH
Project Manager
Red Gate Software Ltd