Voiceguide Sql Script On Sql Server 2014

[Frank.Schwarz]

Hello VoiceGuide Team,

i'm testing the new VoiceGuide Installation and i want to create a MS SQL Server Database but when i execute the sqlfile DB_create.SQL i get an error.

 

Can you please send me an sqlscript which runs on SQL Server 2014.

 

Thanks!!!

 

The Error on German:

Meldung 1919, Ebene 16, Status 1, Zeile 25

Die ContactNumber-Spalte in der calltrack-Tabelle weist einen Datentyp auf, der nicht für eine Schlüsselspalte in einem Index verwendet werden kann.

 

[SupportTeam]

Please remove these lines from Db_Create.sql

CREATE INDEX IdxCtContactNumber ON calltrack (ContactNumber);
CREATE INDEX IdxCtContactName ON calltrack (ContactName);
CREATE INDEX IdxCtCampaignName ON calltrack (CampaignName);
CREATE INDEX IdxCtOutcome ON calltrack (Outcome);

then remove all tables from the database object and try running the Db_Create.sql contents again.