Overview

Setting a default workflow for all the folders within assets on a Portal can be accomplished using SQL.

Audience

Site administrators.

Click Site Settings in Persona Bar.
Copy portalID value from the Home Directory text field on the Site info tab.
Connect to DNN database using SQL Management Studio or using built-in Query Engine.
Run query
```
SELECT * FROM ContentWorkflows WHERE PortalID = ##PortalID
```
replacing ##PortalID value with an ID from the Site Settings.
Copy WorkFlowID value from the query output.
Run query
```
UPDATE Folders SET WorkflowID = ##WorkflowID WHERE PortalID = ##PortalID
```
replacing ##WorkflowID and ##PortalID values with the values you have copied above.
Run IIS Manager.
Click Application Pools.
Right-click on your application pool.
Click Recycle...

Confirmation: Verify that the default workflow has been successfully applied.