This product is no longer supported.

SSW SQL Auditor > Screenshots

SSW SQL Auditor
SSW SQL Auditor Wizard Pages

1. Relationships Wizard
2. Primary Key Wizard
3. Clustered Index Wizard
4. Validate Foreign Key columns Wizard
5. LastModified column Wizard
6. Timestamp Wizard

Back

  1. Relationships Wizard

    This wizard lets you modify relationships constraints on all tables. Details...

    Relationships
    Figure: Choose your script creation options

    • "Enforce Relationship For Insert And Update" - Select this means someone can't add or change records to a related table if there is no associated record in the primary table.
    • "Check Existing Data on Creation" - Select this option to check existing data when you create a relationship
      if the foreign key constraint should apply to existing data as well as to new data.
    • "Cascade Update Related Fields" - Specifies that if an attempt is made to update a key value in a row, where
      the key value is referenced by foreign keys in existing rows in other tables, all the values that make up the
      foreign key are also updated to the new value specified for the key.
    • "Exclude Relationship from Replication" - Select this option will add a NOT FOR REPLICATION clause when creating relationship. Details...
    • "Cascade Delete Realated Fields" - Specifies that if an attempt is made to delete a row with a key referenced
      by foreign keys in existing rows in other tables, all rows that contain those foreign keys are also deleted.
      This could be very dangerouse.

  2. Primary Key Wizard

    This Wizard can help to optimize SQL Server performance by analyzing the data in a table and recommending candidate columns for a Primary Key. It will generate a SQL script to add or change the Primary Key for the selected column. Details...

    Primary Key
    Figure: Select the table to add Primary Key

    Primary Key
    Figure: Pick the candidate column to create Primary Key How to choose an appropriate Primary Key?

    Primary Key
    Figure: Review the options for creating Primary Key

  3. Clustered Index Wizard

    This Wizard can help to optimize SQL Server performance by analyzing the data in a table and recommending candidate columns for a Clustered Index. It will generate a SQL script to add or change the Clustered Index for the selected column. Details...

    Clustered Index
    Figure: Select table to add Clustered Index

    Clustered Index
    Figure: Pick candidate columns to create Clustered Index More info about Clustered Index

    Clustered Index
    Figure: Review the options for creating Clustered Index

  4. Validate Foreign Key columns Wizard

    Many SQL Server database programmers use standard naming conventions such as ID in the column name to indicate a relationship with another table. i.e. ClientID. This wizard identifies columns ending with 'ID' which are missing FOREIGN KEY constraints and suggests relationships, where possible. Details...

    Foreign Key
    Figure: The Foreign Key Relationship Wizard

    Foreign Key
    Figure: Choose Foreign Key columns

    Relationships
    Figure: Choose script creation options More info...

  5. LastModified Column Wizard

    Every table should have a LastModified column to record the last modified time of each row, our script will add a trigger with the columns to record the time. Details...

    LastModifiedColumnWizard1
    Figure: Choose the tables that you want to add LastModified column

    This will add the column into your tables as well as create a trigger to update this column automatically.


  6. Timestamp Wizard

    The Timestamp Wizard will add Timestamp columns to any or all tables that do not have a Timestamp column. Details...

    Timestamp
    Figure: Choose the tables that you want to add Timestamp column