I am having a problem adding a stored procedure to my SQL 2005 Database by creating a new stored procedure from the Table Adapter. I am using VS 2008 with SQLExpress 2008 installed.
The error that I am getting is: The wizard detected the following problems when configuring the Table Adapter Fill Details. There was a problem with the SELECT stored procedure. The stored procedure was not created. Adding new stored procedure to the database failed. The specified schema doingitmyway either does not exist or you do not have permission to use it.
I can create a stored procedure from the SQL DB but not from the Table adapter as I have with local db's. Does anyone have any idea what this message is from and how to resolve the issue.
The query that I used to create the stored procedure from the Data Table Wizzard was simple:
SELECT MaikeyID, MaikeyName