Error if MSSQL database is case sensitive

Cause:

This error may occur if the MSSQL database is case sensitive and finds invalid objects in the table name.

Error trace in logs:

java.sql.BatchUpdateException: Invalid object name ‘TABLE NAME’

Solution:

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 in the serverout file if it is a runtime error.

If you are using MSSQL 2000 then give the query below:

ALTER DATABASE servicedesk COLLATE SQL_Latin1_General_CP1_CI_AS

Need More Help?

Are you looking for a personalized customer support? Submit your question or Call our Toll Free Number to speak with ServiceDesk Plus MSP Expert who can offer a better solution for your requirements.

Submit a Ticket
Email : sdpmsp@manageengine.com
Toll Free : 1-888-720-9500