SQL 2000 supported?

[JanDr]

I installed database part of Lansweeper 3.0 on SQL server 2000 and got errors as follows:

***********************************************************
*** Build Database Objects and Populate with Data ***
***********************************************************
Warning: The table 'tblADusers' has been created but its maximum row size
(17825) exceeds the maximum number of bytes per row (8060). INSERT or UPDATE of
a row in this table will fail if the resulting row length exceeds 8060 bytes.
Warning: The table 'tblComputersystem' has been created but its maximum row
size (10413) exceeds the maximum number of bytes per row (8060). INSERT or
UPDATE of a row in this table will fail if the resulting row length exceeds
8060 bytes.
Warning: The table 'tblADusers' has been created but its maximum row size
(17825) exceeds the maximum number of bytes per row (8060). INSERT or UPDATE of
a row in this table will fail if the resulting row length exceeds 8060 bytes.
Warning: The table 'tblComputersystem' has been created but its maximum row
size (10413) exceeds the maximum number of bytes per row (8060). INSERT or
UPDATE of a row in this table will fail if the resulting row length exceeds
8060 bytes.
Warning: The table 'tblADusers' has been created but its maximum row size
(17825) exceeds the maximum number of bytes per row (8060). INSERT or UPDATE of
a row in this table will fail if the resulting row length exceeds 8060 bytes.
Warning: The table 'tblComputersystem' has been created but its maximum row
size (10413) exceeds the maximum number of bytes per row (8060). INSERT or
UPDATE of a row in this table will fail if the resulting row length exceeds
8060 bytes.
Warning: The table 'tblComputersystem' has been created but its maximum row
size (10413) exceeds the maximum number of bytes per row (8060). INSERT or
UPDATE of a row in this table will fail if the resulting row length exceeds
8060 bytes.
***********************************************************

This is known limitation of SQL2000 and I don’t know any workaround except the row length fulfills this criterion (max. 8060 bytes in row). I modified table’s design experimentally and everything seems to work fine - but … (you are the author).

Jan

[JanDr]

Thank you, nice to know. However, no warnings is better than ignorance 🙂

[Hemoco]

You can safely ignore this warning, the update/insert will never be this large.
I'm running on sql 2000 without any problems.