Feb 16, 2006 01:59 AM|XIII|LINK
and welcome to the ASP.NET forums.
it seems that you don't have the stored procedure in your database. Open up Personal.mdf in the App_Data subfolder, in case you're using SQL Server Express (which I presume you're using). In the Server Explorer pane you should be able to see the inners of
the Personal database. Under the node "Stored procedures" you should be able to see the stored procedures. Do you see the stored procedure GetNonEmptyAlbums there?
This should be in the stored procedure:
[Albums].[IsPublic] = 1