none
Case Sensitive database RRS feed

  • Question

  • Hi,

    I have attached a database to my server.

    I just found out that it is case sensitive.

    The model database is case insensitive.

    Is this setting set when I attached the database?

    Many thanks,

    Ben



    Mr Shaw... One day I might know a thing or two about SQL Server!

    Friday, June 19, 2015 3:41 PM

Answers

  • yes, when you attach or restore a database, the database settings are preserved.

    So, that CS property is coming from the database itself. in other words, before the database was deattached, it had Case Senstive collation enabled, and when deattached and reattached that collation will still be Case senstive collation and not the server collation.


    Hope it Helps!!

    • Marked as answer by Mr Shaw Friday, June 19, 2015 5:04 PM
    Friday, June 19, 2015 4:52 PM

All replies

  • Hello Ben,

    No, for system objects the collation is defined on (user) database level and for custom tables is defined on column level; so the CS setting was already defined for the database before you attached it.


    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    Friday, June 19, 2015 4:22 PM
    Moderator
  • yes, when you attach or restore a database, the database settings are preserved.

    So, that CS property is coming from the database itself. in other words, before the database was deattached, it had Case Senstive collation enabled, and when deattached and reattached that collation will still be Case senstive collation and not the server collation.


    Hope it Helps!!

    • Marked as answer by Mr Shaw Friday, June 19, 2015 5:04 PM
    Friday, June 19, 2015 4:52 PM
  • Thank you so much... I thought I did something silly. :)

    Mr Shaw... One day I might know a thing or two about SQL Server!

    Friday, June 19, 2015 5:04 PM