Manage Email Signatures centrally from your Desktop - For All Users

toby.bell · Posted: Mon Dec 07, 2009 12:46 pm Post subject: Access -> SQL 2000

Hi,

We currently run eMailSignature version 5.0 (Will be upgrading to 7 soon)

I want to move the access database over to a SQL database, but we only have SQL 2000, and the script to create the new database here
http://www.emailsignature.eu/phpBB2/creating-ms-sql-2005-settings-db-executing-sql-statement-t927.html

Is for SQL 2005

Is there a script for SQL 2000 please?

Jesper Frier · Posted: Mon Dec 07, 2009 5:03 pm Post subject: SQL 2000 script

Hi Toby,

Please get SQL 2000 script here, and follow direction in this manual (p.11).
_________________
</Jesper> | Manage Email Signatures from your Desktop | Test Email Signature in All In-boxes | Email Signature Showcase

toby.bell · Posted: Mon Dec 07, 2009 5:24 pm Post subject:

Thanks,

I have followed the instructions, but when I ran the script against the database it doesn't seem to have created the tables that it then asks me to set permissions for.

You have posted a link to "emailsignature_upgrade_sql2000.sql" when I think I need "emailsignature_sql2000.sql"

the output from the query analyser is below!

Warning: The table 'Users' has been created but its maximum row size (15718) exceeds the maximum number of bytes per row (8060). INSERT or UPDATE of a row in this table will fail if the resulting row length exceeds 8060 bytes.

(1 row(s) affected)

Server: Msg 4902, Level 16, State 1, Line 2
Cannot alter table 'dbo.lgdaUsers' because this table does not exist in database 'eMailSignature'.
Server: Msg 4902, Level 16, State 1, Line 1
Cannot alter table 'dbo.lgdaUsers' because this table does not exist in database 'eMailSignature'.
Server: Msg 4902, Level 16, State 1, Line 1
Cannot alter table 'dbo.lgdaUsers' because this table does not exist in database 'eMailSignature'.
Server: Msg 4902, Level 16, State 1, Line 1
Cannot alter table 'dbo.lgdaUsers' because this table does not exist in database 'eMailSignature'.
Server: Msg 4902, Level 16, State 1, Line 1
Cannot alter table 'dbo.lgdaUsers' because this table does not exist in database 'eMailSignature'.
Server: Msg 4902, Level 16, State 1, Line 1
Cannot alter table 'dbo.lgdaUsers' because this table does not exist in database 'eMailSignature'.
Server: Msg 4902, Level 16, State 1, Line 1
Cannot alter table 'dbo.lgdaUsers' because this table does not exist in database 'eMailSignature'.
Server: Msg 4902, Level 16, State 1, Line 1
Cannot alter table 'dbo.lgdaUsers' because this table does not exist in database 'eMailSignature'.
Server: Msg 4902, Level 16, State 1, Line 1
Cannot alter table 'dbo.lgdaUsers' because this table does not exist in database 'eMailSignature'.
Server: Msg 4902, Level 16, State 1, Line 1
Cannot alter table 'dbo.lgdaUsers' because this table does not exist in database 'eMailSignature'.
Server: Msg 4902, Level 16, State 1, Line 1
Cannot alter table 'dbo.lgdaUsers' because this table does not exist in database 'eMailSignature'.
Server: Msg 4902, Level 16, State 1, Line 1
Cannot alter table 'dbo.lgdaUsers' because this table does not exist in database 'eMailSignature'.
Server: Msg 4902, Level 16, State 1, Line 1
Cannot alter table 'dbo.preview' because this table does not exist in database 'eMailSignature'.
Server: Msg 4902, Level 16, State 1, Line 1
Cannot alter table 'dbo.preview' because this table does not exist in database 'eMailSignature'.
Server: Msg 4902, Level 16, State 1, Line 1
Cannot alter table 'dbo.preview' because this table does not exist in database 'eMailSignature'.
Server: Msg 4902, Level 16, State 1, Line 1
Cannot alter table 'dbo.preview' because this table does not exist in database 'eMailSignature'.
Server: Msg 4902, Level 16, State 1, Line 1
Cannot alter table 'dbo.preview' because this table does not exist in database 'eMailSignature'.

Jesper Frier · Posted: Tue Dec 08, 2009 5:55 am Post subject:

Sorry ... my mistake ... Embarassed

This is the correct SQL 2000 script.
_________________
</Jesper> | Manage Email Signatures from your Desktop | Test Email Signature in All In-boxes | Email Signature Showcase