Thank you for reply.. Now i got clear idea about mail server.

I had created profile through control panel->

creatting email account as below.

1. User Info

user name - ananda

Email-address - ananda.murugesan@ril.com

2. server...

Thanks for your reply

It was woking fine through QA,

One more question?

How to create smtp mail account not in POP3? we are using only smtp.

I could tried but it was not...

Thanks for your reply

It was woking fine,

One more question?

How to create smtp mail account not in POP3? we are using only smtp.

I could tried but it was not hope.. the...

Have you check sql service account running either Local System account or user account?

Hi, Lempster thank you very much for your help....

This script CC copy was working fine.

Regards

Ananda.

Yes..

I got the result,

Insted of $msg.To.add($to)

i changed the script like

$msg.To.add(email1@test.com)

$msg.To.add(email2@test.com)

$msg.To.add(email3@test.com)

Thanks

Thanks for your valuable reply

Finally, this script was not working.

I got the errors below

PS D:\services> .\servicescheck1.ps1

Exception calling "Add" with "1" argument(s): "The parameter 'addresses' cannot be an empty string.

Parameter...

Hi , Thanks for reply...

I could try above script, but my server there is no .csv (MSoffice not installed) insted of csv file, i used txt file for emaillist. but...

Lempster Thanks for your reply ...

I achived for automate email alert when sql services stopped. but could not able send email mulitple emailid, i tried below script but failed.

plz can...

Thanks Tim for your reply....

how to identified When fully copied it deletes the fragmented one?

so we need to check dbcc showcoting command before rebuild index and after rebuild index then...

Thanks Gail for your valuable reply..........,..

vinay,

os: windows server 2003 enterprise edtion

I had reset values PerformanceSamplingInterval 30 insted of 14. under

MSSQLServer\SQLServerAgent\PerformanceSamplingInterval.

I thought it will reduced the more cpu usage.

Thanks so much Gail for your valuable reply....

I should correct my mistake....

Please check the following steps and times for maintenance plan.

1.Rebuild index every week sunday on 8:00 PM.

2. Update_statistices daily...

Thanks for your 's reply Steve & Gail..

I should be disabled Re-organaize index page from maintenance plan.

instead of that can i enable to remove unused space from datafiles.

1. shirnk...