MS SQL Express Static Port

Because SQL Express defaults to a dynamic port, opening the firewall can be a bit tricky. Typically, for PDM, it’s easiest to just set it to something static that can then be opened through the firewall. Instead of creating my own guide, here’s a link to a step by step guide by Javelin Technologies.

Read More

Upgrade to SQL 2014 SP3

For some reason, this is harder to find than it should be, so here’s a GoEngineer link as well as the actual link to the MS page. SOLIDWORKS PDM Upgrading SQL 2014 to Service Pack 3 | GoEngineer Download Microsoft® SQL Server® 2014 Service Pack 3 (SP3) from Official Microsoft Download Center

Read More

PDM Workflow Conditions in SQL

Result of SQL Query

It took me a while to find the tables that stored the workflow conditions of a vault. It kind of makes sense once found, though. They’re treated as transition conditions but to transitions that aren’t visible to users with a source state that isn’t visible. From what I can tell, that source state is StatusID…

Read More