Cleanup inactive anonymous users from ASP.NET Membership Tables

re: Cleanup inactive anonymous users from ASP.NET Membership Tables

Alain — Sat, 19 Sep 2009 04:20:10 GMT

Thanks for the script, and thanks for all your aticles, actually just found 2 articles for you today when i was looking for information about member profiles... And they really helped me understand the concept and i did implement them on my projects...

Thanks a lot :)

re: Cleanup inactive anonymous users from ASP.NET Membership Tables

Kathy Slattengren — Thu, 11 Jun 2009 18:33:54 GMT

Thanks for the script; it works great. However, the disk space used by the tables is not reduced after the rows have been deleted. Is there something else I need to do?

re: Cleanup inactive anonymous users from ASP.NET Membership Tables

Ray Akkanson — Fri, 10 Apr 2009 13:06:03 GMT

Very helpful stored proc

Thanks

Ray Akkanson

re: Cleanup inactive anonymous users from ASP.NET Membership Tables

Lee Dumond — Sat, 22 Mar 2008 07:41:42 GMT

I ran this on one of my DBs with which I use anonymous profiles, and it seems to work. It did get rid of a lot of rows in the users table!

However, I'm not using widgets, pages, or UserSettings at all in this site, so the script threw several errors:

Msg 208, Level 16, State 1, Line 3

Invalid object name 'Page'.

Msg 208, Level 16, State 1, Line 3

Invalid object name 'WidgetInstance'.

Msg 208, Level 16, State 1, Line 3

Invalid object name 'Page'.

Msg 208, Level 16, State 1, Line 3

Invalid object name 'UserSetting'.

Should I just comment out the lines that refer to these non-existent objects? Or is it all right to run the script as-is, and just let the errors occur?

re: Cleanup inactive anonymous users from ASP.NET Membership Tables

Gamer000 — Thu, 13 Mar 2008 05:25:07 GMT

If someone would be so kind as to inform me, a simple asp user on how to use/run this DB Script. Is it something I load into a file then execute, or do I put it into a console? Any help given is much appreciated.

re: Cleanup inactive anonymous users from ASP.NET Membership Tables

Suprotim Agarwal — Sun, 02 Mar 2008 05:28:19 GMT

Quiet an interesting script indeed. Thanks for it.

re: Cleanup inactive anonymous users from ASP.NET Membership Tables

coder1 — Tue, 01 Jan 2008 18:43:47 GMT

interesting...

why is everyone saying interesting? lol

re: Cleanup inactive anonymous users from ASP.NET Membership Tables

Holf — Mon, 17 Sep 2007 08:03:25 GMT

Sorry... meant Omar's method!

re: Cleanup inactive anonymous users from ASP.NET Membership Tables

Holf — Sun, 16 Sep 2007 20:03:18 GMT

In response to Allan:

Membership.DeleteUser(Request.AnonymousID, True)

is fine for handling one user.

But if you want to delete hundreds or thousands of users it would be very inefficient to do hundreds or thousands of individual database calls.

Vikram's method handles all users in one go.

re: Cleanup inactive anonymous users from ASP.NET Membership Tables

Fotis — Tue, 31 Jul 2007 22:34:29 GMT

interesting

re: Cleanup inactive anonymous users from ASP.NET Membership Tables

Martinos — Fri, 27 Jul 2007 12:10:37 GMT

Interesting...

re: Cleanup inactive anonymous users from ASP.NET Membership Tables

Anaklets — Sat, 21 Jul 2007 15:17:32 GMT

Interesting...

re: Cleanup inactive anonymous users from ASP.NET Membership Tables

Athones — Mon, 16 Jul 2007 20:53:59 GMT

Interesting...

re: Cleanup inactive anonymous users from ASP.NET Membership Tables

Panicos — Sun, 15 Jul 2007 22:11:06 GMT

interesting

re: Cleanup inactive anonymous users from ASP.NET Membership Tables

Elias — Sat, 14 Jul 2007 20:15:19 GMT

interesting

re: Cleanup inactive anonymous users from ASP.NET Membership Tables

Allan — Wed, 27 Jun 2007 01:50:22 GMT

its easy to clean membership just call

Membership.DeleteUser(Request.AnonymousID, True)

re: Cleanup inactive anonymous users from ASP.NET Membership Tables

Carolos — Mon, 25 Jun 2007 14:50:18 GMT

Interesting...

re: Cleanup inactive anonymous users from ASP.NET Membership Tables

Apostolis — Fri, 22 Jun 2007 15:38:24 GMT

interesting

re: Cleanup inactive anonymous users from ASP.NET Membership Tables

Matthaios — Thu, 21 Jun 2007 17:15:07 GMT

interesting

re: Cleanup inactive anonymous users from ASP.NET Membership Tables

Aristotelis — Fri, 08 Jun 2007 10:09:32 GMT

interesting