Ask the Community
Groups
Unable to import procedure - Unapproved SQL Commands - Connect IT Community | Kaseya
<main> <article class="userContent"> <p><strong>PROBLEM</strong></p> <p><em>I am unable to import a procedure, I get an error: Attempt to import procedure with unapproved SQL commands.</em></p> <p> </p> <p><strong>CAUSE</strong></p> <p><em>This is due to a missing SQL procedure on your KServer.</em></p> <p> </p> <p><strong>RESOLUTION</strong></p> <p><em>If you are adding an SQL Query or NonQuery into your procedure, you will need an associated XML file available on your KServer. More on this can be found on our help file - <a id="h7612" title="" rel="nofollow" href="/home/leaving?allowTrusted=1&target=http%3A%2F%2Fhelp.kaseya.com%2FWebHelp%2FEN%2FKSD%2F1040000%2Findex.asp%234009.htm%23o7588">executeSqlNonQuery()</a> and <a id="h7613" title="" rel="nofollow" href="/home/leaving?allowTrusted=1&target=http%3A%2F%2Fhelp.kaseya.com%2FWebHelp%2FEN%2FKSD%2F1040000%2Findex.asp%234009.htm%23o7589">executeSqlQuery()</a>.</em></p> <p> </p> <div> </div> </article> </main>