WebForms, GridView, SQL Stored Procedures and SQL Schema's

ok. I am working with VS Beta 2 & the SQL Server June CTP. I developed a set of Insert/Select/Delete/Update Stored procedures on the SQL box to use with GridView. I drop a GridView control on the webform and hit "configure datasource".
When I walk through the dialog boxes presencted I select use SP's for data access and select my stored procedures from the dropdown lists.
NOTE: all of these stored procedures are under a schema which is called 'aic'. They are NOT under the dbo schema.
For example the select stored procedure is 'aic.SelectFacttable'.

All goes well during the dialog but when I select 'Refresh Schema' I get the message: Procedure: SelectFactTable (aic) not found!

We know that VS can 'see' the stored procedures (they appear in the dropdown selection list)

Also looking at the source code for the web page I see the procedures listed not as 'aic.SelectFactTable' but 'SelectFactTable (aic)' Something is very wrong here but what? Is there a security point with schema's I am missing or does VS not play well with non dbo schema's in SQL Server 2005. or what....

Any Help woudl be appreciated.

thanks.

dlr

[1173 byte] By [Dennis.Redfield] at [2007-12-16]

.NET Development

Site Classified