Because these windows are Advanced Mode features designed for administrators to use, they require SQL Server sysadmin or dbo privileges as well as application level security and the System password (if used) to access.
GP Power Tools adds the new Executer windows to allow normal users to execute scripts which have been marked as “Published to Executer Window”. There are three Executer windows, one for each of the Execute windows (Runtime Execute, SQL Execute and .Net Execute).
The scripts that you publish can use Helper Functions to call other scripts in other languages. For example you can use Dexterity, Visual C# or Visual Basic.Net to add some dialogs to get parameter values before calling a SQL script.
This article was originally posted on http://www.winthropdc.com/blog.