In rare circumstances, the foreign key indexes in your database may no longer exist. This can happen when moving a database to another server, restoring from a backup, or by modifying the database directly. Database administrators can determine if this has occurred by looking at the tables, especially if they notice slightly less than average performance in the management and portal interfaces.
To re-add the foreign key indexes, run the following script:
NOTE: This script only works with SQL Server. It will not work with MySQL.
Learn more about SmarterTrack’s live chat, self service portal and knowledge base software.
Trouble logging in? Simply enter your email address OR username in order to reset your password.
For faster and more reliable delivery, add noreply@smartertools.com to your trusted senders list in your email software.
A code was sent to the recovery email address. Please provide the 6-digit code.
A code can be retrieved from your authenticator app. Please provide the 6-digit code.
An email was sent to your recovery email address. If you need further assistance, please contact your system admin.