This is a migrated thread and some comments may be shown as answers.

Database first wizard does not show stored procedures

1 Answer 23 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
This question is locked. New answers and comments are not allowed.
Lisa
Top achievements
Rank 1
Lisa asked on 28 Apr 2014, 05:32 PM
I am adding a second OA model to my solution so that I can access a stored procedure in a different database. When I use the set up wizard (database first) and get to the Add Database Items screen, none of the stored procedures are listed or available to select. Any idea why stored procedures do not show up in the wizard? I was able to add stored procedures from the first database to the first model. I do have permissions to execute stored procedures on the second database.
THanks

1 Answer, 1 is accepted

Sort by
0
Lisa
Top achievements
Rank 1
answered on 29 Apr 2014, 12:17 AM
It turns out I did not have sufficient permissions to execute the stored procedure after all. Once I fixed that, it did appear in the dialog box as expected.
I still have a problem executing it, but I will post that in a separate thread.
Tags
General Discussions
Asked by
Lisa
Top achievements
Rank 1
Answers by
Lisa
Top achievements
Rank 1
Share this question
or