INFORMATION_SCHEMA not found problem in MSSQL

Case sensitivity property of the database can cause the error:

Error 'Invalid object name INFORMATION_SCHEMA.TABLES'

In order to fix this problem, we need to change db collation. Collation must contain CI suffix like "SQL_Latin1_General_CP1_CI_AS collation"

ALTER DATABASE Database_name COLLATE SQL_Latin1_General_CP1_CI_AS

You can also see your current collation:
Select @@servername, SERVERPROPERTY(N'Collation')

No comments:

Post a Comment