Jim,

The answer is Yes to your questions 1-3. When I used xp_sendmail,I got the following message:

SQL Mail session started.

Server: Msg 18025, Level 16, State 1, Line 0

xp_sendmail: failed with mail...

I used a local admin account to run that bat file, which is sa by default. Also, since I don't have SMS, so I took the -SMS off command line.

Thanks...

Yes. I logged in as the same account. When I sent a test message in SQLagentmail, it didn't go out until I stopped SQLagent service.

Thanks

Is it for MSDE or not? cause I need to install SP3a on SQL server?

I bascily tried the command from MS without luck.

start /wait x86\setup\setupsql.exe -s -m -f1 "sql2kdef.iss"

I believe Allen's article is something I am looking for. I will try it out and then let you know how it works.

Thanks you both again for your time and...

The error message didn't give that information, just simply said it failed. Yes. I used the Wizard to create those jobs. You mean if I tranfer the Plan ID as...

Here is what I did: 1. I craeted db backups, integrity checks and optimizations for system dbs. 2. Genegrated the script for these jobs. 3. Ran that script on the...

I have found a solution for it. After the slient installation, you need to modify the licensing mode in registry to support per processor.

Thanks again for your time.

Thanks for your advice, Gary!

I will try it!

Thanks.

Looks like I can use sp_addarticle.

Chris,

The error message basically said that missing some SPs. We installed a SQL server on the another box with the same name and configuration, and then copied that two msdb...

quote:

---

Thank you, bar8393. I will add this to my archives.

quote:

---

here's the one I...

Andy,

I installed MDAC 2.7 on my PC, but still got the same error. Is there anything elso I can try?

Thanks

John

Andy,

Here are my concerns: The log shipping is not real time; and SQL replication will make the configurion and backup/restore very difficult when replicating lots databases on the same box.It's...