Any idea that has received less than 2 kudos within 2 years after posting will be automatically declined.
Resolving an issue with calling MSSQL 2008 server side user stored_Procedures (or for that matter any other ADODB and user stored procedures) within Labview using the "LabVIEW DB Tools Create Parameterized Query VI."
This database toolkit vi will provide you the elements of a stored procedure provided you know the stored procedure name.
HOWEVER to get the list of stored procedure names for a db current requires user SQL coding and execution.
Could the functionality of the "LabVIEW DB Tools Create Parameterized Query VI." be extended to return the list (array) of the names of the held user stored_procedures..
See in code snippet
1. An example of the current method of getting list of user defined stored procedures
2. What I would like LabVIEW DB Tools Create Parameterized Query VI to provide is some command in (or set some flag) and return an array of user defined db stored_procedures names such as in the first code snippet from which I can then pragmatically select as input to code snippet 3
3. The current implementation by which the "LabVIEW DB Tools Create Parameterized Query VI." when given a stored procedure name returns a cluster of the parameter names and details of that stored procedure