Stored Procedure Run Settings

Additional Run options are available in the Development Center (see Figure D.24).

Figure D.24. Setting stored procedure settings.

By changing the run settings of a procedure, as shown in Figures D.24 and D.25, you have the option of not having any changes committed. With this option, after a procedure has finished executing all changes will be automatically rolled back. This is useful for keeping the state of the database consistent while you debug your code. Scripts can also be set to run before or after the procedure executes. This gives you greater control over the testing environment of stored procedures.

Figure D.25. Setting stored procedure Run options.