Step 1: Create Custom User Profiles Attributes
In this step you will create new database columns for two new user attributes (gender and user description).
Click Start, point to Programs, point to Microsoft Commerce Server 2002, and then click Commerce Server Manager.
In Commerce Server Manager, expand Microsoft SQL Servers, expand SQL Server Group, expand <Server Name>, expand Databases, expand NorthwindTraders_commerce, and then click Tables.
Note
- Make sure your SQL Server service has been started before proceeding to the following steps.
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 Note
- The Design Table displays all the data members present in the selected table.
To save the data members click on the toolbar.
Close Commerce Server Manager.
Copyright © 2005 Microsoft Corporation.
All rights reserved.