>I've recently run into something that surprised me. The company that I recently starting working for has a VFP application that uses MS-SQL 2000 as the database. When I first tried using the Query Analyzer my queries kept coming back with errors saying the table or column did not exist. The same was true for queries I submitted via SPT from VFP. Finally I discovered that they have set up the database and MS-SQL Server as being case sensitive which means that when you reference an object the names have to match. I use 'camel notation' when I name my objects and the existing database uses all lowercase names, therefore no match... In my previous position our MS-SQL 2000 was set up to be case insensitive. Apparently this is a one time setting you can only do when you first set up MS-SQL, so it's too late to change that now.
