Speaking with a few people recently, there came about the question of knowing what Nintex Workflows were running at a particular point in time, or still running for that matter. To the bat-cave Robin!!! I mean, to SQL Management Studio. Tinkering around with the Nintex Workflow database, I whipped up a SQL query that I […]
You may have encountered some “Workflow Infrastructure” messages in your SharePoint logs that state : “Declarative workflows cannot automatically start if the triggering action was performed by System Account”. There are two possibilities for this that come to mind. You are logged in as a System Account and you caused an event that would normally […]
Start of the Story Querying a database is something I do quite regularly. Whether it’s for work at Nintex or other projects. Sometimes this is just from using SQL Management Studio, othertimes, it is for something more complex and requires some code to be written that makes SQL queries and does something on the data. […]
While designing a database using MSSQL, I inadvertantly left some fields using the default NChar data type. The downside to using this data type, is that you specify the max number of characters for that field and when you put text into it, it pads it with spaces. This means more data coming back with […]