WebForms, GridView, SQL Stored Procedures and SQL Schema's
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

