Many thanks for your discussion with me!

I have got nearly the same problem as at the start of this threat. But now my understanding of the background details is much...

I don't know, if it is a good idea to assign all my users to SYSADMIN role? Isn't it the same bad idea like the sa stuff?

Is there a way...

Thanks a lot to all for helping me!

The easiest way I tried is to call a stored procedure from my client programm, which is calling sp_help_job with the fix parameter...

Do I need the whole cols returning by sp_help_job in the table structure, or only these I need?

Yes your are write, SELECT INTO isn't a good way!

I tried it with creating a temp table. No I've the problem, that sp_help_job needs some parameters to reduce the result...

Hi David,

think, your way is the right on. But how to solve the nested error?

Instead of creating a temporary table explicitly, could I use INSERT INTO?

Thanks a lot,

Thilo

Thank you AJ, but sadly I get a syntax error.

Isn't there any possibilty to work with result sets returning from stored procedures inside another stored procedure? In BOL I haven't...

The idea to create an alternate database is a nice and simple solution.

Thanx a lot,

Thilo