Last post Jun 23, 2006 03:41 AM by zhuhua1006
Oct 18, 2005 11:28 AM|Bueto|LINK
I have implemented the SqlMembership functionallity and i have found one small problem.
When im deleting a user from SqlMembership by using aspnet web administration tool, the user and the profile (and other data) thats connected to the user is not deleted. The only place that the user is deleted from is from the table
aspnet_Membership not from the other tables that its connects to (like aspnet_Users and aspnet_UsersInRoles ex...).
I asume when i uses the web administration tool to delete a users the tool uses the Stored Procedure:
When i take a closer look at it i found that after this row (-- Delete from aspnet_UsersInRoles table if (@TablesToDeleteFrom & 2) is set) something goes wrong since it deletes the user from
the aspnet_Membership table.
Has anyone had this problem when you using the SqlMembership in asp.net 2.0. The database is SQL 2005
The Stored Procedure looks like this:
Jun 22, 2006 04:02 PM|baloodevil|LINK
I have found that the same thing happens. I am also using SQL Server 2005.
Did you find a solution?
Jun 23, 2006 03:41 AM|zhuhua1006|LINK
I have no problem on my side. When I delete a user in web site administration tool, all the related info is deleted from the database.
Since there are two condition here, one is @TablesToDeleteFrom
<> 0 and the other is
name FROM sysobjects
can you verify which condition is false? Maybe you need to use sql profiler to get a trace which is helpful to narrow down the issue.