Im building a small windows app and am trying to create a data access layer using the table adapter configuration wizard. I have several tables in a database.
In the wizard I select 'New Connection'
Choose the server, use windows authentication and pick the database. My windows account has dbo privavleges in the database so I can create stored procedures
I select 'Create New stored procedures', following the wizard i pick a table, select the columns and set a filter
Following through to the end at the last stage i get an error telling me the SELECT strored procedure could not be created. NO stored procedures are subsequently created in the database. This is a process Ive followed many many times in other projects (all web apps, this is the first win app) and its always worked. The connection string seems to be correcte, its using integrated security and my login can create tables, storeed procedures, etc. No matter how many times I attempt this, it always fails with the same error
Does anyone know what could be the problem ???