You can't really do this because the exec() statement essentially "shells" to another batch. The best way would be to build a table (perm or global temp ) and then...

In reading Pauls reply, I just thought of something. Has anyone tried to simulate clustering using instances? Or can anyone? Be curious to see if the "shared disk" can be...

Sorry for the late reply. Can you log into the server as the SQLAgent account and exucute them? Have you checked that none of the other packages have started running...

I agree with Brian with one addition. Identities can change so scope_indentity is a better choice.

Steve Jones

steve@dkranch.net

Is there a question here?

Steve Jones

steve@dkranch.net

Yes it is. Looking forward to a followup!

Steve Jones

steve@dkranch.net

I tend to agree with Robert. Personally, I'm at SP1 (ss2k) and SP2 (sql7). Luckily we have Brian here who does extensive beta testing and reports feedback here.

I install on...

Thanks Brian and interesting solution Antares.

Steve Jones

steve@dkranch.net

Ditto. I avoid double quotes as well. Stick with singles.

Steve Jones

steve@dkranch.net

You will need an Active X script or a Dynamic Properties Script that can alter the connection. Dynamic Properties is the easiest.

Steve Jones

steve@dkranch.net

I usually leave this one in as a precaution for forgetting or having the sa password changed. This way you can get back in.

Here he have an administrative poliy that...

That would be nice. It would also help us in scheduling articles for publication.

Steve Jones

steve@dkranch.net

Ditto. Have built a few, but not bought.

Sorry

Steve Jones

steve@dkranch.net

Remove access to msdb. Are these developers or normal users?

Steve Jones

steve@dkranch.net

You are confusing this info. The job is the definintion of a command that runs. What is runs is something separate and that could be deleted.

The job is encrypted so...