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...

Just making sure everyone else is paying attention. Hopefully others will read this before trying the patch.

Steve Jones

steve@dkranch.net

It will if it connects to that server. If it connects to another server, you won't see anything.

Steve Jones

steve@dkranch.net

Haven't installed, and won't now. check with MS.

Steve Jones

steve@dkranch.net

The way that MS.com does it, or used to, was to write out XML files (flat) onto each web server. These are then transformed by the ASP into what you...

Dirk,

try logging into the server as the account under which SQLAgent runs and see if you can execute this.

Steve Jones

steve@dkranch.net

Is the pacakge on the same server as this is executing? That is the exact code I am using and I place the name of the package in a global...

Hold off if you can. If you feel you must apply the patch TEST IT ON A SECOND server.

Steve Jones

steve@dkranch.net

Brian and Antares are right. You can change the sort order at the db level and not affect other dbs.

CPU is more often, IMHO, what kills a server. If you...

Thanks for the followup

Steve Jones

steve@dkranch.net