6624474d   
   From: esquel@sommarskog.se   
      
   Joe Cool (joecool1969@live.com) writes:   
   > I have several databases on a SQL2005 server. All were created the   
   > same way, using the SQL Server Management Studio create new database   
   > wizard. On ONE and ONE ONLY of those databases if I try to generate a   
   > list of tables in that database using:   
   >   
   > select table_name from information_schema.tables where table_type =   
   > 'BASE TABLE' order by table_name   
   >   
   > I get the following error:   
   >   
   > Invalid object name 'information_schema.tables'.   
   >   
   > If I check the list of system views with the object browser, the view   
   > is indeed there.   
   >   
   > This works just fine for all of the other databases on the same   
   > server.   
   >   
   > Any ideas why I am getting this error?   
      
   It's spelled INFORMATION_SCHEMA.TABLES. Which does not matter in a   
   database with a case-insensitive collation, but in a database   
   with a case-sensitive or binary collation it does.   
      
      
   --   
   Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se   
      
   Links for SQL Server Books Online:   
   SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx   
   SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx   
   SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)