David,

I have some case-sensitive SQL Server 2000 databases, running Lawson 9. A few adjustments are needed in some of the script syntax, if anyone else is running a case-sensitive database.

(Need to change 'Name' to 'name' for all occurances in the query below.)

Collect Database Status Container

Step 7

Sub-Step 1

Sub-Sub-Step 3

SQL Command Text:

SELECT CONVERT(NVARCHAR(128), SERVERPROPERTY('Servername')) AS [Server],

ISNULL(RTRIM(CONVERT(NVARCHAR(128),

SERVERPROPERTY('InstanceName'))), 'Default') AS InstanceName,

master..sysdatabases.name AS DatabaseName ,

CONVERT(sysname,DATABASEPROPERTYEX(name,'Status')) AS DatabaseStatus,

CONVERT(sysname,DATABASEPROPERTYEX(name,'Recovery')) AS [Recovery],

CONVERT(sysname,DATABASEPROPERTYEX(name,'UserAccess')) AS User_Access,

CONVERT(sysname,DATABASEPROPERTYEX(name,'Updatability')) AS Updatability

FROM master..sysdatabases

Hopefully this will help others in a similar situation.

Happy T-SQLing