Ensure that collation will not change

• girish.nehte-1109699

  SSC Veteran

  Points: 288

  More actions

  April 17, 2012 at 4:26 am

  #392041

  Hi,

  I am using VS2008 with SQL server 2008 for my windows application. When I create my database I found some columns are having different collations I have removed there collations and now I have all the columns with same collations,. But now I want to ensure that nobody should be able to change the collation or nobody should be able to explicitly specify the collation while adding columns. Can this be done?

  Is there any setting in the database that restricts the user to change the collation or explicitly specifying collation while creating new table / columns.

  Thanks & Regards,

  Girish Nehte

• Lynn Pettis

  SSC Guru

  Points: 442467

  More actions

  April 18, 2012 at 9:20 pm

  #1475803

  Not sure, I haven't looked into much, but you might check out Policy-Based Management.