MailSite Knowledge Base

Enter text to search for or enter the document ID number.
Search:   
Doc ID:   

Refreshing/Updating SQL Tables and Stored Procedures
Document #:10097

Applies To:
  • MailSite All

Synopsis:
When upgrading MailSite customers who run MailSite in the SQL Connector must manually update the stored procedures and tables. This can be done via the MailSite Console or via SQL Server.

More Information:

After the upgrade has been completed, the Configuration Connector wizard should again be run (double click on SQL Connector). When the option to refresh the stored procedures and tables appears, tick the boxes “Refresh the stored procedures” and “Refresh the tables”. This will ensure the latest information is now stored in the MailSite database.

To update via SQL Server, load Query Analyzer:

  • Select the database you are using for MailSite
  • Load the file tables.sql
  • Run this file
  • Load the file procedures.sql
  • Run this file
  • Quit Query Analyzer and restart the MailSite services.

Note: It is not necessary to run dcconversion.sql.

Related:
See these other knowledge base documents:
Last revised 2008-7-1
 
 

MailSite SE - Easy email and calendar server software for small businesses | MailSite ExpressPro - AJAX email and calendar client for web browsers
MailSite Fusion SP - Scalable and clustered email and calendar hosting software | Email Server and Calendar Server Software
MailSite ActiveSync Server Software | MailSite Calendar Server Software | MailSite Anti-Virus | Mailsite Anti-Spam | Customer Portal
Support | Webstore | Services | Partners | Press | Company | Contact | Reviews | Site Map | Privacy | ©2008 MailSite, Inc.