Help with aspnet_ membership and role management

Discussion in 'ASP .Net' started by Keith, Jul 4, 2006.

  1. Keith

    Keith Guest

    Why can't my ASP.NET application run custom stored procedures against the
    aspnet_Users table. For example, the aspnet_Users table has 2 records and
    yet the following stored procedure

    ALTER PROCEDURE [dbo].[GetUsers]
    AS
    SELECT ApplicationId, UserId, UserName, LoweredUserName, MobileAlias,
    IsAnonymous, LastActivityDate
    FROM aspnet_Users

    returns no data, only column headings and:

    No rows affected.
    (1 row(s) returned)
    @RETURN_VALUE = 0
    Finished running [dbo].[GetUsers]

    Thanks,

    Keith
     
    Keith, Jul 4, 2006
    #1
    1. Advertisements

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

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Liet Kynes
    Replies:
    0
    Views:
    686
    Liet Kynes
    Nov 26, 2003
  2. Philipp Lenz
    Replies:
    1
    Views:
    522
    =?Utf-8?B?T2xkbWFu?=
    Dec 2, 2005
  3. =?Utf-8?B?am9iaSBqb3k=?=

    Tivoli Vs ASP.NET2 on Role/Membership management

    =?Utf-8?B?am9iaSBqb3k=?=, Dec 8, 2005, in forum: ASP .Net
    Replies:
    1
    Views:
    784
    Cowboy \(Gregory A. Beamer\)
    Dec 8, 2005
  4. Bruno
    Replies:
    4
    Views:
    2,006
    Bruno
    Jan 4, 2006
  5. Griff
    Replies:
    1
    Views:
    459
    clintonG
    Sep 22, 2006
  6. AAOMTim

    newbie - role & membership management

    AAOMTim, Jan 12, 2006, in forum: ASP .Net Security
    Replies:
    1
    Views:
    221
    Dominick Baier [DevelopMentor]
    Jan 12, 2006
  7. Mike Robbins
    Replies:
    1
    Views:
    212
  8. Griff
    Replies:
    1
    Views:
    231
    clintonG
    Sep 22, 2006
Loading...