Working with Database

Owned by Nate Edwards
Jul 31, 2017
1 min read

USERS>MANAGE

    • Lists current users and lets you add new users.

DATABASE>RUN SQL SCRIPT

    • Use this feature to select a file containing SQL statements to execute.

DATABASE>ATTACH

    • Attaches the ESHA database to the current SQL server.

DATABASE>DETACH

    • Detaches the ESHA database from the current SQL server.

DATABASE>SHRINK

    • Removes unused database records and log files that may have increased over time. Instead of merely marking a space as available, shrinking removes dead space and compacts the database.