• We value your experience with Plesk during 2025
    Plesk strives to perform even better in 2026. To help us improve further, please answer a few questions about your experience with Plesk Obsidian 2025.
    Please take this short survey:

    https://survey.webpros.com/

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