stored procedures run against aspnet_* tables return no data rows

[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

[mattmorg55]

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?

Keith wrote:

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

[Ken Cox [Microsoft MVP]]

Is there an apostrophe or some other unescaped character in the data?

"Keith" <kb******@dslextreme.comwrote in message
news:12*************@corp.supernews.com...

>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