Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Debugging ASP.NET page that may use SP
Message
 
General information
Forum:
ASP.NET
Category:
Other
Environment versions
OS:
Windows XP
Database:
MS SQL Server
Miscellaneous
Thread ID:
01310432
Message ID:
01310445
Views:
14
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
Previous
Reply
Map
View

Click here to load this message in the networking platform