Refreshing/Updating SQL Tables and Stored Procedures When upgrading, customers that 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.

This can be done either piror to the upgrade directly in SQL server by your DBA or after the new version of MailSite has been installed. 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 (This must be done first)
• 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.

The tables.sql and procedures.sql can be found within the MailSite installation folder, or on the MailSite download page.