How to Run Stored Procedures from Teststand

[Matthew Davison]

I am trying to get teststand to run an SQL stored procedure but I always get the following error

Error executing substep 'Post'.
The following SQL command failed: 'EXECUTE cdt_st_test...'
Native error code -2147217900 0x80040e14
Microsoft OLE DB Provider for SQL Server:
Syntax error or access violation

It is a test stored procedure that doesn't pass any parameters.

Which steps must I use and how do I pass parameters.

[Matthew Davison]

I have sussed it now. I was setting the "Command Type" to stored procedure instead of default. I changed it back and did "EXECUTE cdt_st_test" and it works. I have also added the parameters there as well.

[NI_jc]

What do you mean when you referred to the 'Command Type'?