I have created a new database in SQL Server 2005 and execute generated script from the old database.
In that I have a table called
When I try to execute the following query which has the table name in uppercase
SELECT City FROM MSTCITY WHERE City = 'Junagadh'
I get an error
Invalid object name 'MSTCITY'
When I execute this
SELECT statement it works fine
SELECT City FROM MstCity WHERE City = 'Junagadh'
In the old database both
SELECT statement work fine. And both database are in SQL Server 2005 only.