If you ever wanted to implement single-item permissions for SQL table rows, you will notice that SQL Server itself does not provide a native solution for that. In contrast to e.g. the SharePoint list...
Make use of SQL Reporting Services (SSRS) for K2 blackpearl and include SmartObject data in your report.
Check an editable list view in K2 SmartForms for duplicates (and flag them).
Create K2 SmartObject from any SQL Database walkthrough.
If you want to import a list of all running process instances from K2 blackpearl into Excel (for analyzing the data, e.g. in PowerPivot), you need a data connection together with an SQL query.
When activating K2 Features and Configuration Settings in SharePoint Central Admin, you may get various error messages due to incorrect configuration. Some of them are described in this post.
The following SQL script sample forces K2 blackpearl to refresh all K2 identities in the identity table by changing the exiration date to now and setting the resolved status to “0”.
SET [ExpireOn] = GETDATE()
,[Resolved] = 0
,[ContainersResolved] = 0
,[ContainersExpireOn] = GETDATE()
,[MembersResolved] = 0
,[MembersExpireOn] = GETDATE()
The following SQL script sample queries for all identities in the K2 identity table and displays the resolved status.