SQL Server Table Names – Case Sensative

Yesterday I was at a client site rolling out a program that Saberware had developed.  Needless to say, the program did not work properly out of the gate.  After a little digging I found that I had a query referencing a table called ARINVOICE.  The table existed in the SQL Server Database, but it was spelled ArInvoice.  Once I matched the case, all was well.  So, from what I read, Table and Field case sensitivity is a configuration setting within SQL Server.  So, buyer beware!

This entry was posted in Programming. Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>