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
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center