index > Windows Workflow Foundation > SQL Server Express - Problems Setting This Up

SQL Server Express - Problems Setting This Up

Hello Everyone,

I'm using the July CTP of WF and I'm trying to set up SQL Server Express for persistence. I've created a new empty database called Database1.mdf.

I've found the script C:\WINDOWS\Microsoft.NET\Framework\v3.0\Windows Workflow Foundation\SQL\EN\SqlPersistenceService_Schema.sql and I've copied it's contents into a new query for Database1.mdf. Unfortunately when I try to execute the query I get this error message...

"Query Definitions Differ" "The following errors were encountered while parsing the contents of the SQL pane:" "The Set SQL construct statement is not supported."

Does anyone out there know what's going on? All I want to do is persist my executing workflows in a SQL Server Express database...




0xDEADBEEF
0xDEADBEEF

Hello!

I just tried running those scripts on SQL Express and I am not getting any errors.

Try opening file instead of copying content into the query window.

Also - what tools are you using to manage your SQL Express databases?

Iza




Iza
Iza
reply 2

You can use google to search for other answers

 

More Articles

• Queues
• Workflow Monitor Sample
• Decision tables in Excel
• Order of events during persisting
• ASP.Net state machine not performing state transitions
• What happens to System.Collections.Specialied.StringDictionary?
• How to host the WWF design control in an ASP.NET page?
• Installing WWF in WinXP problem
• How to add a CorrelationReference
• Updating Workflow
Bookmark and Share
Welcome to Bokebb   New Update  
 

New Articles

• Confused on why is is possible to drop a
• Custom Activity Events Question
• EventQueueName question
• Workflow Designer
• Hide compensation tab
• Delay Activity and ASP.NET
• This workflow,how can I present it using
• using correlation token to decide which
• workflow project type
• Loading Workflows from assemblies: FileL
• How to add some new properties or new pa
• DataExchangeService Attribute in Beta 2.2
• Will there be a WF official release with
• Passing parameters into the workflow.
• Custom loop with multiple activities

Hot Articles

• How do you serialize WorkflowCompletedEv
• workflow project type
• How reliable is GoLive License of WIndow
• Approachses for assignments
• Parameters
• Custom SqlPersistenceService
• remove connector
• CreateWorkflow and WorkflowMarkupSeriali
• Problem running my first workflow enable
• InvokeWorkflow doesn't seem to run the i
• synchronizing with workflow thread
• Binding in XOML only workflows?
• data type for data and time property
• Feature Request: Display activity descri
• Pause a workflow

Recommend Articles

• WorkflowXSDGenerator Issues?
• !!Custom Sequential activity never chang
• How to check if a workflowruntime has be
• WWF Beta 2 - Compiler Error 347 - Cannot
• Application on Client - Workflow on Server
• Error debugging a workflow
• Dehydrate/Rehydrate WorkFlow
• Designer re-hosting and XAML only workfl
• XPDL
• Multiple clients interacting with a work
• data type for data and time property
• WWF Performance
• WorkflowCompleted event fires twice.
• WWF and ASP.Net
• Creating ActivityExecutionContext