ASPNETDB Database

View: vw_aspnet_Profiles

Description

Displays user profile information.

Columns

Name  Type  Required?  Defaults To  Description 
UserId  uniqueidentifier  Yes    ID of the user to which this profile data pertains
LastUpdatedDate  datetime  Yes    Date and time this profile was last updated
DataSize  int  No    Size of the profile data

Tables Referenced

Name 
aspnet_Profile 

Definition

SELECT [dbo].[aspnet_Profile].[UserId], [dbo].[aspnet_Profile].[LastUpdatedDate],
      [DataSize]=  DATALENGTH([dbo].[aspnet_Profile].[PropertyNames])
                 + DATALENGTH([dbo].[aspnet_Profile].[PropertyValuesString])
                 + DATALENGTH([dbo].[aspnet_Profile].[PropertyValuesBinary])
  FROM [dbo].[aspnet_Profile]

ASP.NET 2.0 Provider Database