By default Plesk does not give full access to run most SQL Queries on a database.
2 options exist.
1. Provide us with the SQL Query though we will need to first go through the query and ensure it safe to run on the server etc.
Alternatively:
2. Export your database using SQL Management Studio and your db details or export using Plesk itself.
Then import it into your local machines instance on SQL Server on your PC.
Then run the SQL Query locally.
Once done you can now import the DB back onto the Plesk Shared hosting server via Plesk or SQL Management Studio and all should be working.
Meest populaire
SQL Query to find highest CPU usage by database
WITH CPU_Per_DbAS(SELECT dmpa.DatabaseID , DB_Name(dmpa.DatabaseID) AS [Database] ,...
The query has been cancelled because the estimated cost of this query
The error : The query has been cancelled because the estimated cost of this query (xxxx) exceeds...
Do you offer ASPState database on SQL Servers?
We looked into this thoroughly and found that its a huge security risk as the ASPState database...
