I desided to create batch file createWorkflowTrackingDB.bat to create
Database:
@echo Change name of Database server if required
@echo press control-Z to stop batch
@pause
sqlcmd -S localhost -E -Q "create database WorkflowTracking"
c:
cd "C:\WINDOWS\Microsoft.NET\Framework\v3.0\Windows Workflow Foundation\SQL\EN"
sqlcmd -S localhost -E -d WorkflowTracking -i Tracking_Schema.sql
sqlcmd -S localhost -E -d WorkflowTracking -i Tracking_Logic.sql
@echo Ensure that application account has tracking_reader and tracking_writer roles
But it was failing on the line
sqlcmd -S localhost -E -Q "create database WorkflowTracking".
It took me a while to recognize, that MS Word replaced double-quotes with smart-quotes , and sqlcmd didn't like it.
posted @ Wednesday, January 14, 2009 8:59 AM