Ok, in my case it doesn't seem like this procedure was being used (I'm not using SP provider but SQLTableProvider). Anyway, I found that I only need to comment out UpdateLastActivityDate in the GetProfileDataFromTable method. Really, why do we need to update activity date when we're retriving data? Doesn't make much sense to me.
>Hi everybody,
>
>I'm trying to solve a problem with updating last activity date when I access Profiles properties.
>
>I found the following SP
>ALTER PROCEDURE [dbo].[aspnet_Profile_GetProperties]
> @ApplicationName nvarchar(256),
> @UserName nvarchar(256),
> @CurrentTimeUtc datetime
>AS
>
>which does update Last activity date at the end. I'm not sure if my page indeed calls this SP and is there a way to minimize the changes or do it conditionally.
>
>The GetProfiles method I didn't find and it doesn't accept the logical parameter in the current implementation.
If it's not broken, fix it until it is.
My Blog