In my signup process I inform the user that they must logon to the site within 24 hours otherwise the account will be deleted. Currently I check this manually and each day there are some users that did not login within 24 hours. I need to manually remove those users.

How do I create a scheduled task that runs every day and deletes those users? It should NOT delete all unauthorized users but only those who did not logon to the site within 24 hours.

You may wonder why I want this. If I don't do this I will have hundreds of unauthorized users in my database and I don't want that. Most of the time those users have invalid email addresses.

I would like to know the answer to this as well.

Right now I am writing a stored procedure that Checks if the aspnet_Membership table has any records that have the same create and last login dates that are the same, and if any of those records are more than 7 days old (or in your case, more than 24 hors old).  We are setting it up so that SQL Server (2005) runs the stored procedure once a day.

Any thoughts on this?

Sorry for this quick and dirty post (I am really short on time).  You will need to modify the script from using day to hour and change it from 7 to 24:

Create Procedure Remove_Old_Unregistered_Users

Delete aspnet_Users

Where UserId in

(Select UserId From aspnet_Membership

WHERE CreateDate = LastLoginDate

AND DateDiff(day, GetDate(),CreateDate) >= 7 )

Delete aspnet_Membership

WHERE CreateDate = LastLoginDate

AND DateDiff(day, GetDate(),CreateDate) >= 7