hi Lawson experts (I'm not one),

I'm a SQL Server DBA.

We are implementing Lawson 9 running with SQL Server 2005 databases in a Windows environment.

For whatever reason, when SQL Server was installed on this server (they) specified that the collation be Latin_General_BIN which results in the database being case-sensitive. In an SQL statement, you must reference the table, column or whatever exactly as it is defined or named. To select from TABLE1 you must use Select * from dbo.TABLE1... if you use "table1" you get 'object not found'.

Sorry for the above example but some may not know what the collation means.

My question is: If using SQL Server, do Lawson 9 databases HAVE to use case-sensitivity? I read that Latin_General_BIN gives faster sorts. But the time to code SQL stmts against these tables is going to be a real pain... I think.

I know very little about Lawson, so please be easy on me.

Thanks, John

I've only worked with one client that had version 9 installed on a SQL database, and this particular implementation was case-sensitive. Honestly, not sure if this is recommended practice or not. But I would guess that the install guide would indicate one way or another. I can't say that I noticed any issues b/c of this, other than it's a bit of a pain when writing sql queries.