Cannot create db from data file

[rwyarger]

Hello -

I am currently running SQL Packager 5.4.0.89 in 14-day trial mode. My company is having me evaluate this product to see if it might be able to assist us with version control, and just overall better db management of our base and Proddb's.

My problem however is that after creating a schema and data file with SQL Packager - I am unable to create a new db with these files. I have tried the following...

- Creating a .NET exe (error was logged with tech support).

- Creating the db in Microsoft SQL Management Studio (both express and standard have been used with the exact same result...Insufficient System Memory to execute query)

- Creating the db with sqlcmd from the command line (same error as with the Management Studio product).

I have yet to be able to recreate one of our db's with the product.

Any help from anyone would be really appreciated.

Thank you,

Rich Yarger
Hill-Rom Configuration Analyst

[rwyarger]

Just to follow up on this thread - here is the error I am getting when trying to recreate the database with the .NET executable that is generated from the SQL Packager tool...

SQL Error: TemplateID,SubCellID MUST EXIST IN DISPLAY_SUBCELLS TABLE
The transaction ended in the trigger. The batch has been aborted.


Assmbly: create_dbStore1


Package: Package28.resx


Batch:Batch51


<SQLError Package="create_db"><Error>TemplateID,SubCellID MUST EXIST IN DISPLAY_SUBCELLS TABLE
The transaction ended in the trigger. The batch has been aborted.</Error><Assembly>create_dbStore1</Assembly><Package>Package28.resx</Package><Batch>Batch51</Batch><SQL>DECLARE @pv binary(16)
INSERT INTO [dbo].[DB_VARS_HISTORY] ([ID], [TheKey], [LastUpdate], [TheValue], [TheTextValue]) VALUES (46, 'SchemaVersion', '20070905 00:02:37.490', 0, '538')
INSERT INTO [dbo].[DB_VARS_HISTORY] ([ID], [TheKey], [LastUpdate], [TheValue], [TheTextValue]) VALUES (47, 'SchemaVersion', '20070905 00:02:37.490', 0, '539')
INSERT INTO [dbo].[DB_VARS_HISTORY] ([ID], [TheKey], [LastUpdate], [TheValue], [TheTextValue]) VALUES (48, 'SchemaVersion', '20070905 00:02:37.490', 0, '540')
INSERT INTO [dbo].[DB_VARS_HISTORY] ([ID], [TheKey], [LastUpdate], [TheValue], [TheTextValue]) VALUES (49, 'SchemaVersion', '20070905 00:02:37.490', 0, '541')
INSERT INTO [dbo].[DB_VARS_HISTORY] ([ID], [TheKey], [LastUpdate], [TheValue], [TheTextValue]) VALUES (50, 'SchemaVersion', '20070905 00:02:37.490', 0, '542')
INSERT INTO [dbo].[DB_VARS_HISTORY] ([ID], [TheKey], [LastUpdate], [TheValue], [TheTextValue]) VALUES (51, 'SchemaVersion', '20070905 00:02:37.490', 0, '543')
INSERT INTO [dbo].[DB_VARS_HISTORY] ([ID], [TheKey], [LastUpdate], [TheValue], [TheTextValue]) VALUES (52, 'SchemaVersion', '20070905 00:02:37.490', 0, '544')
INSERT INTO [dbo].[DB_VARS_HISTORY] ([ID], [TheKey], [LastUpdate], [TheValue], [TheTextValue]) VALUES (53, 'SchemaVersion', '20070905 00:02:37.490', 0, '545')
INSERT INTO [dbo].[DB_VARS_HISTORY] ([ID], [TheKey], [LastUpdate], [TheValue], [TheTextValue]) VALUES (54, 'ReportServerName', '20070905 19:16:27.533', 1, 'ENTER REPORT SERVER NAME HERE')
INSERT INTO [dbo].[DB_VARS_HISTORY] ([ID], [TheKey], [LastUpdate], [TheValue], [TheTextValue]) VALUES (55, 'StandardReports', '20070905 20:00:08.420', 8, 'Release')
INSERT INTO [dbo].[DB_VARS_HISTORY] ([ID], [TheKey], [LastUpdate], [TheValue], [TheTextValue]) VALUES (56, 'ReportServerName', '20070905 20:00:08.437', 1, 'HRNACANCRDPRD12')
INSERT INTO [dbo].[DB_VARS_HISTORY] ([ID], [TheKey], [LastUpdate], [TheValue], [TheTextValue]) VALUES (57, 'StandardReports', '20070907 12:14:15.870', 8, 'Release')
INSERT INTO [dbo].[DB_VARS_HISTORY] ([ID], [TheKey], [LastUpdate], [TheValue], [TheTextValue]) VALUES (58, 'ReportServerName', '20070907 12:14:15.980', 1, 'MCDHAPPNC04')
SET IDENTITY_INSERT [dbo].[DB_VARS_HISTORY] OFF
INSERT INTO [dbo].[DIALOG_CONTROLS] ([DialogID], [ControlID], [Name], [ControlType], [DefaultText], [StringID], [ControlTop], [ControlLeft], [ControlHeight], [ControlWidth], [FieldID], [EventList], [EventID], [ClearEventID], [DefaultState], [Required], [LeftAction], [RightAction], [JustifyText], [ReadOnly], [MultiLine], [Border], [DisplayCondition], [DateTimeType], [ErrorText], [RoleID], [ParentControl], [ZoneID], [ListID], [ViewPrivilege], [EditPrivilege], [SubCellID], [TemplateID], [DisplayUnits], [EditCondition], [RequireCondition], [ROWID]) VALUES (2, 100, 'patient label', 1, 'Patient Information', NULL, 5, 8, 8, 34, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '73b48cdb-cb18-4e74-97b8-e8c343093bb8')
INSERT INTO [dbo].[DIALOG_CONTROLS] ([DialogID], [ControlID], [Name], [ControlType], [DefaultText], [StringID], [ControlTop], [ControlLeft], [ControlHeight], [ControlWidth], [FieldID], [EventList], [EventID], [ClearEventID], [DefaultState], [Required], [LeftAction], [RightAction], [JustifyText], [ReadOnly], [MultiLine], [Border], [DisplayCondition], [DateTimeType], [ErrorText], [RoleID], [ParentControl], [ZoneID], [ListID], [ViewPrivilege], [EditPrivilege], [SubCellID], [TemplateID], [DisplayUnits], [EditCondition], [RequireCondition], [ROWID]) VALUES (2, 110, 'Last Label', 1, 'Last Name:', NULL, 17, 8, 8, 34, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'a240ee63-d71a-4c87-89f1-18915dd8bbde')
INSERT INTO [dbo].[DIALOG_CONTROLS] ([DialogID], [ControlID], [Name], [ControlType], [DefaultText], [StringID], [ControlTop], [ControlLeft], [ControlHeight], [ControlWidth], [FieldID], [EventList], [EventID], [ClearEventID], [DefaultState], [Required], [LeftAction], [RightAction], [JustifyText], [ReadOnly], [MultiLine], [Border], [DisplayCondition], [DateTimeType], [ErrorText], [RoleID], [ParentControl], [ZoneID], [ListID], [ViewPrivilege], [EditPrivilege], [SubCellID], [TemplateID], [DisplayUnits], [EditCondition], [RequireCondition], [ROWID]) VALUES (2, 111, 'Last Name', 2, NULL, NULL, 14, 51, 12, 63, -116, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '03970142-2ed1-48d1-9ea0-529c632ec035')
INSERT INTO [dbo].[DIALOG_CONTROLS] ([DialogID], [ControlID], [Name], [ControlType], [DefaultText], [StringID], [ControlTop], [ControlLeft], [ControlHeight], [ControlWidth], [FieldID], [EventList], [EventID], [ClearEventID], [DefaultState], [Required], [LeftAction], [RightAction], [JustifyText], [ReadOnly], [MultiLine], [Border], [DisplayCondition], [DateTimeType], [ErrorText], [RoleID], [ParentControl], [ZoneID], [ListID], [ViewPrivilege], [EditPrivilege], [SubCellID], [TemplateID], [DisplayUnits], [EditCondition], [RequireCondition], [ROWID]) VALUES (2, 112, 'First Label', 1, 'First Name:', NULL, 32, 8, 8, 34, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'e708a9ee-f956-45dc-b309-6b0cdf77d983')
INSERT INTO [dbo].[DIALOG_CONTROLS] ([DialogID], [ControlID], [Name], [ControlType], [DefaultText], [StringID], [ControlTop], [ControlLeft], [ControlHeight], [ControlWidth], [FieldID], [EventList], [EventID], [ClearEventID], [DefaultState], [Required], [LeftAction], [RightAction], [JustifyText], [ReadOnly], [MultiLine], [Border], [DisplayCondition], [DateTimeType], [ErrorText], [RoleID], [ParentControl], [ZoneID], [ListID], [ViewPrivilege], [EditPrivilege], [SubCellID], [TemplateID], [DisplayUnits], [EditCondition], [RequireCondition], [ROWID]) VALUES (2, 113, 'First Name', 2, NULL, NULL, 29, 51, 12, 63, -117, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '3c0fde9e-cae0-4c1f-ab23-c3fe71bc8c25')
INSERT INTO [dbo].[DIALOG_CONTROLS] ([DialogID], [ControlID], [Name], [ControlType], [DefaultText], [StringID], [ControlTop], [ControlLeft], [ControlHeight], [ControlWidth], [FieldID], [EventList], [EventID], [ClearEventID], [DefaultState], [Required], [LeftAction], [RightAction], [JustifyText], [ReadOnly], [MultiLine], [Border], [DisplayCondition], [DateTimeType], [ErrorText], [RoleID], [ParentControl], [ZoneID], [ListID], [ViewPrivilege], [EditPrivilege], [SubCellID], [TemplateID], [DisplayUnits], [EditCondition], [RequireCondition], [ROWID]) VALUES (2, 114, 'Birthdate Label', 1, 'Birthdate:', NULL, 17, 118, 8, 34, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'a97a389c-b962-47e3-91af-8ce5dadf99c0')
INSERT INTO [dbo].[DIALOG_CONTROLS] ([DialogID], [ControlID], [Name], [ControlType], [DefaultText], [StringID], [ControlTop], [ControlLeft], [ControlHeight], [ControlWidth], [FieldID], [EventList], [EventID], [ClearEventID], [DefaultState], [Required], [LeftAction], [RightAction], [JustifyText], [ReadOnly], [MultiLine], [Border], [DisplayCondition], [DateTimeType], [ErrorText], [RoleID], [ParentControl], [ZoneID], [ListID], [ViewPrivilege], [EditPrivilege], [SubCellID], [TemplateID], [DisplayUnits], [EditCondition], [RequireCondition], [ROWID]) VALUES (2, 115, 'Birthdate', 9, NULL, NULL, 14, 160, 12, 42, -118, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, 1, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '22b1f2d7-23da-4a15-a7e4-b18cef6e7369')
INSERT INTO [dbo].[DIALOG_CONTROLS] ([DialogID], [ControlID], [Name], [ControlType], [DefaultText], [StringID], [ControlTop], [ControlLeft], [ControlHeight], [ControlWidth], [FieldID], [EventList], [EventID], [ClearEventID], [DefaultState], [Required], [LeftAction], [RightAction], [JustifyText], [ReadOnly], [MultiLine], [Border], [DisplayCondition], [DateTimeType], [ErrorText], [RoleID], [ParentControl], [ZoneID], [ListID], [ViewPrivilege], [EditPrivilege], [SubCellID], [TemplateID], [DisplayUnits], [EditCondition], [RequireCondition], [ROWID]) VALUES (2, 116, 'Gender Label', 1, 'Gender:', NULL, 32, 118, 8, 39, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'c2dacd90-8e65-470a-9006-005fbca77211')
INSERT INTO [dbo].[DIALOG_CONTROLS] ([DialogID], [ControlID], [Name], [ControlType], [DefaultText], [StringID], [ControlTop], [ControlLeft], [ControlHeight], [ControlWidth], [FieldID], [EventList], [EventID], [ClearEventID], [DefaultState], [Required], [LeftAction], [RightAction], [JustifyText], [ReadOnly], [MultiLine], [Border], [DisplayCondition], [DateTimeType], [ErrorText], [RoleID], [ParentControl], [ZoneID], [ListID], [ViewPrivilege], [EditPrivilege], [SubCellID], [TemplateID], [DisplayUnits], [EditCondition], [RequireCondition], [ROWID]) VALUES (2, 117, 'Gender', 2, NULL, NULL, 29, 160, 12, 9, -120, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'ea1fe7e0-3790-416d-9625-ed54ddb13c20')
INSERT INTO [dbo].[DIALOG_CONTROLS] ([DialogID], [ControlID], [Name], [ControlType], [DefaultText], [StringID], [ControlTop], [ControlLeft], [ControlHeight], [ControlWidth], [FieldID], [EventList], [EventID], [ClearEventID], [DefaultState], [Required], [LeftAction], [RightAction], [JustifyText], [ReadOnly], [MultiLine], [Border], [DisplayCondition], [DateTimeType], [ErrorText], [RoleID], [ParentControl], [ZoneID], [ListID], [ViewPrivilege], [EditPrivilege], [SubCellID], [TemplateID], [DisplayUnits], [EditCondition], [RequireCondition], [ROWID]) VALUES (2, 118, 'Pt Type Label', 1, 'Patient Type:', NULL, 47, 8, 8, 42, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1156b3a1-d69d-4612-bd55-888c5286d0b4')
INSERT INTO [dbo].[DIALOG_CONTROLS] ([DialogID], [ControlID], [Name], [ControlType], [DefaultText], [StringID], [ControlTop], [ControlLeft], [ControlHeight], [ControlWidth], [FieldID], [EventList], [EventID], [ClearEventID], [DefaultState], [Required], [LeftAction], [RightAction], [JustifyText], [ReadOnly], [MultiLine], [Border], [DisplayCondition], [DateTimeType], [ErrorText], [RoleID], [ParentControl], [ZoneID], [ListID], [ViewPrivilege], [EditPrivilege], [SubCellID], [TemplateID], [DisplayUnits], [EditCondition], [RequireCondition], [ROWID]) VALUES (2, 119, 'Pat Type', 2, NULL, NULL, 44, 51, 12, 40, -130, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'e2dea270-1aa8-4c28-b6ec-5225c5477248')
INSERT INTO [dbo].[DIALOG_CONTROLS] ([DialogID], [ControlID], [Name], [ControlType], [DefaultText], [StringID], [ControlTop], [ControlLeft], [ControlHeight], [ControlWidth], [FieldID], [EventList], [EventID], [ClearEventID], [DefaultState], [Required], [LeftAction], [RightAction], [JustifyText], [ReadOnly], [MultiLine], [Border], [DisplayCondition], [DateTimeType], [ErrorText], [RoleID], [ParentControl], [ZoneID], [ListID], [ViewPrivilege], [EditPrivilege], [SubCellID], [TemplateID], [DisplayUnits], [EditCondition], [RequireCondition], [ROWID]) VALUES (2, 120, 'SSN Label', 1, 'SSN:', NULL, 47, 118, 8, 33, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'd09ce668-9024-4c5d-8a0f-c97a163de874')
INSERT INTO [dbo].[DIALOG_CONTROLS] ([DialogID], [ControlID], [Name], [ControlType], [DefaultText], [StringID], [ControlTop], [ControlLeft], [ControlHeight], [ControlWidth], [FieldID], [EventList], [EventID], [ClearEventID], [DefaultState], [Required], [LeftAction], [RightAction], [JustifyText], [ReadOnly], [MultiLine], [Border], [DisplayCondition], [DateTimeType], [ErrorText], [RoleID], [ParentControl], [ZoneID], [ListID], [ViewPrivilege], [EditPrivilege], [SubCellID], [TemplateID], [DisplayUnits], [EditCondition], [RequireCondition], [ROWID]) VALUES (2, 121, 'SSN', 2, NULL, NULL, 44, 160, 12, 55, -119, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'f731e04e-6c5c-423d-a87b-13a09bac0151')
INSERT INTO [dbo].[DIALOG_CONTROLS] ([DialogID], [ControlID], [Name], [ControlType], [DefaultText], [StringID], [ControlTop], [ControlLeft], [ControlHeight], [ControlWidth], [FieldID], [EventList], [EventID], [ClearEventID], [DefaultState], [Required], [LeftAction], [RightAction], [JustifyText], [ReadOnly], [MultiLine], [Border], [DisplayCondition], [DateTimeType], [ErrorText], [RoleID], [ParentControl], [ZoneID], [ListID], [ViewPrivilege], [EditPrivilege], [SubCellID], [TemplateID], [DisplayUnits], [EditCondition], [RequireCondition], [ROWID]) VALUES (2, 123, 'Episode comments', 2, NULL, NULL, 59, 51, 22, 342, -127, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '864b8aa2-e104-4508-a7a3-f660dd028884')
INSERT INTO [dbo].[DIALOG_CONTROLS] ([DialogID], [ControlID], [Name], [ControlType], [DefaultText], [StringID], [ControlTop], [ControlLeft], [ControlHeight], [ControlWidth], [FieldID], [EventList], [EventID], [ClearEventID], [DefaultState], [Required], [LeftAction], [RightAction], [JustifyText], [ReadOnly], [MultiLine], [Border], [DisplayCondition], [DateTimeType], [ErrorText], [RoleID], [ParentControl], [ZoneID], [ListID], [ViewPrivilege], [EditPrivilege], [SubCellID], [TemplateID], [DisplayUnits], [EditCondition], [RequireCondition], [ROWID]) VALUES (2, 124, 'Comments Label', 1, 'Comments:', NULL, 60, 8, 9, 39, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'a702f65a-1a2f-42a1-a87b-f8a7a0350211')
INSERT INTO [dbo].[DIALOG_CONTROLS] ([DialogID], [ControlID], [Name], [ControlType], [DefaultText], [StringID], [ControlTop], [ControlLeft], [ControlHeight], [ControlWidth], [FieldID], [EventList], [EventID], [ClearEventID], [DefaultState], [Required], [LeftAction], [RightAction], [JustifyText], [ReadOnly], [MultiLine], [Border], [DisplayCondition], [DateTimeType], [ErrorText], [RoleID], [ParentControl], [ZoneID], [ListID], [ViewPrivilege], [EditPrivilege], [SubCellID], [TemplateID], [DisplayUnits], [EditCondition], [RequireCondition], [ROWID]) VALUES (2, 500, 'Location selection group', 14, 'Location Information', NULL, 90, 8, 100, 116, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 203, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '51156205-fec8-4eb5-8d7f-a690d1540705')
INSERT INTO [dbo].[DIALOG_CONTROLS] ([DialogID], [ControlID], [Name], [ControlType], [DefaultText], [StringID], [ControlTop], [ControlLeft], [ControlHeight], [ControlWidth], [FieldID], [EventList], [EventID], [ClearEventID], [DefaultState], [Required], [LeftAction], [RightAction], [JustifyText], [ReadOnly], [MultiLine], [Border], [DisplayCondition], [DateTimeType], [ErrorText], [RoleID], [ParentControl], [ZoneID], [ListID], [ViewPrivilege], [EditPrivilege], [SubCellID], [TemplateID], [DisplayUnits], [EditCondition], [RequireCondition], [ROWID]) VALUES (2, 501, 'Location Info Group', 6, 'Location Information', NULL, 90, 8, 100, 116, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '94f9d4ed-5e9a-4611-9a1f-13bb791c3977')
INSERT INTO [dbo].[DIALOG_CONTROLS] ([DialogID], [ControlID], [Name], [ControlType], [DefaultText], [StringID], [ControlTop], [ControlLeft], [ControlHeight], [ControlWidth], [FieldID], [EventList], [EventID], [ClearEventID], [DefaultState], [Required], [LeftAction], [RightAction], [JustifyText], [ReadOnly], [MultiLine], [Border], [DisplayCondition], [DateTimeType], [ErrorText], [RoleID], [ParentControl], [ZoneID], [ListID], [ViewPrivilege], [EditPrivilege], [SubCellID], [TemplateID], [DisplayUnits], [EditCondition], [RequireCondition], [ROWID]) VALUES (2, 503, 'Service', 1, NULL, NULL, 105, 43, 93, 78, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 500, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '6573b3e9-8ec5-4778-bbc2-c820588243ed')
INSERT INTO [dbo].[DIALOG_CONTROLS] ([DialogID], [ControlID], [Name], [ControlType], [DefaultText], [StringID], [ControlTop], [ControlLeft], [ControlHeight], [ControlWidth], [FieldID], [EventList], [EventID], [ClearEventID], [DefaultState], [Required], [LeftAction], [RightAction], [JustifyText], [ReadOnly], [MultiLine], [Border], [DisplayCondition], [DateTimeType], [ErrorText], [RoleID], [ParentControl], [ZoneID], [ListID], [ViewPrivilege], [EditPrivilege], [SubCellID], [TemplateID], [DisplayUnits], [EditCondition], [RequireCondition], [ROWID]) VALUES (2, 504, 'Service Label', 1, 'Service:', NULL, 103, 13, 8, 26, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '8f5a029f-7119-4284-b3a0-6986af0f7b7e')
INSERT INTO [dbo].[DIALOG_CONTROLS] ([DialogID], [ControlID], [Name], [ControlType], [DefaultText], [StringID], [ControlTop], [ControlLeft], [ControlHeight], [ControlWidth], [FieldID], [EventList], [EventID], [ClearEventID], [DefaultState], [Required], [LeftAction], [RightAction], [JustifyText], [ReadOnly], [MultiLine], [Border], [DisplayCondition], [DateTimeType], [ErrorText], [RoleID], [ParentControl], [ZoneID], [ListID], [ViewPrivilege], [EditPrivilege], [SubCellID], [TemplateID], [DisplayUnits], [EditCondition], [RequireCondition], [ROWID]) VALUES (2, 505, 'Area', 2, NULL, NULL, 119, 43, 178, 78, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 500, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'f4343222-556e-46fc-94fc-69be0765558f')
INSERT INTO [dbo].[DIALOG_CONTROLS] ([DialogID], [ControlID], [Name], [ControlType], [DefaultText], [StringID], [ControlTop], [ControlLeft], [ControlHeight], [ControlWidth], [FieldID], [EventList], [EventID], [ClearEventID], [DefaultState], [Required], [LeftAction], [RightAction], [JustifyText], [ReadOnly], [MultiLine], [Border], [DisplayCondition], [DateTimeType], [ErrorText], [RoleID], [ParentControl], [ZoneID], [ListID], [ViewPrivilege], [EditPrivilege], [SubCellID], [TemplateID], [DisplayUnits], [EditCondition], [RequireCondition], [ROWID]) VALUES (2, 506, 'Area Label', 1, 'Area:', NULL, 117, 13, 8, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'e05a5ec5-a94e-453e-bc5d-defff7e74926')
INSERT INTO [dbo].[DIALOG_CONTROLS] ([DialogID], [ControlID], [Name], [ControlType], [DefaultText], [StringID], [ControlTop], [ControlLeft], [ControlHeight], [ControlWidth], [FieldID], [EventList], [EventID], [ClearEventID], [DefaultState], [Required], [LeftAction], [RightAction], [JustifyText], [ReadOnly], [MultiLine], [Border], [DisplayCondition], [DateTimeType], [ErrorText], [RoleID], [ParentControl], [ZoneID], [ListID], [ViewPrivilege], [EditPrivilege], [SubCellID], [TemplateID], [DisplayUnits], [EditCondition], [RequireCondition], [ROWID]) VALUES (2, 507, 'Location', 3, NULL, NULL, 133, 43, 178, 78, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 500, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '66203c8b-bd73-420e-928e-ae2a7bbf7fac')
INSERT INTO [dbo].[DIALOG_CONTROLS] ([DialogID], [ControlID], [Name], [ControlType], [DefaultText], [StringID], [ControlTop], [ControlLeft], [ControlHeight], [ControlWidth], [FieldID], [EventList], [EventID], [ClearEventID], [DefaultState], [Required], [LeftAction], [RightAction], [JustifyText], [ReadOnly], [MultiLine], [Border], [DisplayCondition], [DateTimeType], [ErrorText], [RoleID], [ParentControl], [ZoneID], [ListID], [ViewPrivilege], [EditPrivilege], [SubCellID], [TemplateID], [DisplayUnits], [EditCondition], [RequireCondition], [ROWID]) VALUES (2, 508, 'Loc Label', 1, 'Location:', NULL, 131, 13, 8, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '04a6fd73-d3d4-411a-a332-e0264fbebd46')
INSERT INTO [dbo].[DIALOG_CONTROLS] ([DialogID], [ControlID], [Name], [ControlType], [DefaultText], [StringID], [ControlTop], [ControlLeft], [ControlHeight], [ControlWidth], [FieldID], [EventList], [EventID], [ClearEventID], [DefaultState], [Required], [LeftAction], [RightAction], [JustifyText], [ReadOnly], [MultiLine], [Border], [DisplayCondition], [DateTimeType], [ErrorText], [RoleID], [ParentControl], [ZoneID], [ListID], [ViewPrivilege], [EditPrivilege], [SubCellID], [TemplateID], [DisplayUnits], [EditCondition], [RequireCondition], [ROWID]) VALUES (2, 600, 'Sched info Group', 6, 'Schedule Information', NULL, 90, 128, 100, 108, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '5bb96292-bcb4-41a0-9c38-3078c3c44761')
INSERT INTO [dbo].[DIALOG_CONTROLS] ([DialogID], [ControlID], [Name], [ControlType], [DefaultText], [StringID], [ControlTop], [ControlLeft], [ControlHeight], [ControlWidth], [FieldID], [EventList], [EventID], [ClearEventID], [DefaultState], [Required], [LeftAction], [RightAction], [JustifyText], [ReadOnly], [MultiLine], [Border], [DisplayCondition], [DateTimeType], [ErrorText], [RoleID], [ParentControl], [ZoneID], [ListID], [ViewPrivilege], [EditPrivilege], [SubCellID], [TemplateID], [DisplayUnits], [EditCondition], [RequireCondition], [ROWID]) VALUES (2, 601, 'Date Label', 1, 'Scheduled Date:', NULL, 105, 131, 8, 53, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '4d149b4a-b5de-4d9d-8244-df7727188418')
INSERT INTO [dbo].[DIALOG_CONTROLS] ([DialogID], [ControlID], [Name], [ControlType], [DefaultText], [StringID], [ControlTop], [ControlLeft], [ControlHeight], [ControlWidth], [FieldID], [EventList], [EventID], [ClearEventID], [DefaultState], [Required], [LeftAction], [RightAction], [JustifyText], [ReadOnly], [MultiLine], [Border], [DisplayCondition], [DateTimeType], [ErrorText], [RoleID], [ParentControl], [ZoneID], [ListID], [ViewPrivilege], [EditPrivilege], [SubCellID], [TemplateID], [DisplayUnits], [EditCondition], [RequireCondition], [ROWID]) VALUES (2, 602, 'Date', 9, 'Today', NULL, 103, 187, 13, 38, -7, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, 1, NULL, 1, 'Please enter procedure date in format MM/DD/YY', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '7de6ff7c-4b59-4a16-a436-a46df9e06b4b')
INSERT INTO [dbo].[DIALOG_CONTROLS] ([DialogID], [ControlID], [Name], [ControlType], [DefaultText], [StringID], [ControlTop], [ControlLeft], [ControlHeight], [ControlWidth], [FieldID], [EventList], [EventID], [ClearEventID], [DefaultState], [Required], [LeftAction], [RightAction], [JustifyText], [ReadOnly], [MultiLine], [Border], [DisplayCondition], [DateTimeType], [ErrorText], [RoleID], [ParentControl], [ZoneID], [ListID], [ViewPrivilege], [EditPrivilege], [SubCellID], [TemplateID], [DisplayUnits], [EditCondition], [RequireCondition], [ROWID]) VALUES (2, 603, 'Time Label', 1, 'Time:', NULL, 119, 165, 8, 19, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0fef7757-0504-4a28-a38f-c7cef474c74a')
INSERT INTO [dbo].[DIALOG_CONTROLS] ([DialogID], [ControlID], [Name], [ControlType], [DefaultText], [StringID], [ControlTop], [ControlLeft], [ControlHeight], [ControlWidth], [FieldID], [EventList], [EventID], [ClearEventID], [DefaultState], [Required], [LeftAction], [RightAction], [JustifyText], [ReadOnly], [MultiLine], [Border], [DisplayCondition], [DateTimeType], [ErrorText], [RoleID], [ParentControl], [ZoneID], [ListID], [ViewPrivilege], [EditPrivilege], [SubCellID], [TemplateID], [DisplayUnits], [EditCondition], [RequireCondition], [ROWID]) VALUES (2, 604, 'Time', 9, NULL, NULL, 117, 187, 13, 38, -7, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, 1, NULL, 2, 'Please enter procedure time in format HH:MM', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '98c85f12-13a4-49e6-98ba-51cff26bd1be')
INSERT INTO [dbo].[DIALOG_CONTROLS] ([DialogID], [ControlID], [Name], [ControlType], [DefaultText], [StringID], [ControlTop], [ControlLeft], [ControlHeight], [ControlWidth], [FieldID], [EventList], [EventID], [ClearEventID], [DefaultState], [Required], [LeftAction], [RightAction], [JustifyText], [ReadOnly], [MultiLine], [Border], [DisplayCondition], [DateTimeType], [ErrorText], [RoleID], [ParentControl], [ZoneID], [ListID], [ViewPrivilege], [EditPrivilege], [SubCellID], [TemplateID], [DisplayUnits], [EditCondition], [RequireCondition], [ROWID]) VALUES (2, 605, 'Duration Label', 1, 'Duration:', NULL, 133, 154, 8, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2808e93e-40ca-401e-a0b6-7305e84eba74')
INSERT INTO [dbo].[DIALOG_CONTROLS] ([DialogID], [ControlID], [Name], [ControlType], [DefaultText], [StringID], [ControlTop], [ControlLeft], [ControlHeight], [ControlWidth], [FieldID], [EventList], [EventID], [ClearEventID], [DefaultState], [Required], [LeftAction], [RightAction], [JustifyText], [ReadOnly], [MultiLine], [Border], [DisplayCondition], [DateTimeType], [ErrorText], [RoleID], [ParentControl], [ZoneID], [ListID], [ViewPrivilege], [EditPrivilege], [SubCellID], [TemplateID], [DisplayUnits], [EditCondition], [RequireCondition], [ROWID]) VALUES (2, 606, 'Duration', 2, NULL, NULL, 131, 187, 13, 24, -11, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'fb0a8d7a-a400-4e2a-8842-a5fdb9be049b')
INSERT INTO [dbo].[DIALOG_CONTROLS] ([DialogID], [ControlID], [Name], [ControlType], [DefaultText], [StringID], [ControlTop], [ControlLeft], [ControlHeight], [ControlWidth], [FieldID], [EventList], [EventID], [ClearEventID], [DefaultState], [Required], [LeftAction], [RightAction], [JustifyText], [ReadOnly], [MultiLine], [Border], [DisplayCondition], [DateTimeType], [ErrorText], [RoleID], [ParentControl], [ZoneID], [ListID], [ViewPrivilege], [EditPrivilege], [SubCellID], [TemplateID], [DisplayUnits], [EditCondition], [RequireCondition], [ROWID]) VALUES (2, 607, 'Setup Label', 1, 'Setup:', NULL, 147, 160, 8, 24, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '08094c75-58d2-4d0c-b67a-86a76c6b6e52')
INSERT INTO [dbo].[DIALOG_CONTROLS] ([DialogID], [ControlID], [Name], [ControlType], [DefaultText], [StringID], [ControlTop], [ControlLeft], [ControlHeight], [ControlWidth], [FieldID], [EventList], [EventID], [ClearEventID], [DefaultState], [Required], [LeftAction], [RightAction], [JustifyText], [ReadOnly], [MultiLine], [Border], [DisplayCondition], [DateTimeType], [ErrorText], [RoleID], [ParentControl], [ZoneID], [ListID], [ViewPrivilege], [EditPrivilege], [SubCellID], [TemplateID], [DisplayUnits], [EditCondition], [RequireCondition], [ROWID]) VALUES (2, 608, 'Setup Duration', 2, NULL, NULL, 145, 187, 13, 24, -29, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '05281a28-5941-4684-a62c-ae8085c998e7')
INSERT INTO [dbo].[DIALOG_CONTROLS] ([DialogID], [ControlID], [Name], [ControlType], [DefaultText], [StringID], [ControlTop], [ControlLeft], [ControlHeight], [ControlWidth], [FieldID], [EventList], [EventID], [ClearEventID], [DefaultState], [Required], [LeftAction], [RightAction], [JustifyText], [ReadOnly], [MultiLine], [Border], [DisplayCondition], [DateTimeType], [ErrorText], [RoleID], [ParentControl], [ZoneID], [ListID], [ViewPrivilege], [EditPrivilege], [SubCellID], [TemplateID], [DisplayUnits], [EditCondition], [RequireCondition], [ROWID]) VALUES (2, 609, 'Cleanup Label', 1, 'Cleanup:', NULL, 161, 157, 8, 27, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '6e27b112-7de0-4fe5-b1c3-f925b1a6f106')
INSERT INTO [dbo].[DIALOG_CONTROLS] ([DialogID], [ControlID], [Name], [ControlType], [DefaultText], [StringID], [ControlTop], [ControlLeft], [ControlHeight], [ControlWidth], [FieldID], [EventList], [EventID], [ClearEventID], [DefaultState], [Required], [LeftAction], [RightAction], [JustifyText], [ReadOnly], [MultiLine], [Border], [DisplayCondition], [DateTimeType], [ErrorText], [RoleID], [ParentControl], [ZoneID], [ListID], [ViewPrivilege], [EditPrivilege], [SubCellID], [TemplateID], [DisplayUnits], [EditCondition], [RequireCondition], [ROWID]) VALUES (2, 610, 'Cleanup Duration', 2, NULL, NULL, 159, 187, 13, 24, -30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '4f65262f-5cc0-42d4-9b42-267a385ff4ba')
INSERT INTO [dbo].[DIALOG_CONTROLS] ([DialogID], [ControlID], [Name], [ControlType], [DefaultText], [StringID], [ControlTop], [ControlLeft], [ControlHeight], [ControlWidth], [FieldID], [EventList], [EventID], [ClearEventID], [DefaultState], [Required], [LeftAction], [RightAction], [JustifyText], [ReadOnly], [MultiLine], [Border], [DisplayCondition], [DateTimeType], [ErrorText], [RoleID], [ParentControl], [ZoneID], [ListID], [ViewPrivilege], [EditPrivilege], [SubCellID], [TemplateID], [DisplayUnits], [EditCondition], [RequireCondition], [ROWID]) VALUES (2, 611, 'To Follow Label', 1, 'To Follow Time:', NULL, 175, 134, 8, 50, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '3aeef00a-a96d-4951-81f0-ccecbcd4bc56')
INSERT INTO [dbo].[DIALOG_CONTROLS] ([DialogID], [ControlID], [Name], [ControlType], [DefaultText], [StringID], [ControlTop], [ControlLeft], [ControlHeight], [ControlWidth], [FieldID], [EventList], [EventID], [ClearEventID], [DefaultState], [Required], [LeftAction], [RightAction], [JustifyText], [ReadOnly], [MultiLine], [Border], [DisplayCondition], [DateTimeType], [ErrorText], [RoleID], [ParentControl], [ZoneID], [ListID], [ViewPrivilege], [EditPrivilege], [SubCellID], [TemplateID], [DisplayUnits], [EditCondition], [RequireCondition], [ROWID]) VALUES (2, 612, 'TF Time', 9, NULL, NULL, 173, 187, 13, 40, -9, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, 2, 'Please enter procedure TF time in format HH:MM', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'e20f3a7c-f478-479c-842d-bab17044592d')
INSERT INTO [dbo].[DIALOG_CONTROLS] ([DialogID], [ControlID], [Name], [ControlType], [DefaultText], [StringID], [ControlTop], [ControlLeft], [ControlHeight], [ControlWidth], [FieldID], [EventList], [EventID], [ClearEventID], [DefaultState], [Required], [LeftAction], [RightAction], [JustifyText], [ReadOnly], [MultiLine]

[Brian Donahue]

Hi Rich,

I think that the error may be prevented by using the SQL Packager option on the data options tab, called 'disable DML triggers'. This will stop triggers from updating anything while the data is inserted.

It would be a good idea, though, to examine the tables that are being updated and make sure that the triggers on them are valid. They may be attempting to do some action that is not valid in the current environment, such as updating another database via a linked server; SQL Packager cannot create linked servers for you so you would be required to create any linked servers manually before attempting to run the package.
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521

[rwyarger]

[Brian Donahue]

Hi Rich,

It's hard to say. Typically you don't need to do anything because the updates that may be done using one or more of your triggers may already be reflected in the data that you have packaged from the source database.

Still, it may be worth having a look at the triggers in Management Studio to see what they're meant to do.
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521

[rwyarger]