This article was created in response to a support issue logged with K2. The content may include typographical errors and may be revised at any time without notice This article is not considered official documentation for K2 software and is provided “as is” with no warranties.
There are no properties are listed under a SQL Stored Procedure ServiceObject.
The stored procedure references a table from a different SQL server instance. On Different SQL Server and Use Native SQL Execution are both set to true on the SQL Service Instance.
If On Different SQL Server and Use Native SQL Execution are set to true, the sp_addlinkedserver must be executed by the K2 service account. Kindly refer to the documentation for more details.