#GPPT What’s New: Publish scripts to users with the new Executer windows


David Meego - Click for blog homepageOne request that I have heard a number of times is for a method to expose scripts written using Runtime Execute or SQL Execute to normal users.

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).

Runtime Executer
Runtime Executer

SQL Executer
SQL Executer

Net Executer
.Net Executer

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.

Enjoy

David

This article was originally posted on http://www.winthropdc.com/blog.

Advertisements

5 thoughts on “#GPPT What’s New: Publish scripts to users with the new Executer windows

Please post feedback or comments

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s