Using SQL Functions with EZWriter

If you have access to your Momentus Enterprise database and a database management tool such as SQL Server Management Studio, you can create SQL Functions to return formatted data for EZWriter.  These are especially useful if you require nested tables instead of one data table in your Data Format.  You can create a SQL Function to return the data already wrapped in the appropriate HTML tags.  For more information on creating SQL Functions please visit Microsoft TechNet.

Once you have created a SQL function, however, you must make sure that EZWriter has permission to run it.  These instructions are based on SQL Server Management Studio.  If you are using a different tool to access your database, you will need to learn how to set object permissions.

1. In the Object Explorer Window, navigate to Programmability, Functions, Scalar-valued Functions (or Table-valued Functions if that is what you have created) and right click on the name of your function.

2. Select Properties.

3. Navigate to the Permissions page

4. Click the Search button

5. Enter ebmsuser and click the Check Names button, the click OK.

6. Under the Explicit tab for ebmsUSER, check the Grant checkbox next to Execute.

7. Click OK to save the changes.

Now EZWriter pages will be able to run your SQL Function.