• Introducing WebPros Cloud - a fully managed infrastructure platform purpose-built to simplify the deployment of WebPros products !  WebPros Cloud enables you to easily deliver WebPros solutions — without the complexity of managing the infrastructure.
    Join the pilot program today!
  • Support for BIND DNS has been removed from Plesk for Windows due to security and maintenance risks.
    If a Plesk for Windows server is still using BIND, the upgrade to Plesk Obsidian 18.0.70 will be unavailable until the administrator switches the DNS server to Microsoft DNS.

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