MSSQL error 'Invalid Object name'
When you get a similar error as mentioned below
java.sql.BatchUpdateException: Invalid object name 'TABLE NAME'
please change the COLLATION in the MSSQL server for the database 'servicedesk' as CASE-INSENSITIVE.
You can get this error at the time of restore or backup or you can also find this in the serverout file if it is a runtime error.
If you are running MSSQL 2000 then run the below query to alter the collation:
ALTER DATABASE servicedesk COLLATE SQL_Latin1_General_CP1_CI_AS
New to ADSelfService Plus?