08/01/2008 10:15:04 AM
v1.3572 - CREATE UNIQUE INDEX terminated because a duplicate key was found for index ID 36. Most significant primary key is '067944836713        '
Continue or restart VDM - This error was queued for analysis, we apologize.
  

if ( select [Value] from ::fn_listextendedproperty( 'Version', default, default, default, defa
0001:00233630       axView.txView.ExecuteSql line 8434
0001:001901DC       axPopup.txPopup.DoOnClick line 1076 base: 00C01000
  

if ( select [Value] from ::fn_listextendedproperty( 'Version', default, default, default, default, default, default ) ) < '1.2' begin
  if  exists ( select * from INFORMATION_SCHEMA.COLUMNS where Table_Name = 'Resources' AND Column_Name = 'Template_Name' ) begin
	  alter table Resources alter column [Template_Name] varchar(50) NULL 
	  alter table Resources alter column [Group] varchar(50) NULL 
	  alter table Resources alter column [Department] varchar(50) NULL 
	  alter table Resources alter column [Division] varchar(50) NULL 
	  alter table Resources alter column Asset_Account    varchar( 50 ) NULL 
	  alter table Resources alter column Sales_Account    varchar( 50 ) NULL 
	  alter table Resources alter column COGS_Account     varchar( 50 ) NULL 
	  alter table Resources alter column Expense_Account  varchar( 50 ) NULL 
	  alter table Resources alter column [Sunday_Hours_List]      varchar(  50 ) NULL
	  alter table Resources alter column [Monday_Hours_List]      varchar(  50 ) NULL
	  alter table Resources alter column [Tuesday_Hours_List]     varchar(  50 ) NULL
	  alter table Resources alter column [Wednesday_Hours_List]   varchar(  50 ) NULL
	  alter table Resources alter column [Thursday_Hours_List]    varchar(  50 ) NULL
	  alter table Resources alter column [Friday_Hours_List]      varchar(  50 ) NULL
	  alter table Resources alter column [Saturday_Hours_List]    varchar(  50 ) NULL
    alter table Resources alter column Last_Supplier varchar( 50 ) Null
    execute dbo.DropDefault    'Resources', 'Type'
    execute dbo.DropConstraint 'Resources', 'Type'
    alter table Resources alter column [Type] varchar( 20 ) Null
    alter table Resources add default 'Product' for [Type] 
    alter table Resources add constraint CK_Resources_Type check ( [Type] IN ( 'Product', 'Equipment', 'Task', 'Contact', 'Template' ) )
    execute dbo.DropConstraint 'Resources', 'Name'
    alter table Resources alter column [Name] varchar( 50 ) NOT Null
    alter table Resources add constraint IX_Resources_Name unique  nonclustered ( [Name] )
    execute dbo.DropConstraint 'Resources', 'Code'
    alter table Resources alter column [Code] varchar( 20 ) Null
    alter table Resources add constraint IX_Resources_Code unique  nonclustered ( [Code] )
    execute dbo.DropConstraint 'Resources', 'UPC'
    alter table Resources alter column [UPC] varchar( 20 ) Null
    alter table Resources add constraint IX_Resources_UPC unique  nonclustered ( [UPC] )
    execute dbo.DropDefault    'Resources', 'Unit'
    alter table Resources alter column Unit varchar( 20 ) Null
    alter table Resources add default 'Each' for Unit 
    execute dbo.DropDefault    'Resources', 'Regular_Days_List'
    alter table Resources alter column Regular_Days_List varchar( 100 ) Null
    alter table Resources add default( 'Monday,Tuesday,Wednesday,Thursday,Friday' ) for Regular_Days_List 
    execute dbo.DropDefault    'Resources', 'Regular_Day_Hours_List'
    alter table Resources alter column Regular_Day_Hours_List varchar( 100 ) Null
    alter table Resources add default( '9-17' ) for Regular_Day_Hours_List 
  end
end

08/01/2008 10:07:19 AM
v1.3572 - Invalid column name 'Made_to_Order'
Continue or restart VDM - This error was queued for analysis, we apologize.
select top 101 [ID],[GUID],[Order_ID],[Date_Created],[Date_Modified],[Date_Locked],[Date_Required],[
0001:002329BC       axView.txView.ExecuteRS line 8369
0001:00241614       axView.txTabsEx.DoOnClick line 9951 base: 00C01000
select top 101 [ID],[GUID],[Order_ID],[Date_Created],[Date_Modified],[Date_Locked],[Date_Required],[Type],[Order_Name],[Resource_Name],[Date_Start],[Date_Stop],[Quantity],[Price],[Total],[Taxable],[Made_to_Order],[Tree_Path],[Note], isNull( DataLength( [Audio] ), 0 ) as Audio_Length from OrderItems where (([Resource_ID]=0)) AND (isNull(Date_Locked,0)=0) order by [ID]

08/01/2008 10:06:24 AM
v1.3572 - CREATE UNIQUE INDEX terminated because a duplicate key was found for index ID 36. Most significant primary key is '067944836713        '
Continue or restart VDM - This error was queued for analysis, we apologize.


if ( select [Value] from ::fn_listextendedproperty( 'Version', default, default, default, defaul
0001:00233630       axView.txView.ExecuteSql line 8434
0001:001901DC       axPopup.txPopup.DoOnClick line 1076 base: 00C01000


if ( select [Value] from ::fn_listextendedproperty( 'Version', default, default, default, default, default, default ) ) < '1.2' begin
  if  exists ( select * from INFORMATION_SCHEMA.COLUMNS where Table_Name = 'Resources' AND Column_Name = 'Template_Name' ) begin
	  alter table Resources alter column [Template_Name] varchar(50) NULL 
	  alter table Resources alter column [Group] varchar(50) NULL 
	  alter table Resources alter column [Department] varchar(50) NULL 
	  alter table Resources alter column [Division] varchar(50) NULL 
	  alter table Resources alter column Asset_Account    varchar( 50 ) NULL 
	  alter table Resources alter column Sales_Account    varchar( 50 ) NULL 
	  alter table Resources alter column COGS_Account     varchar( 50 ) NULL 
	  alter table Resources alter column Expense_Account  varchar( 50 ) NULL 
	  alter table Resources alter column [Sunday_Hours_List]      varchar(  50 ) NULL
	  alter table Resources alter column [Monday_Hours_List]      varchar(  50 ) NULL
	  alter table Resources alter column [Tuesday_Hours_List]     varchar(  50 ) NULL
	  alter table Resources alter column [Wednesday_Hours_List]   varchar(  50 ) NULL
	  alter table Resources alter column [Thursday_Hours_List]    varchar(  50 ) NULL
	  alter table Resources alter column [Friday_Hours_List]      varchar(  50 ) NULL
	  alter table Resources alter column [Saturday_Hours_List]    varchar(  50 ) NULL
    alter table Resources alter column Last_Supplier varchar( 50 ) Null
    execute dbo.DropDefault    'Resources', 'Type'
    execute dbo.DropConstraint 'Resources', 'Type'
    alter table Resources alter column [Type] varchar( 20 ) Null
    alter table Resources add default 'Product' for [Type] 
    alter table Resources add constraint CK_Resources_Type check ( [Type] IN ( 'Product', 'Equipment', 'Task', 'Contact', 'Template' ) )
    execute dbo.DropConstraint 'Resources', 'Name'
    alter table Resources alter column [Name] varchar( 50 ) NOT Null
    update Resources set [Name] = isNull( [Name], cast( ID as varchar( 20 ) ) ) + '-' + cast( ID as varchar( 20 ) )
      where exists( select R.ID from Resources R where R.ID <> ID AND R.[Name] = [Name] )
    alter table Resources add constraint IX_Resources_Name unique  nonclustered ( [Name] )
    execute dbo.DropConstraint 'Resources', 'Code'
    alter table Resources alter column [Code] varchar( 20 ) Null
    update Resources set Code = isNull( Code, cast( ID as varchar( 20 ) ) ) + '-' + cast( ID as varchar( 20 ) )
      where exists( select R.ID from Resources R where R.ID <> ID AND R.Code = Code )
    alter table Resources add constraint IX_Resources_Code unique  nonclustered ( [Code] )
    execute dbo.DropConstraint 'Resources', 'UPC'
    alter table Resources alter column [UPC] varchar( 20 ) Null
    update Resources set UPC = isNull( UPC, cast( ID as varchar( 20 ) ) ) + '-' + cast( ID as varchar( 20 ) )
      where exists( select R.ID from Resources R where R.ID <> ID AND R.UPC = UPC )
    alter table Resources add constraint IX_Resources_UPC unique  nonclustered ( [UPC] )
    execute dbo.DropDefault    'Resources', 'Unit'
    alter table Resources alter column Unit varchar( 20 ) Null
    alter table Resources add default 'Each' for Unit 
    execute dbo.DropDefault    'Resources', 'Regular_Days_List'
    alter table Resources alter column Regular_Days_List varchar( 100 ) Null
    alter table Resources add default( 'Monday,Tuesday,Wednesday,Thursday,Friday' ) for Regular_Days_List 
    execute dbo.DropDefault    'Resources', 'Regular_Day_Hours_List'
    alter table Resources alter column Regular_Day_Hours_List varchar( 100 ) Null
    alter table Resources add default( '9-17' ) for Regular_Day_Hours_List 
  end
end

08/01/2008 9:45:25 AM
v1.3571 - CREATE UNIQUE INDEX terminated because a duplicate key was found for index ID 4. Most significant primary key is '067944836713        '
Continue or restart VDM - This error was queued for analysis, we apologize.


if ( select [Value] from ::fn_listextendedproperty( 'Version', default, default, default, defaul
0001:00231848       axView.txView.UpdateXML line 8273
0001:001901DC       axPopup.txPopup.DoOnClick line 1076 base: 00C01000


if ( select [Value] from ::fn_listextendedproperty( 'Version', default, default, default, default, default, default ) ) < '1.2' begin
  if  exists ( select * from INFORMATION_SCHEMA.COLUMNS where Table_Name = 'Resources' AND Column_Name = 'Template_Name' ) begin
	  alter table Resources alter column [Template_Name] varchar(50) NULL 
	  alter table Resources alter column [Group] varchar(50) NULL 
	  alter table Resources alter column [Department] varchar(50) NULL 
	  alter table Resources alter column [Division] varchar(50) NULL 
	  alter table Resources alter column Asset_Account    varchar( 50 ) NULL 
	  alter table Resources alter column Sales_Account    varchar( 50 ) NULL 
	  alter table Resources alter column COGS_Account     varchar( 50 ) NULL 
	  alter table Resources alter column Expense_Account  varchar( 50 ) NULL 
	  alter table Resources alter column [Sunday_Hours_List]      varchar(  50 ) NULL
	  alter table Resources alter column [Monday_Hours_List]      varchar(  50 ) NULL
	  alter table Resources alter column [Tuesday_Hours_List]     varchar(  50 ) NULL
	  alter table Resources alter column [Wednesday_Hours_List]   varchar(  50 ) NULL
	  alter table Resources alter column [Thursday_Hours_List]    varchar(  50 ) NULL
	  alter table Resources alter column [Friday_Hours_List]      varchar(  50 ) NULL
	  alter table Resources alter column [Saturday_Hours_List]    varchar(  50 ) NULL
    alter table Resources alter column Last_Supplier varchar( 50 ) Null
    execute dbo.DropDefault    'Resources', 'Type'
    execute dbo.DropConstraint 'Resources', 'Type'
    alter table Resources alter column [Type] varchar( 20 ) Null
    alter table Resources add default 'Product' for [Type] 
    alter table Resources add constraint CK_Resources_Type check ( [Type] IN ( 'Product', 'Equipment', 'Task', 'Contact', 'Template' ) )
    execute dbo.DropConstraint 'Resources', 'Name'
    alter table Resources alter column [Name] varchar( 50 ) NOT Null
    alter table Resources add constraint IX_Resources_Name unique  nonclustered ( [Name] )
    execute dbo.DropConstraint 'Resources', 'Code'
    alter table Resources alter column [Code] varchar( 20 ) Null
    alter table Resources add constraint IX_Resources_Code unique  nonclustered ( [Code] )
    execute dbo.DropConstraint 'Resources', 'UPC'
    alter table Resources alter column [UPC] varchar( 20 ) Null
    alter table Resources add constraint IX_Resources_UPC unique  nonclustered ( [UPC] )
    execute dbo.DropDefault    'Resources', 'Unit'
    alter table Resources alter column Unit varchar( 20 ) Null
    alter table Resources add default 'Each' for Unit 
    execute dbo.DropDefault    'Resources', 'Regular_Days_List'
    alter table Resources alter column Regular_Days_List varchar( 100 ) Null
    alter table Resources add default( 'Monday,Tuesday,Wednesday,Thursday,Friday' ) for Regular_Days_List 
    execute dbo.DropDefault    'Resources', 'Regular_Day_Hours_List'
    alter table Resources alter column Regular_Day_Hours_List varchar( 100 ) Null
    alter table Resources add default( '9-17' ) for Regular_Day_Hours_List 
  end
end

08/01/2008 9:37:10 AM
v1.3571 - Invalid column name 'Made_to_Order'
Continue or restart VDM - This error was queued for analysis, we apologize.
select top 101 [ID],[GUID],[Order_ID],[Date_Created],[Date_Modified],[Date_Locked],[Date_Required],[
0001:00231140       axView.txView.SearchChildren line 8208
0001:0023FAC8       axView.txPlayer.ClickButton line 9572 base: 00C01000
select top 101 [ID],[GUID],[Order_ID],[Date_Created],[Date_Modified],[Date_Locked],[Date_Required],[Type],[Order_Name],[Resource_Name],[Date_Start],[Date_Stop],[Quantity],[Price],[Total],[Taxable],[Made_to_Order],[Tree_Path],[Note], isNull( DataLength( [Audio] ), 0 ) as Audio_Length from OrderItems where (([Resource_ID]=0)) AND (isNull(Date_Locked,0)=0) order by [ID]

08/01/2008 9:35:52 AM
v1.3569 - For DROP INDEX, you must give both the table and the index name, in the form tablename.indexname
Continue or restart VDM - This error was queued for analysis, we apologize.


--------------
-- WebPages --
--------------


if ( select [Value] from ::fn_listextendedpr
0001:00233534       axView.txView.ExecuteSql line 8418
0001:001901DC       axPopup.txPopup.DoOnClick line 1076 base: 00C01000


--------------
-- WebPages --
--------------


if ( select [Value] from ::fn_listextendedproperty( 'Version', default, default, default,