Manage Email Signatures Centrally - For All Users

Bjarne Mess

Scenario:
You have set up eMailSignature by using the Cockpit and everything looks great. You now want to move your settings to the SQL Server for deployment.

You can use the tool BuildInsert.exe to create the insert scrip for SQL server automatically.
You find the file here.
It requires you to be running .NET version 2 or higher.

This will automatically create the insert script for you based on all the information you already have set up in the Access database.

Now open Enterprise Manager and create the database as described in the support page. Open Query Analyser and do the following:

1. create script downloaded from the support pages in the download section.
2. run the newly created file (also called create.sql) after you created all the tables.

You might run into two problems:
1. [Microsoft][ODBC SQL Server Driver]COUNT field incorrect or syntax error.
Solution: Delete all entries to the lgdaUsers table

2. Server: Msg 544, Level 16, State 1, Line 1
Cannot insert explicit value for identity column in table 'preview' when IDENTITY_INSERT is set to OFF.
Solution: Locate "INSERT INTO [preview]..." and replace it with:

SET IDENTITY_INSERT preview ON
INSERT INTO [preview]
SET IDENTITY_INSERT preview OFF

You can now successfully connect the Cockpit to the SQL Server and continue your deployment. 8)
_________________
</Bjarne> | Test Email Signature | Showcase |