I'd like to set up a scheduled task to run ANALYZE on a regular basis.
I have no problems setting up a batch file to do this. My challenge is
that our VSS DBs are on a detached storage location, and not a
dedicated box. So, when ANALYZE starts, it challenges with a 'do you
want to run this over the network?' message.

I can click 'yes' and it runs just fine. Obviously, this is not an
acceptable solution for an automated process. Anyone have any
experience with trying to do this or have any suggestions?

Thanks in advance,

Ryan