This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Accept
Reject
Community FAQ
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Fix: Operator '=' is not defined for type 'DBNull' and type 'Boolean'

Hemoco
Lansweeper Alumni

‎03-11-2009 05:59 PM

Run this code from the console to fix this issue:

ALTER TABLE tsysconfig ALTER COLUMN Licensekey varchar(2000)
GO
update tsysconfig set activescanning = 0
GO
Labels:
0 Kudos
12 REPLIES 12
Hemoco
Lansweeper Alumni

‎03-11-2009 11:10 PM

It seems that you have run this script on database "master" instead of the lansweeper database
0 Kudos
esullivan
Engaged Sweeper
In response to Hemoco

‎03-11-2009 11:13 PM

Lansweeper wrote:
It seems that you have run this script on database "master" instead of the lansweeper database


Yeah i'm a retard!

Thanks man, seems to be working now
0 Kudos
esullivan
Engaged Sweeper

‎03-11-2009 11:08 PM

Ok I think I got it to run and I got this


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 alter table 'tblcomputers' because this table does not exist in database 'master'.
Msg 4902, Level 16, State 1, Line 2
Cannot alter table 'tblsoftware' because this table does not exist in database 'master'.
Msg 4902, Level 16, State 1, Line 2
Cannot alter table 'tblADComputers' because this table does not exist in database 'master'.
Msg 4902, Level 16, State 1, Line 1
Cannot alter table 'tblADComputers' because this table does not exist in database 'master'.
Msg 4902, Level 16, State 1, Line 1
Cannot alter table 'tblADComputers' because this table does not exist in database 'master'.
Msg 4902, Level 16, State 1, Line 1
Cannot alter table 'tblADComputers' because this table does not exist in database 'master'.
Msg 4902, Level 16, State 1, Line 2
Cannot alter table 'tblADusers' because this table does not exist in database 'master'.
Msg 4902, Level 16, State 1, Line 1
Cannot alter table 'tblADusers' because this table does not exist in database 'master'.
Msg 4902, Level 16, State 1, Line 1
Cannot alter table 'tblADusers' because this table does not exist in database 'master'.
Msg 4902, Level 16, State 1, Line 1
Cannot alter table 'tblADusers' because this table does not exist in database 'master'.
Msg 4902, Level 16, State 1, Line 1
Cannot alter table 'tblADusers' because this table does not exist in database 'master'.
Msg 4902, Level 16, State 1, Line 1
Cannot alter table 'tblADusers' because this table does not exist in database 'master'.
Msg 4902, Level 16, State 1, Line 1
Cannot alter table 'tblADusers' because this table does not exist in database 'master'.
Msg 4902, Level 16, State 1, Line 1
Cannot alter table 'tblADusers' because this table does not exist in database 'master'.
Msg 4902, Level 16, State 1, Line 1
Cannot alter table 'tblADusers' because this table does not exist in database 'master'.
Msg 4902, Level 16, State 1, Line 1
Cannot alter table 'tblADusers' because this table does not exist in database 'master'.
Msg 4902, Level 16, State 1, Line 1
Cannot alter table 'tblADusers' because this table does not exist in database 'master'.
Msg 4902, Level 16, State 1, Line 2
Cannot alter table 'tblApprovedSoftware' because this table does not exist in database 'master'.
Msg 4902, Level 16, State 1, Line 2
Cannot alter table 'tblApprovedSoftware' because this table does not exist in database 'master'.
Msg 4902, Level 16, State 1, Line 3
Cannot alter table 'tblDesktop' because this table does not exist in database 'master'.
Msg 4902, Level 16, State 1, Line 2
Cannot alter table 'tblDesktopMonitor' because this table does not exist in database 'master'.
Msg 4902, Level 16, State 1, Line 1
Cannot alter table 'tblDesktopMonitor' because this table does not exist in database 'master'.
Msg 4902, Level 16, State 1, Line 2
Cannot alter table 'tblFloppy' because this table does not exist in database 'master'.
Msg 4902, Level 16, State 1, Line 1
Cannot alter table 'tblFloppy' because this table does not exist in database 'master'.
Msg 4902, Level 16, State 1, Line 2
Cannot alter table 'tblGroups' because this table does not exist in database 'master'.
Msg 4902, Level 16, State 1, Line 2
Cannot alter table 'tblIDEController' because this table does not exist in database 'master'.
Msg 4902, Level 16, State 1, Line 1
Cannot alter table 'tblIDEController' because this table does not exist in database 'master'.
Msg 4902, Level 16, State 1, Line 2
Cannot alter table 'tblKeyboard' because this table does not exist in database 'master'.
Msg 4902, Level 16, State 1, Line 1
Cannot alter table 'dbo.tblLicenses' because this table does not exist in database 'master'.
Msg 4902, Level 16, State 1, Line 2
Cannot alter table 'tblLicenses' because this table does not exist in database 'master'.
Msg 4902, Level 16, State 1, Line 1
Cannot alter table 'tblLicenses' because this table does not exist in database 'master'.
Msg 4902, Level 16, State 1, Line 2
Cannot alter table 'dbo.tblLicenses' because this table does not exist in database 'master'.
Msg 4902, Level 16, State 1, Line 2
Cannot alter table 'tblNetwork' because this table does not exist in database 'master'.
Msg 4902, Level 16, State 1, Line 2
Cannot alter table 'tblNetworkClient' because this table does not exist in database 'master'.
Msg 4902, Level 16, State 1, Line 2
Cannot alter table 'tblPointingDevice' because this table does not exist in database 'master'.
Msg 4902, Level 16, State 1, Line 2
Cannot alter table 'tblPointingDevice' because this table does not exist in database 'master'.
Msg 4902, Level 16, State 1, Line 2
Cannot alter table 'tblPortConnector' because this table does not exist in database 'master'.
Msg 4902, Level 16, State 1, Line 2
Cannot alter table 'tblPOTSModem' because this table does not exist in database 'master'.
Msg 4902, Level 16, State 1, Line 1
Cannot alter table 'tblPOTSModem' because this table does not exist in database 'master'.
Msg 4902, Level 16, State 1, Line 2
Cannot alter table 'tblPrinters' because this table does not exist in database 'master'.
Msg 4902, Level 16, State 1, Line 1
Cannot alter table 'tblPrinters' because this table does not exist in database 'master'.
Msg 4902, Level 16, State 1, Line 2
Cannot alter table 'tblPROCESSOR' because this table does not exist in database 'master'.
Msg 4902, Level 16, State 1, Line 2
Cannot alter table 'tblSerialPort' because this table does not exist in database 'master'.
Msg 4902, Level 16, State 1, Line 2
Cannot alter table 'tblServices' because this table does not exist in database 'master'.
Msg 4902, Level 16, State 1, Line 2
Cannot alter table 'tblShares' because this table does not exist in database 'master'.
Msg 3701, Level 11, State 6, Line 2
Cannot drop the index 'tblSoftware.IX_tblSoftware', because it does not exist in the system catalog.
Msg 3701, Level 11, State 6, Line 2
Cannot drop the index 'tblSoftware.tblSoftware30', because it does not exist in the system catalog.
Msg 208, Level 16, State 1, Line 2
Invalid object name 'tblsoftware'.
Msg 4902, Level 16, State 1, Line 2
Cannot alter table 'tblSoftware' because this table does not exist in database 'master'.
Msg 4902, Level 16, State 1, Line 1
Cannot alter table 'tblSoftware' because this table does not exist in database 'master'.
Msg 4902, Level 16, State 1, Line 1
Cannot alter table 'tblSoftware' because this table does not exist in database 'master'.
Msg 1906, Level 11, State 1, Line 2
Cannot create an index on 'tblSoftware', because this table does not exist in database 'master'.
Msg 1906, Level 11, State 1, Line 2
Cannot create an index on 'dbo.tblSoftware', because this table does not exist in database 'master'.
Msg 4902, Level 16, State 1, Line 2
Cannot alter table 'dbo.tblApprovedSoftware' because this table does not exist in database 'master'.
Msg 4902, Level 16, State 1, Line 2
Cannot alter table 'tblUSBController' because this table does not exist in database 'master'.
Msg 4902, Level 16, State 1, Line 1
Cannot alter table 'tblUSBController' because this table does not exist in database 'master'.
Msg 4902, Level 16, State 1, Line 2
Cannot alter table 'tblUsers' because this table does not exist in database 'master'.
Msg 4902, Level 16, State 1, Line 1
Cannot alter table 'tblUsers' because this table does not exist in database 'master'.
Msg 4902, Level 16, State 1, Line 1
Cannot alter table 'tblUsers' because this table does not exist in database 'master'.
Msg 4902, Level 16, State 1, Line 1
Cannot alter table 'tblUsers' because this table does not exist in database 'master'.
Msg 208, Level 16, State 1, Line 1
Invalid object name 'TsysWaittime'.
Msg 208, Level 16, State 1, Line 1
Invalid object name 'TsysWaittime'.
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK_tsysSerials'. Cannot insert duplicate key in object 'TsysSerials'.
The statement has been terminated.

(0 row(s) affected)
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK_tsysSerials'. Cannot insert duplicate key in object 'TsysSerials'.
The statement has been terminated.

(0 row(s) affected)
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK_tsysSerials'. Cannot insert duplicate key in object 'TsysSerials'.
The statement has been terminated.

(0 row(s) affected)
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK_tsysSerials'. Cannot insert duplicate key in object 'TsysSerials'.
The statement has been terminated.

(0 row(s) affected)
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK_tsysSerials'. Cannot insert duplicate key in object 'TsysSerials'.
The statement has been terminated.

(0 row(s) affected)
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK_tsysSerials'. Cannot insert duplicate key in object 'TsysSerials'.
The statement has been terminated.

(0 row(s) affected)
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK_tsysSerials'. Cannot insert duplicate key in object 'TsysSerials'.
The statement has been terminated.

(0 row(s) affected)
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK_tsysSerials'. Cannot insert duplicate key in object 'TsysSerials'.
The statement has been terminated.

(0 row(s) affected)
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK_tsysSerials'. Cannot insert duplicate key in object 'TsysSerials'.
The statement has been terminated.

(0 row(s) affected)
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK_tsysSerials'. Cannot insert duplicate key in object 'TsysSerials'.
The statement has been terminated.

(0 row(s) affected)
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK__TsysRamtypes__08961D2F'. Cannot insert duplicate key in object 'TsysMemorytypes'.
The statement has been terminated.

(0 row(s) affected)
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK__TsysRamtypes__08961D2F'. Cannot insert duplicate key in object 'TsysMemorytypes'.
The statement has been terminated.

(0 row(s) affected)
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK__TsysRamtypes__08961D2F'. Cannot insert duplicate key in object 'TsysMemorytypes'.
The statement has been terminated.

(0 row(s) affected)
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK__TsysRamtypes__08961D2F'. Cannot insert duplicate key in object 'TsysMemorytypes'.
The statement has been terminated.

(0 row(s) affected)
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK__TsysRamtypes__08961D2F'. Cannot insert duplicate key in object 'TsysMemorytypes'.
The statement has been terminated.

(0 row(s) affected)
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK__TsysRamtypes__08961D2F'. Cannot insert duplicate key in object 'TsysMemorytypes'.
The statement has been terminated.

(0 row(s) affected)
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK__TsysRamtypes__08961D2F'. Cannot insert duplicate key in object 'TsysMemorytypes'.
The statement has been terminated.

(0 row(s) affected)
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK__TsysRamtypes__08961D2F'. Cannot insert duplicate key in object 'TsysMemorytypes'.
The statement has been terminated.

(0 row(s) affected)
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK__TsysRamtypes__08961D2F'. Cannot insert duplicate key in object 'TsysMemorytypes'.
The statement has been terminated.

(0 row(s) affected)
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK__TsysRamtypes__08961D2F'. Cannot insert duplicate key in object 'TsysMemorytypes'.
The statement has been terminated.

(0 row(s) affected)
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK__TsysRamtypes__08961D2F'. Cannot insert duplicate key in object 'TsysMemorytypes'.
The statement has been terminated.

(0 row(s) affected)
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK__TsysRamtypes__08961D2F'. Cannot insert duplicate key in object 'TsysMemorytypes'.
The statement has been terminated.

(0 row(s) affected)
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK__TsysRamtypes__08961D2F'. Cannot insert duplicate key in object 'TsysMemorytypes'.
The statement has been terminated.

(0 row(s) affected)
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK__TsysRamtypes__08961D2F'. Cannot insert duplicate key in object 'TsysMemorytypes'.
The statement has been terminated.

(0 row(s) affected)
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK__TsysRamtypes__08961D2F'. Cannot insert duplicate key in object 'TsysMemorytypes'.
The statement has been terminated.

(0 row(s) affected)
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK__TsysRamtypes__08961D2F'. Cannot insert duplicate key in object 'TsysMemorytypes'.
The statement has been terminated.

(0 row(s) affected)
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK__TsysRamtypes__08961D2F'. Cannot insert duplicate key in object 'TsysMemorytypes'.
The statement has been terminated.

(0 row(s) affected)
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK__TsysRamtypes__08961D2F'. Cannot insert duplicate key in object 'TsysMemorytypes'.
The statement has been terminated.

(0 row(s) affected)
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK__TsysRamtypes__08961D2F'. Cannot insert duplicate key in object 'TsysMemorytypes'.
The statement has been terminated.

(0 row(s) affected)
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK__TsysRamtypes__08961D2F'. Cannot insert duplicate key in object 'TsysMemorytypes'.
The statement has been terminated.

(0 row(s) affected)
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK__TsysRamtypes__08961D2F'. Cannot insert duplicate key in object 'TsysMemorytypes'.
The statement has been terminated.

(0 row(s) affected)
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK__TsysRamtypes__08961D2F'. Cannot insert duplicate key in object 'TsysMemorytypes'.
The statement has been terminated.

(0 row(s) affected)
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK_TblsysConfig'. Cannot insert duplicate key in object 'TsysConfig'.
The statement has been terminated.

(0 row(s) affected)
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK_tblstate'. Cannot insert duplicate key in object 'tblstate'.
The statement has been terminated.

(0 row(s) affected)
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK_tblstate'. Cannot insert duplicate key in object 'tblstate'.
The statement has been terminated.

(0 row(s) affected)
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK_tblstate'. Cannot insert duplicate key in object 'tblstate'.
The statement has been terminated.

(0 row(s) affected)
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK_tblstate'. Cannot insert duplicate key in object 'tblstate'.
The statement has been terminated.

(0 row(s) affected)
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK_tblstate'. Cannot insert duplicate key in object 'tblstate'.
The statement has been terminated.

(0 row(s) affected)
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK_tblstate'. Cannot insert duplicate key in object 'tblstate'.
The statement has been terminated.

(0 row(s) affected)
Msg 2714, Level 16, State 5, 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 5, 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 web30licensecompliance, Line 4
Invalid object name 'dbo.tblLicenses'.
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 Web30totalnonactive, Line 5
Invalid object name 'dbo.web30repallcompstates'.
Msg 208, Level 16, State 1, Procedure Web30totalerror, Line 4
Invalid object name 'dbo.tblComputers'.
Msg 208, Level 16, State 1, Procedure Web30totalerror, Line 4
Invalid object name 'dbo.web30repallcompstates'.
Msg 208, Level 16, State 1, Procedure Web30totalerror, Line 4
Invalid object name 'dbo.tblComputersystem'.
Msg 208, Level 16, State 1, Procedure web30totalClients, Line 4
Invalid object name 'dbo.tblComputers'.
Msg 208, Level 16, State 1, Procedure web30totalClients, Line 4
Invalid object name 'dbo.tblComputersystem'.
Msg 208, Level 16, State 1, Procedure web30totalClients, Line 4
Invalid object name 'dbo.web30repallcompstates'.
Msg 208, Level 16, State 1, Procedure web30totalServers, Line 4
Invalid object name 'dbo.tblComputers'.
Msg 208, Level 16, State 1, Procedure web30totalServers, Line 4
Invalid object name 'dbo.tblComputersystem'.
Msg 208, Level 16, State 1, Procedure web30totalServers, Line 4
Invalid object name 'dbo.web30repallcompstates'.
Msg 208, Level 16, State 1, Procedure web30totaldomain, Line 5
Invalid object name 'dbo.tblComputers'.
Msg 208, Level 16, State 1, Procedure web30totaldomain, Line 5
Invalid object name 'dbo.Web30totalnonactive'.
Msg 208, Level 16, State 1, Procedure web30totaldomain, Line 5
Invalid object name 'dbo.web30totalServers'.
Msg 208, Level 16, State 1, Procedure web30totaldomain, Line 5
Invalid object name 'dbo.Web30totalerror'.
Msg 208, Level 16, State 1, Procedure web30totaldomain, Line 5
Invalid object name 'dbo.web30totalClients'.
Msg 208, Level 16, State 6, Procedure Web30computers, Line 3
Invalid object name 'dbo.Web30computers'.
Msg 2714, Level 16, State 5, Procedure web30hwSerials, Line 3
There is already an object named 'web30hwSerials' in the database.
Msg 2714, Level 16, State 5, Procedure web30hwregistry, Line 3
There is already an object named 'web30hwregistry' in the database.
Msg 2714, Level 16, State 5, Procedure web30hwfile, Line 3
There is already an object named 'web30hwfile' in the database.
Msg 2714, Level 16, State 5, Procedure web30hwmemory, Line 3
There is already an object named 'web30hwmemory' in the database.
Msg 2714, Level 16, State 5, Procedure web30hwmemoryarray, Line 3
There is already an object named 'web30hwmemoryarray' in the database.
Msg 4902, Level 16, State 1, Line 2
Cannot alter table 'tsysassetlinks' because this table does not exist in database 'master'.
0 Kudos
Hemoco
Lansweeper Alumni

‎03-11-2009 10:56 PM

You can download it from here : http://www.microsoft.com/downloads/details.aspx?FamilyID=c243a5ae-4bd1-4e3d-94b8-5a0f62bf7796&DisplayLang=en
0 Kudos
esullivan
Engaged Sweeper
In response to Hemoco

‎03-11-2009 11:03 PM

Lansweeper wrote:
You can download it from here : http://www.microsoft.com/downloads/details.aspx?FamilyID=c243a5ae-4bd1-4e3d-94b8-5a0f62bf7796&DisplayLang=en


OK I have that installed and connected to the DB, how would I run that script? I am sorry for being such a newb with SQL
0 Kudos
Hemoco
Lansweeper Alumni

‎03-11-2009 10:46 PM

You should find it in your start menu: "microsoft sql server 2005\SQL server management studio"
0 Kudos
esullivan
Engaged Sweeper
In response to Hemoco

‎03-11-2009 10:52 PM

Lansweeper wrote:
You should find it in your start menu: "microsoft sql server 2005\SQL server management studio"

I don't think we have the free version. The database was already there for Great Plains. I have an enterprise manager, but I don't see a console in there.
0 Kudos
Hemoco
Lansweeper Alumni

‎03-11-2009 10:27 PM

@esullivan, please rerun the upgradescript from the sql management console.
0 Kudos
esullivan
Engaged Sweeper
In response to Hemoco

‎03-11-2009 10:33 PM

Lansweeper wrote:
@esullivan, please rerun the upgradescript from the sql management console.


I have seen you talk of this is these issue. Where do I find that? I have not had MUCH with SQL so far. We are running Microsoft SQL Server 2005.
0 Kudos

Archive

This board contains archived posts from the retired Lansweeper Forum and Insiders Community.

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now