K
Keith
I used the ASP.NET SQL Server Setup Wizard (aspnet_regsql.exe) to configure
my application's SQL Server database for ASP.NET services such as membership
and role management. Everything works fine when using the Web Site
Administration Tool and the login controls, or when using SQL Server
Management Studio to open the tables. However, my own stored procedures
against the aspnet_* tables do not return any rows.
For example:
ALTER PROCEDURE [dbo].[GetUsers]
AS
SELECT * From aspnet_Users
Returns only column headings and no data, even though the table contains 2
rows of data. What could be causing this?
Thanks,
Keith
my application's SQL Server database for ASP.NET services such as membership
and role management. Everything works fine when using the Web Site
Administration Tool and the login controls, or when using SQL Server
Management Studio to open the tables. However, my own stored procedures
against the aspnet_* tables do not return any rows.
For example:
ALTER PROCEDURE [dbo].[GetUsers]
AS
SELECT * From aspnet_Users
Returns only column headings and no data, even though the table contains 2
rows of data. What could be causing this?
Thanks,
Keith