---
title: Specifying a stored procedure location
description: If you are using a stored procedure for provisioning the user database, specify its location on the Stored Procedure Location tab.
component: pingfederate
version: 13.1
page_id: pingfederate:administrators_reference_guide:help_userprovisioningtasklet_selectdatabaseschemaandstoredprocstate
canonical_url: https://docs.pingidentity.com/pingfederate/13.1/administrators_reference_guide/help_userprovisioningtasklet_selectdatabaseschemaandstoredprocstate.html
llms_txt: https://docs.pingidentity.com/pingfederate/llms.txt
docs_for_agents: https://developer.pingidentity.com/build-with-ai/docs-for-agents.md
revdate: July 5, 2022
section_ids:
  about-this-task: About this task
  steps: Steps
  result: Result:
  troubleshooting: Troubleshooting:
---

# Specifying a stored procedure location

If you are using a stored procedure for provisioning the user database, specify its location on the **Stored Procedure Location** tab.

## About this task

![Screenshot of the Stored Procedure Location tab showing the Stored Procedure field.](_images/sts1564003518439.jpg)

|   |                                                                                                                                                                                                    |
| - | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
|   | This window appears only when you have chosen a Microsoft SQL Server datastore on the **User Repository** tab and the you have selected the **Stored Procedure** option on the **SQL Method** tab. |

## Steps

1. From the **Schema** menu, select the table structure that contains stored procedure within the database.

2. From the **Stored Procedure** menu, select the stored procedure needed to provision the user database.

   |   |                                                                                                                                                             |
   | - | ----------------------------------------------------------------------------------------------------------------------------------------------------------- |
   |   | The database account used by PingFederate must have access to the schema in which the stored procedure is located and execute permission for the procedure. |

   ### Result:

   For the selected procedure, all parameters and their data types display in the **Procedure parameters to fulfill** section.

   |   |                                                                                                                                                                                                                  |
   | - | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
   |   | To see a list of available attributes from the single sign-on (SSO) token, click **View Attribute Contract**.You map attribute values from the SSO token to the parameters on the **Attribute Fulfillment** tab. |

   ### Troubleshooting:

   If the list of parameters is not current due to any recent procedure revisions, click **Refresh**.