Are you asking us a question?

Or do you want script?

or Doyou looking for any other suggestion?

Nita

Thanks,

My manager says developer needs to so just get it for them 😉

I had this issue long time ago, after rebotting the server it did worked may be the password is cashed or whatever may be the reason.

I am almost there but how do I know which is which etc?

Anyhow thanks Chris

Nita

Ask you windows team to authenticate the password with SQL Agent password.

if needed stop and re-start the SQL Agent and then do again xp_stopmail and xp_statmail

Is there any system table which keep all this information for Publisher and Distributor

Like who is the distributor and there subscriber and vise-versa?

Nita

use

exec xp_stopmail

and then

exec xp_startmail

Yup that's work

thanks

🙂

This Script don't tell me weather auto-grow is selected or not?

Can you or anyone please help me to find the script which generate to find the auto-grow is selected or...

Thanks

Nita

Thanks Everyone

I have 50 DB and its on 2000, also how can I get my database configuration setting.

Nita

Thanks, I got it 😛

Nita

Publisher has SQL 2000

In User database were it has created and look under User defined function

Nita