Error: Msg 208 Level 16 state 1, procedure LiteSpeed_GatherJobStatistics displays when attempting to gather job statistic and DTS on Case Sensitive databases, when user try to run this command in query analyzer:
ALTER DATABASE LiteSpeedLocal
COLLATE Latin1_General_BIN
go
exec dbo.LiteSpeed_GatherJobStatistics
Server: Msg 208, Level 16, State 1, Procedure LiteSpeed_GatherJobStatistics, Line 129 Invalid object name 'DBMaintStatus'.
LiteSpeed Verbose error log may contain similar entry:
tsql = use [pubs] SELECT
db_name() as database_name
,(select cast(sum(size) as numeric(30,2))*8 from sysfiles) as database_size
, cast(SUM(FILEPROPERTY (Name, 'SpaceUsed')) as numeric(30,2))*8
FROM
sysfiles
WHERE
status & 0x40 = 0
Invalid column name 'Name'
SLS::getDatabaseInfo -> Error getting the database size
LiteSpeed 4.6.0.279 is not compatible SQL Server 7.0
Fixed in 4.6.0.000288
SQL Server 7.00 - 7.00.1063 (Intel X86) Apr 9 2002 Microsoft Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
Windows 2000 server running sql server 7 using codepage 1252.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center