TableAdapter Configure Wizard Stored Procs vs Database Schema

[Patrick Cournoyer]

The TableAdapter Configure Wizard creates new stored procedures under the
connection Username schema. This is undesirable when using database Schema
to organize the database objects. This seems to be a missed feature with
respect to the user-schema separation in SQL 2005.

Steps to Reproduce: Create custom schemas in SQL 2005
Create tables in any custom schema.
In VS 2005 dataset editor, drag any of the database table in a custom
schema and use the TableAdapter Configure Wizard to create new stored
procedures.

Actual Results: The stored procs are created under the current login
name.
Expected Results: The stored procs should be created under the
database schema associated with the table, or let the user select a specific
schema.


Thank you.

 

[Kevin Yu [MSFT]]

Hi Patrick,

As far as I know, this is by design, the stored procedures are created
under the user who logon to the database. If you need to put that stored
procedure under certain schema, you have to put the stored procedure under
that schema manually. HTH.

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."