• If you are still using CentOS 7.9, it's time to convert to Alma 8 with the free centos2alma tool by Plesk or Plesk Migrator. Please let us know your experiences or concerns in this thread:
    CentOS2Alma discussion

change collation on ms sql problem

T

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.!

Tal,
 
Back
Top