Workflow Soluiton

Can anyone explain how to setup SQL-based state data persistence? On the initial install I chose 'File-Based' but then thought better of it after the fact when I realized it would be so much better to keep everything in SQL. I did re-install with the "SQL" option selected but am not sure everything is setup correctly.

I tried to follow through in the Workflow Solution Admin guide on pages 17-18 for "Storing data in the SQL server database" and got to step 5 where it states to install WorkQueue.SQL and WorkStatus.SQL. I couldn't find these scripts anywhere. Does anyone know where these are located or have them available? We have Workflow 6.5 Basic.

Thanks for any help

When you select setup your db using the dbtool.exe it runs the scripts.  If it has an issue, it will tell you and it will tell you where the scripts are located.  To verify that you have got it setup correctly, go into the configuation and loggin tool.  Check out the exchange configuration tab.  Click on LBQ_Local_Defaults (on the left top).  On the right at the bottom you should see LogicBase.Core.Messaging.SQLExchange.   You can always run a test workflow and check your messages table to see if stuff goes in it.
Hope that helps.