stored procedures run against aspnet_* tables return no data rows

  • Thread starter Thread starter Keith
  • Start date Start date
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
 
Is there an apostrophe or some other unescaped character in the data?
 
Did you create a provider entry in web.config for your database?
Sounds like the app is using the default database in App_Data and maybe
you're accessing a custom database?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top