Thread: ASP.NET/ASP.NET 2.0 Website Programming Problem Design Solution BOOK ISBN: 978-0-7645-8464-0

ASP.NET 2.0 Website Programming Problem Design Solution BOOK ISBN: 978-0-7645-8464-0
Clear database:

delete from aspnet_profile
where userid in
(select userid from aspnet_users
  where isanonymous = 1
    and datediff(dd, LastActivityDate, getdate()) > 60)
go
delete from aspnet_users
where isanonymous = 1
  and datediff(dd, LastActivityDate, getdate()) > 60
go


Plus we need to clear aspnet_WebEvent_Events table!

The main forum connected to this book