Cannot drop the index

[presgar]

I am getting this error when I try to run the 3.2 to 3.5 upgrade script. How can I fix and move on?

'tblSoftware.tblSoftware30', because it does not exist or you do not have permission


I have the permissions for sure - I don't see tblSoftware30 just tblSoftware


Haven't had any issues with 3.2 - love it

[Hemoco]

Please see your mailbox to help you solve the problem.

[presgar]

I am about ready to just uninstall it and go back to 3.2

[presgar]

Do I get to call for support since I am a premium member? I'd really like to get this done.

[presgar]

Msg 2714, Level 16, State 6, Line 1
There is already an object named 'TsysConfig' in the database.
Msg 2714, Level 16, State 6, Line 2
There is already an object named 'TsysMemorytypes' in the database.
Msg 2714, Level 16, State 6, Line 2
There is already an object named 'TsysSerials' in the database.
Msg 2714, Level 16, State 6, Line 2
There is already an object named 'Tsysservicestatus' in the database.
Msg 2714, Level 16, State 6, Line 2
There is already an object named 'tblCompCustom' in the database.
Msg 2714, Level 16, State 6, Line 2
There is already an object named 'tblPhysicalMemory' in the database.
Msg 2714, Level 16, State 6, Line 2
There is already an object named 'tblPhysicalMemoryArray' in the database.
Msg 2714, Level 16, State 6, Line 2
There is already an object named 'tblstate' in the database.
Msg 2714, Level 16, State 6, Line 2
There is already an object named 'tsysActiveScanDomains' in the database.
Msg 2714, Level 16, State 6, Line 2
There is already an object named 'tsysActiveScanOU' in the database.
Msg 2714, Level 16, State 6, Line 2
There is already an object named 'tsysDomainPasswords' in the database.
Msg 2714, Level 16, State 6, Line 2
There is already an object named 'tblSerialnumber' in the database.
Msg 1779, Level 16, State 0, Line 2
Table 'tblSerialnumber' already has a primary key defined on it.
Msg 1750, Level 16, State 0, Line 2
Could not create constraint. See previous errors.
Msg 1781, Level 16, State 1, Line 2
Column already has a DEFAULT bound to it.
Msg 1750, Level 16, State 0, Line 2
Could not create constraint. See previous errors.
Msg 1767, Level 16, State 0, Line 2
Foreign key 'FK_tblSerialnumber_tblComputers' references invalid table 'dbo.tblComputers'.
Msg 1750, Level 16, State 0, Line 2
Could not create constraint. See previous errors.
Msg 1779, Level 16, State 0, Line 2
Table 'TsysConfig' already has a primary key defined on it.
Msg 1750, Level 16, State 0, Line 2
Could not create constraint. See previous errors.
Msg 1779, Level 16, State 0, Line 2
Table 'TsysMemorytypes' already has a primary key defined on it.
Msg 1750, Level 16, State 0, Line 2
Could not create constraint. See previous errors.
Msg 1779, Level 16, State 0, Line 2
Table 'TsysSerials' already has a primary key defined on it.
Msg 1750, Level 16, State 0, Line 2
Could not create constraint. See previous errors.
Msg 1779, Level 16, State 0, Line 2
Table 'Tsysservicestatus' already has a primary key defined on it.
Msg 1750, Level 16, State 0, Line 2
Could not create constraint. See previous errors.
Msg 1779, Level 16, State 0, Line 2
Table 'tblCompCustom' already has a primary key defined on it.
Msg 1750, Level 16, State 0, Line 2
Could not create constraint. See previous errors.
Msg 1779, Level 16, State 0, Line 2
Table 'tblPhysicalMemory' already has a primary key defined on it.
Msg 1750, Level 16, State 0, Line 2
Could not create constraint. See previous errors.
Msg 1779, Level 16, State 0, Line 2
Table 'tblPhysicalMemoryArray' already has a primary key defined on it.
Msg 1750, Level 16, State 0, Line 2
Could not create constraint. See previous errors.
Msg 1779, Level 16, State 0, Line 2
Table 'tblstate' already has a primary key defined on it.
Msg 1750, Level 16, State 0, Line 2
Could not create constraint. See previous errors.
Msg 1779, Level 16, State 0, Line 2
Table 'tsysActiveScanDomains' already has a primary key defined on it.
Msg 1750, Level 16, State 0, Line 2
Could not create constraint. See previous errors.
Msg 1779, Level 16, State 0, Line 2
Table 'tsysActiveScanOU' already has a primary key defined on it.
Msg 1750, Level 16, State 0, Line 2
Could not create constraint. See previous errors.
Msg 1779, Level 16, State 0, Line 2
Table 'tsysDomainPasswords' already has a primary key defined on it.
Msg 1750, Level 16, State 0, Line 2
Could not create constraint. See previous errors.
Msg 1781, Level 16, State 1, Line 2
Column already has a DEFAULT bound to it.
Msg 1750, Level 16, State 0, Line 2
Could not create constraint. See previous errors.
Msg 1781, Level 16, State 1, Line 2
Column already has a DEFAULT bound to it.
Msg 1750, Level 16, State 0, Line 2
Could not create constraint. See previous errors.
Msg 1781, Level 16, State 1, Line 2
Column already has a DEFAULT bound to it.
Msg 1750, Level 16, State 0, Line 2
Could not create constraint. See previous errors.
Msg 1781, Level 16, State 1, Line 2
Column already has a DEFAULT bound to it.
Msg 1750, Level 16, State 0, Line 2
Could not create constraint. See previous errors.
Msg 1767, Level 16, State 0, Line 2
Foreign key 'FK_tblPhysicalMemory_tblComputers' references invalid table 'dbo.tblComputers'.
Msg 1750, Level 16, State 0, Line 2
Could not create constraint. See previous errors.
Msg 1767, Level 16, State 0, Line 2
Foreign key 'FK_tblPhysicalMemoryArray_tblComputers' references invalid table 'dbo.tblComputers'.
Msg 1750, Level 16, State 0, Line 2
Could not create constraint. See previous errors.
Msg 4902, Level 16, State 1, Line 2
Cannot find the object "tblcomputers" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 2
Cannot find the object "tblsoftware" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 2
Cannot find the object "tblADComputers" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 1
Cannot find the object "tblADComputers" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 1
Cannot find the object "tblADComputers" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 1
Cannot find the object "tblADComputers" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 2
Cannot find the object "tblADusers" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 1
Cannot find the object "tblADusers" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 1
Cannot find the object "tblADusers" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 1
Cannot find the object "tblADusers" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 1
Cannot find the object "tblADusers" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 1
Cannot find the object "tblADusers" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 1
Cannot find the object "tblADusers" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 1
Cannot find the object "tblADusers" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 1
Cannot find the object "tblADusers" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 1
Cannot find the object "tblADusers" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 1
Cannot find the object "tblADusers" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 2
Cannot find the object "tblApprovedSoftware" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 2
Cannot find the object "tblApprovedSoftware" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 3
Cannot find the object "tblDesktop" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 2
Cannot find the object "tblDesktopMonitor" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 1
Cannot find the object "tblDesktopMonitor" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 2
Cannot find the object "tblFloppy" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 1
Cannot find the object "tblFloppy" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 2
Cannot find the object "tblGroups" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 2
Cannot find the object "tblIDEController" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 1
Cannot find the object "tblIDEController" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 2
Cannot find the object "tblKeyboard" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 1
Cannot find the object "dbo.tblLicenses" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 2
Cannot find the object "tblLicenses" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 1
Cannot find the object "tblLicenses" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 2
Cannot find the object "dbo.tblLicenses" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 2
Cannot find the object "tblNetwork" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 2
Cannot find the object "tblNetworkClient" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 2
Cannot find the object "tblPointingDevice" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 2
Cannot find the object "tblPointingDevice" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 2
Cannot find the object "tblPortConnector" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 2
Cannot find the object "tblPOTSModem" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 1
Cannot find the object "tblPOTSModem" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 2
Cannot find the object "tblPrinters" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 1
Cannot find the object "tblPrinters" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 2
Cannot find the object "tblPROCESSOR" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 2
Cannot find the object "tblSerialPort" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 2
Cannot find the object "tblServices" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 2
Cannot find the object "tblShares" because it does not exist or you do not have permissions.
Msg 3701, Level 11, State 6, Line 2
Cannot drop the index 'tblSoftware.IX_tblSoftware', because it does not exist or you do not have permission.
Msg 208, Level 16, State 1, Line 2
Invalid object name 'tblsoftware'.
Msg 4902, Level 16, State 1, Line 2
Cannot find the object "tblSoftware" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 1
Cannot find the object "tblSoftware" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 1
Cannot find the object "tblSoftware" because it does not exist or you do not have permissions.
Msg 1088, Level 16, State 12, Line 2
Cannot find the object "tblSoftware" because it does not exist or you do not have permissions.
Msg 1088, Level 16, State 12, Line 2
Cannot find the object "dbo.tblSoftware" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 2
Cannot find the object "dbo.tblApprovedSoftware" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 2
Cannot find the object "tblUSBController" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 1
Cannot find the object "tblUSBController" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 2
Cannot find the object "tblUsers" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 1
Cannot find the object "tblUsers" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 1
Cannot find the object "tblUsers" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 1
Cannot find the object "tblUsers" because it does not exist or you do not have permissions.
Msg 208, Level 16, State 1, Line 11
Invalid object name 'TsysWaittime'.
Msg 208, Level 16, State 1, Line 1
Invalid object name 'TsysWaittime'.
Msg 2627, Level 14, State 1, Line 2
Violation of PRIMARY KEY constraint 'PK_tsysSerials'. Cannot insert duplicate key in object 'dbo.TsysSerials'.
The statement has been terminated.
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK_tsysSerials'. Cannot insert duplicate key in object 'dbo.TsysSerials'.
The statement has been terminated.
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK_tsysSerials'. Cannot insert duplicate key in object 'dbo.TsysSerials'.
The statement has been terminated.
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK_tsysSerials'. Cannot insert duplicate key in object 'dbo.TsysSerials'.
The statement has been terminated.
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK_tsysSerials'. Cannot insert duplicate key in object 'dbo.TsysSerials'.
The statement has been terminated.
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK_tsysSerials'. Cannot insert duplicate key in object 'dbo.TsysSerials'.
The statement has been terminated.
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK_tsysSerials'. Cannot insert duplicate key in object 'dbo.TsysSerials'.
The statement has been terminated.
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK_tsysSerials'. Cannot insert duplicate key in object 'dbo.TsysSerials'.
The statement has been terminated.
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK_tsysSerials'. Cannot insert duplicate key in object 'dbo.TsysSerials'.
The statement has been terminated.
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK_tsysSerials'. Cannot insert duplicate key in object 'dbo.TsysSerials'.
The statement has been terminated.
Msg 2627, Level 14, State 1, Line 2
Violation of PRIMARY KEY constraint 'PK__TsysRamtypes__08961D2F'. Cannot insert duplicate key in object 'dbo.TsysMemorytypes'.
The statement has been terminated.
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK__TsysRamtypes__08961D2F'. Cannot insert duplicate key in object 'dbo.TsysMemorytypes'.
The statement has been terminated.
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK__TsysRamtypes__08961D2F'. Cannot insert duplicate key in object 'dbo.TsysMemorytypes'.
The statement has been terminated.
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK__TsysRamtypes__08961D2F'. Cannot insert duplicate key in object 'dbo.TsysMemorytypes'.
The statement has been terminated.
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK__TsysRamtypes__08961D2F'. Cannot insert duplicate key in object 'dbo.TsysMemorytypes'.
The statement has been terminated.
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK__TsysRamtypes__08961D2F'. Cannot insert duplicate key in object 'dbo.TsysMemorytypes'.
The statement has been terminated.
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK__TsysRamtypes__08961D2F'. Cannot insert duplicate key in object 'dbo.TsysMemorytypes'.
The statement has been terminated.
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK__TsysRamtypes__08961D2F'. Cannot insert duplicate key in object 'dbo.TsysMemorytypes'.
The statement has been terminated.
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK__TsysRamtypes__08961D2F'. Cannot insert duplicate key in object 'dbo.TsysMemorytypes'.
The statement has been terminated.
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK__TsysRamtypes__08961D2F'. Cannot insert duplicate key in object 'dbo.TsysMemorytypes'.
The statement has been terminated.
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK__TsysRamtypes__08961D2F'. Cannot insert duplicate key in object 'dbo.TsysMemorytypes'.
The statement has been terminated.
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK__TsysRamtypes__08961D2F'. Cannot insert duplicate key in object 'dbo.TsysMemorytypes'.
The statement has been terminated.
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK__TsysRamtypes__08961D2F'. Cannot insert duplicate key in object 'dbo.TsysMemorytypes'.
The statement has been terminated.
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK__TsysRamtypes__08961D2F'. Cannot insert duplicate key in object 'dbo.TsysMemorytypes'.
The statement has been terminated.
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK__TsysRamtypes__08961D2F'. Cannot insert duplicate key in object 'dbo.TsysMemorytypes'.
The statement has been terminated.
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK__TsysRamtypes__08961D2F'. Cannot insert duplicate key in object 'dbo.TsysMemorytypes'.
The statement has been terminated.
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK__TsysRamtypes__08961D2F'. Cannot insert duplicate key in object 'dbo.TsysMemorytypes'.
The statement has been terminated.
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK__TsysRamtypes__08961D2F'. Cannot insert duplicate key in object 'dbo.TsysMemorytypes'.
The statement has been terminated.
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK__TsysRamtypes__08961D2F'. Cannot insert duplicate key in object 'dbo.TsysMemorytypes'.
The statement has been terminated.
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK__TsysRamtypes__08961D2F'. Cannot insert duplicate key in object 'dbo.TsysMemorytypes'.
The statement has been terminated.
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK__TsysRamtypes__08961D2F'. Cannot insert duplicate key in object 'dbo.TsysMemorytypes'.
The statement has been terminated.
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK__TsysRamtypes__08961D2F'. Cannot insert duplicate key in object 'dbo.TsysMemorytypes'.
The statement has been terminated.
Msg 2627, Level 14, State 1, Line 4
Violation of PRIMARY KEY constraint 'PK_TblsysConfig'. Cannot insert duplicate key in object 'dbo.TsysConfig'.
The statement has been terminated.
Msg 2627, Level 14, State 1, Line 3
Violation of PRIMARY KEY constraint 'PK_tblstate'. Cannot insert duplicate key in object 'dbo.tblstate'.
The statement has been terminated.
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK_tblstate'. Cannot insert duplicate key in object 'dbo.tblstate'.
The statement has been terminated.
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK_tblstate'. Cannot insert duplicate key in object 'dbo.tblstate'.
The statement has been terminated.
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK_tblstate'. Cannot insert duplicate key in object 'dbo.tblstate'.
The statement has been terminated.
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK_tblstate'. Cannot insert duplicate key in object 'dbo.tblstate'.
The statement has been terminated.
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK_tblstate'. Cannot insert duplicate key in object 'dbo.tblstate'.
The statement has been terminated.
Msg 2714, Level 16, State 3, Procedure Web30customfields, Line 3
There is already an object named 'Web30customfields' in the database.
Msg 208, Level 16, State 1, Procedure Web30RepActiveComputers, Line 4
Invalid object name 'dbo.tblComputers'.
Msg 208, Level 16, State 1, Procedure web30repallcompstates, Line 4
Invalid object name 'dbo.tblComputers'.
Msg 2714, Level 16, State 3, Procedure web30getstate, Line 3
There is already an object named 'web30getstate' in the database.
Msg 208, Level 16, State 6, Procedure Web301comp, Line 3
Invalid object name 'dbo.Web301comp'.
Msg 208, Level 16, State 1, Procedure web30licensecompliance, Line 4
Invalid object name 'dbo.web30repUsedSoftware'.
Msg 208, Level 16, State 1, Procedure web30alldomains, Line 4
Invalid object name 'dbo.tblComputers'.
Msg 208, Level 16, State 1, Procedure Web30totalnonactive, Line 5
Invalid object name 'dbo.tblComputers'.
Msg 208, Level 16, State 1, Procedure Web30totalerror, Line 4
Invalid object name 'dbo.tblComputers'.
Msg 208, Level 16, State 1, Procedure web30totalClients, Line 4
Invalid object name 'dbo.tblComputers'.
Msg 208, Level 16, State 1, Procedure web30totalServers, Line 4
Invalid object name 'dbo.tblComputers'.
Msg 208, Level 16, State 1, Procedure web30totaldomain, Line 5
Invalid object name 'dbo.tblComputers'.
Msg 208, Level 16, State 6, Procedure Web30computers, Line 3
Invalid object name 'dbo.Web30computers'.
Msg 2714, Level 16, State 3, Procedure web30hwSerials, Line 3
There is already an object named 'web30hwSerials' in the database.
Msg 2714, Level 16, State 3, Procedure web30hwregistry, Line 3
There is already an object named 'web30hwregistry' in the database.
Msg 2714, Level 16, State 3, Procedure web30hwfile, Line 3
There is already an object named 'web30hwfile' in the database.
Msg 2714, Level 16, State 3, Procedure web30hwmemory, Line 3
There is already an object named 'web30hwmemory' in the database.
Msg 2714, Level 16, State 3, Procedure web30hwmemoryarray, Line 3
There is already an object named 'web30hwmemoryarray' in the database.
Msg 4902, Level 16, State 1, Line 2
Cannot find the object "tsysassetlinks" because it does not exist or you do not have permissions.

[Hemoco]

Could you please copy/paste the errors you get when running the script in the sql server management console.

[presgar]

Um can someone call me because I need to worry about the errors, it's not working. See the error i'm getting on page one about nonactive column. I can't use the product. 631-350-2891 - jason@presgar.com

[presgar]

I don't think the script is running completey. Since I got that first error and you told me to remove that one line it won't run again because it's finding duplicate tables/entries when it tires to run. Is there any way to make it run and skip what already exists? Please help.

[Hemoco]

presgar wrote:
I don't think the script is running completey. Since I got that first error and you told me to remove that one line it won't run again because it's finding duplicate tables/entries when it tires to run. Is there any way to make it run and skip what already exists? Please help.

Don't worry about these errors.

[presgar]

I continued the upgrade and when all was said and done I tried to login and I get this error.

Server Error in '/Lansweeper' Application.
--------------------------------------------------------------------------------

Column 'nonactive' does not belong to table theTable.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.ArgumentException: Column 'nonactive' does not belong to table theTable.

Source Error:

The source code that generated this unhandled exception can only be shown when compiled in debug mode. To enable this, please follow one of the below steps, then request the URL:

1. Add a "Debug=true" directive at the top of the file that generated the error. Example:

<%@ Page Language="C#" Debug="true" %>

or:

2) Add the following section to the configuration file of your application:

<configuration>
<system.web>
<compilation debug="true"/>
</system.web>
</configuration>

Note that this second technique will cause all files within a given application to be compiled in debug mode. The first technique will cause only that particular file to be compiled in debug mode.

Important: Running applications in debug mode does incur a memory/performance overhead. You should make sure that an application has debugging disabled before deploying into production scenario.

Stack Trace:


[ArgumentException: Column 'nonactive' does not belong to table theTable.]
System.Data.DataRow.GetDataColumn(String columnName) +1775301
System.Data.DataRow.get_Item(String columnName) +13
ASP.state_aspx.__Render__control1(HtmlTextWriter __w, Control parameterContainer) +1151
System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) +256
System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) +19
System.Web.UI.Page.Render(HtmlTextWriter writer) +29
System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) +27
System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) +99
System.Web.UI.Control.RenderControl(HtmlTextWriter writer) +25
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1266




--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:2.0.50727.3082; ASP.NET Version:2.0.50727.3082