Post reply

SQL server Collation

  • July 1, 2011 at 4:44 am

    #253807

    Hi All,

    I have db on developement server. If i check for the properties the collation is Case Insesitive. If I go into the tables and check the propery in SSMS the collation is CI only. If i script out the table to create script then also collation does not appear in that. But what we are doing is we are using TFS for scripts sorce control. So whenever any changes ocure on the table structure on developemnt we checks that script to TFS to have latest modification. The question is when i compare the script in TFS and and developement db table, the table creation script show collation as Case Sensitive. Not able to figure out what is happening? is there any way to remove the case sensitive collation so that i can have the default collation settings on the developement DB.

    Thanks in advance

  • July 1, 2011 at 12:30 pm

    #1347260

    vinod.saraswat (7/1/2011)

    I have db on developement server. If i check for the properties the collation is Case Insesitive. If I go into the tables and check the propery in SSMS the collation is CI only. If i script out the table to create script then also collation does not appear in that. But what we are doing is we are using TFS for scripts sorce control. So whenever any changes ocure on the table structure on developemnt we checks that script to TFS to have latest modification. The question is when i compare the script in TFS and and developement db table, the table creation script show collation as Case Sensitive. Not able to figure out what is happening? is there any way to remove the case sensitive collation so that i can have the default collation settings on the developement DB.

    You may want to take a look at this... http://msdn.microsoft.com/en-us/library/ms179254.aspx

    _____________________________________
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at Amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply