Step 1: Create Custom User Profiles Attributes

  • Article

In this step you will create new database columns for two new user attributes (gender and user description).

  1. Click Start, point to Programs, point to Microsoft Commerce Server 2002, and then click Commerce Server Manager.

  2. In Commerce Server Manager, expand Microsoft SQL Servers, expand SQL Server Group, expand <Server Name>, expand Databases, expand NorthwindTraders_commerce, and then click Tables.

    Ee824724.note(en-US,CS.20).gifNote

    • Make sure your SQL Server service has been started before proceeding to the following steps.

  3. In the tables list, right-click UserObject, and then select Design Table.

    In the Design Table 'UserObject' in 'NorthwestTraders_commerce' on <Server Name> window, scroll down to the bottom of the list, and then add the following two data members:

    Column Name Data Type Length Allow Nulls
    u_gender varchar 10 Yes
    u_userDescription varchar 20 Yes

    Ee824724.note(en-US,CS.20).gifNote

    • The Design Table displays all the data members present in the selected table.

  4. To save the data members click Save on the toolbar.

  5. Close Commerce Server Manager.

Copyright © 2005 Microsoft Corporation.
All rights reserved.