VoiceGuide IVR Software Main Page
Jump to content

Voiceguide Sql Script On Sql Server 2014

Recommended Posts

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.

 

Share this post


Link to post

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.

Share this post


Link to post

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×