I have a job which executes a Stored procedure which in turn executes a series a stored procedures. Now I've executed this main stored procedure through the query analyzer and it executes correctly , but when i try to execute it through a job i get error The cursor is not open. [SQLSTATE 42000] (Error 16917) .
Anybody have a clue what could be wrong?
Anybody have a clue what could be wrong?