Running the Address Book SQL Script

You must use either the ISQL command-line utility or the SQL Server Enterprise Manager to run an SQL script that:

• Creates a new database, AddrBookDB, on the default device.
  
  
• Connects to the correct database (AddrBookDB; if you rename your database, make sure you change the Database Name in the ODBC connection DSN setup).
  
  
• Creates an Employee table.
  
  
• Populates the table with sample data.
  
  
• Runs a simple SELECT statement to verify the population of the database table.
  
  
• Sets up a user account called "ADCDemo" with a password of "ADCDemo."

You must run the supplied SQL script file (Sampleemp.sql) to create and populate the Employee table. By default, the Employee table is created in a newly created database, AddrBookDB, on the local SQL server.

To run the Sampleemp.sql script

1. Click Start, point to Programs, then point to Microsoft SQL Server 6.5. Click SQL Enterprise Manager.
   
   
2. From the Tools menu choose SQL Query Tool.
   
   
3. Click the Load SQL Script button (the open folder on the toolbar) and browse to Program Files\Common Files\System\MSADC\Samples\AddressBook.
   
   
4. Choose the file Sampleemp.sql. Click Open. Click the Execute Query button (the green arrow on the toolbar).
   
   
5. After it executes, close the Query and Enterprise Manager windows.