Share via

Add User Profiles

  • Article

In this tutorial, you will develop a personalized Active Server Page (ASP) page that provides a personalized message body to Direct Mailer. For example, the e-mail will start with "Dear <name of the e-mail recipient>" instead of "Dear Site Visitor." The mailing list you use includes both an e-mail address and a user ID for all entries. For each recipient in the mailing list, Direct Mailer generates a User Profile Manager cookie based on the user ID.

In this lab, you will add four user profiles in Microsoft SQL Server.

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

  • You are adding the user profiles in Microsoft SQL Server, so you can enter the user ID for each recipient. The user ID in the user profile must match the user ID for each recipient in the mailing list.

To add a user profile

  1. Click Start, point to Programs, point to Microsoft SQL Server, and then click Enterprise Manager.
  2. Expand the nodes to the following path: \Microsoft SQL Servers\SQL Server Group\<SQL Server Name>\Databases\Retail_commerce, and then click Tables.
  3. In the right pane, scroll down and right-click the UserObject table, point to Open Table, and then click Return all rows.
  4. Input the following information for Betty User:
    Field Type this
    g_user_id BettyUser
    u_user_title System Administrator
    u_first_name Betty
    u_last_name User
    u_email_address BettyUser@microsoft.com
    U_logon_name BettyUser
  5. Input the following information for Jack User:
    Field Type this
    g_user_id JackUser
    u_user_title System Administrator
    u_first_name Jack
    u_last_name User
    u_email_address JackUser@microsoft.com
    U_logon_name JackUser
  6. Input the following information for Jane User:
    Field Type this
    g_user_id JaneUser
    u_user_title System Administrator
    u_first_name Jane
    u_last_name User
    u_email_address JaneUser@microsoft.com
    U_logon_name JaneUser
  7. Input the following information for Joe User:
    Field Type this
    g_user_id JoeUser
    u_user_title System Administrator
    u_first_name Joe
    u_last_name User
    u_email_address JoeUser@microsoft.com
    U_logon_name JackUser
  8. Close SQL Server Enterprise Manager.

Copyright © 2005 Microsoft Corporation.
All rights reserved.