I tried to add SqlWorkflowPersistenceService with a valid connection string
(an existing DB) , but once i create an istance of workFlow i got an exception with
could not find stored procedure RetrieveNonBlockingInstanceStatsId.
is there any process for creating those tables and stored procedure
Thanks Amit
What do i have to do in order to use SqlWorkflowPersistenceService
Gravy
Hi Amit,
Follow the steps below to create tables and stored procedures for sqlpersistenceservice.
To create and configure the SQL database
Using Microsoft SQL Server 2005 Express, Microsoft SQL Server 2000 or later or Microsoft SQL Server 2000 Desktop Engine (MSDE), create a new database named SqlPersistenceService using the SQL query statement:
In the SQL Server Query Analyzer workspace, select the database created in step 1 from the drop-down list of available databases.
On the File menu, click Open and open the SQL script %WINDIR%\WinFX\v3.0\Windows Workflow Foundation\SQL\<language>\SqlPersistenceService_Schema.
Execute the query by clicking Execute or by pressing F5 to create the SQL Persistence Service tables.
On the File menu, click Open and open the SQL script %WINDIR%\WinFX\v3.0\Windows Workflow Foundation\SQL\<language>\SqlPersistenceService_Logic.
Execute the query by clicking Execute or by pressing F5 to create the SQL Persistence Service stored procedures.
Hope this will help you.
Karthick.
Blast
Thanks alot ,
it helped me , now it is working .
Thanks Amit
Prodigal Son
FYI - With the June CTP the path to these files has changed to:
%WINDIR%\Microsoft.NET\Framework\v3.0\Windows Workflow Foundation\SQL\EN\
Just ran into this and thought I would pass it along...
--
Bryant