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...

No high availability,

Just change the new ip address, that s all.

Thanks jones for your reply.

Now i got the exact problem. This server have 24 production database, as per maintenance plan taking backup for all 24 databases, last day one database...

Hi,

We have got enough disk space in Drive.

Again i have re-build maintenance plan for bakup but i was not hope,

Re create new plan again same problem happend. 1 day...

i have tried, but not hope

SELECT a.*

FROM OPENROWSET('MSSQL OLE DB',

'DRIVER={SQL Server};SERVER=10.4.51.55;UID=energymeter;PWD=readhouse',

rais.dbo.energy_meter_house) AS a

ORDER BY a.emp_no, a.empname

plz tell me what is the problem?

thanks

Thanks for reply david.

Sql server 2000.

product version -8.00.2039

service pack - sp4

os- windows server 2003 enterprise edtion

thanks