thanks,

But I got no records. There are acutally 50 records in the table for today.

The whole query is like below:

SELECT ParentUsername, ParentPassword,...

Find the problem.

The vendor told me to change connection string in the app.config, but there is another config file Myapp.exe.config not changed, by changing it , it works.

Thanks for all...

Thanks.

I do replace the servername, username etc to ours, in my previous post, I just don't want to expose our private information there.

ON the web server, there is no SSMS...

I would like to update this. Our network guy said he created something called Connector. Then Let me give it a try. First it didn't work, then Later he asked...

Thank you. I give it a try.

And I will also see what our network engineer can do.

Thanks. Currently I have not sent any jobs from sql agent yet.

Just set it up and test it by using sending test email by right click on database mail

No, he added my pc's IP to the relay list, still I had the same error message, also I tried using anonymous authentication, I got the same error.

I'm testing...

I got the same error after using anonymous authentication

I just nwo went to our exchange admin guy, he said he needs to add the computer that I send the email...

I went through the steps to setup the database mail.

On the account managing existing account screen, I setup like below:

Accountname: databasemail

Outgoing mailserver:

Emailaddress: myntemailaddress@mydomain.com

Display name: SQL Alert

Reply Email: myntemailaddress@mydomain.com

Servername: ourExchangeServername.domain.org

SMTP...

Thank you, that's exactly what I want.

Thanks, George.

That's good to know.

Thank you!

Thanks, what does set quoted_identifier off mean?

Is this just a setting for the sql statement or is it turn off for all future sql statements.

Do I need to turn it...

Thank you! That's what I think too.

I asked this question is because a new network guy keeping telling me their previous company does this way, although I wonder if he...

Thanks,

So back to my question any step-by-step articles or white page about restore system dbs?

Is this a common task for DBAs?

Thanks