SQL stored procedures are single SQL statements that are statically bound to the database and can be used by any client.

The access service does not support creating SQL stored procedures, because the SQL transformation process does not provide support to handle the translation. You must create SQL stored procedure source code outside of ECDA Option for ODBC.

The access service does not support either dropping SQL stored procedures or granting authorization for them. Both of these functions are target-dependent.