1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

change collation on ms sql problem

Discussion in 'Plesk for Linux - 8.x and Older' started by TALz, Apr 24, 2006.

  1. TALz

    TALz Guest

    i got plesk 7.5 installed on a windows 2003 machine, a few days ago a client called me saying he want`s to change the collation on his db, and it wont let him.
    so at first i thought it`s because i got the MSDE that comes by default, so i upgraded and installed MSSQL2000, but he still got the same problem and he asks for the SA password.
    my question is, what do i need to do so that client can do what ever he want`s with his DB w/o giving him the SA password, cause if he changes the collation wont that new set will be by default for all new DB`s that will be created ?
    how can he change it only to his DB?

    this is a big problem which i need help with ASAP,
    thank you for ur help guys.!