Connect to mssql db

[graffiti2000]

When I try to create a new domain I get an error message:

"DNS records for domain with such name already exist"

I found this solution:

Remove these DNS records straight from Plesk database:
DELETE FROM `dns_recs` WHERE DisplayHost LIKE '%domain.com%';

Is this a good solution?

Anyway I don't know where should I write the query...how do I connect to mssql db, should I install an additional software?

thank you

Wania

 

[OlegB]

Use command line utility osql.exe

c:\> osql -E -d psa
DELETE FROM `dns_recs` WHERE DisplayHost LIKE '%domain.com%';

Plesk database name can differ from `psa`. It depends on how you named it.