Installation and Upgrade Guides › Policy Server Installation Guide › Configuring SiteMinder Data in a Relational Database › Configure SQL Server Data Stores › How to Store Audit Logs in SQL Server › Create the Audit Log Schema

Create the Audit Log Schema

You create the logging schema so the SQL Server database can store audit logs.

To create the audit log schema

1. Open sm_mssql_logs.sql in a text editor and copy the contents of the entire file.
2. Start the Query Analyzer and log in as the user who administers the Policy Server database.
3. Select the database instance from the database list.
4. Paste the schema from sm_mssql_logs.sql into the query.
5. Execute the query.

   The SiteMinder audit log store schema is created in the database.