Hi,

The output file in the SQL Agent works for me too.

However, I want to run the stored proc from an SSIS package and write all the outputs (PRINT and SELECT...

Thank you! It worked for me after I set package protection level to "Rely on server storage and roles for access control".

--Irina

Hi - did you find from where it's running? I'm having the problem. Any clue will help.

Thanks,

Irina

I had the similar problem.

I granted SELECT permission to database objects to a group. The users could query the tables, however, they couldn't see the table lists when they...

Thanks for your prompt response! How do you remove/add a node from/to possible owner list?

Hello,

I'm planning apply SP3 in SQl server 2008 cluster environment. Did you get answer to your question? Do i really need to take the other node off from the possible...