How To Restore Callque Table - Please Help!

[allstatesmed]

I mistakenly entered the SQL command "drop table callque" on the Outbound Call Loader instead of "delete * from callque"

Now I can't load calls with an XML file since I get this error:

Error 572 (Provider v. 3.4.1.69): Table doesn't exist: callque

 

How can I get this table back?

I would appreciate a quick response.

[SupportTeam]

If you are using VoiceGudie v7 have a look in VG's \System\setup\ subdirectory.

 

See the file Db_Create_System.Data.SQLite.sql or the one specific to the database engine that you have selected to use.

 

In that file you will find the SQL expressions that are used to create the various tables.

 

Otherwise you can try stopping VG, deleting the file vgDB in the VG's \data\ subdirectory and then re-installing VoiceGuide (don't delete anything else). The existing Config files will be retained if VG is installed over the top of current install.

[allstatesmed]

Thank you for the quick reply.

The Outbound Call Loader will only accept one line of code at a time so obviously I can't create all of these tables here.

What is the best way to recreate them? I have MSSQL 2005 on this machine if that helps.

[allstatesmed]

Nevermind,

I stopped the service, deleted the vGdb database, restarted, and everything is good now.

 

Thanks for the reply.