To publish data using a stored procedure, select the option that allows you to execute Transact-SQL stored procedures. You can choose from a list of available stored procedures and saved queries.