Hi, I would like to know what is the impact if Case sensitivity option is set to “Yes” in NAV (e.g. when creating a new database with the SQL option) although Case sensitivity was set to “No” when installing SQL 2005 Server? Many thanks,
no impact. Every db can have it’s own collation. If you are doing cross db queries, then you’ll need to add to sql statement to get the data in the correct collation.
Ok thanks for your answer, In fact do you recommande to set case sensitivity to Yes? My question is vague but I don’t really estimate the use of this option… What is the more common? Many thanks,