You can use the DTSRUN utility from a command prompt (to execute a command prompt in a proc, use xp_cmdshell in the master database).  To pass the UNC to the...

Awesome, this worked......thanks a lot for the help!!!

It is in the Master Database, so if you are trying to execute it from another database you must use the full path or you will get the error you...

use xp_stopmail & xp_startmail.......if you need more information about the two stored procedures, you can find info about them in the Books Online

Let me know if you have any trouble

actually that looks like exactly what I was wanting.  Thanks!

First of all, do not worry about this issue any more because we are not combining all servers information any more, we are breaking the query out, so I can use...

Yes, I agree.  I will post fixes from now on, this one was just hard to post because it showed how I overlooked the simplest solution.

Well the solution isn't very helpful.  Evidently the code in the application was changed to use another server for e-mail, so all I had to do was stop are start...

Sorry, about the problem, I have figured it out.

Thanks anyway,

Adam

A. Not sure if this is what you want for the model but, the replication is 14 articles (all tables are indexed, most are clustered indexes).  There are 17 subscribers.  Distributor...

Actually I did write it that way at first (thank you for the suggestion though), but I changed it temporarily to the one above because I thought it would be...

That did it, thanks for the help!!!