Running the SQL Server sample script

To run the sample script for Microsoft SQL Server:

  1. On the database server computer, create a directory for the data files. The drive must have at least 100 MB available.
  2. Using a text editor, open the Ctrain_ModelCreate_SqlServer.sql file and change the following:
    1. Database names
    2. Sign in and user names and passwords for the administrative users
    3. FILE size setting
    4. FILEGROWTH setting
  3. Start Microsoft SQL Server Management Studio.
  4. Open the Ctrain_ModelCreate_SqlServer.sql file.
  5. Execute the script file.
  6. Verify the script executed successfully.