I'm using the default Sql Workflow Persistence Service to manage workflow persistence in an application I'm developing. I used the scripts provided by Microsoft to generate the schema and logic in a SQL database. Up until now, it's worked great; however, I'd like to change the names of both the tables and stored procedures to comply with a naming convention of my choosing.
For example, the script provided by Microsoft generated a stored procedure named RetrieveNonblockingInstanceStateIds and I'd like to change it's name to wf_RetrieveNonblockingInstanceStateIds.
You could probably create your own persistence service, but personally I'd leave it well alone as it is.