script working fine and get current database size..

but below filed data are not comming.. what could be issues?

Last_day_data_size

Per_day_Increment

Per_month_Increment

Thanks

ananda

1. Reorganize index

2. Rebuild index

Can we create both operation in one single jobs via Mintenance plan?

issuse is user not able to DML operation via application during Rebuilding and Reorganize index.

I have doubt, i am not checked Index keep online in maintenance plan wizard? that is...

state_desc is ONLINE..

not for all database.. only user database

Rebuild and Reorganize job took 40 min that time user not able to insert data thru application.. once completed job application...

GRANT EXECUTE ON [xp_sysmail_format_query] to [service account]

I have done permission of SQL Agent service account.. again same issues,

what could be worng above script.. Temp Table #Result rows not display...

Im also facing same problem, SQL server does not allowed for login any user.. also DAC connection is not working even enabled... so I have daily backup of master database...Just...

Ok.. understand.. Thanks for reply

1. High performance mode - there is some data loss due to ackownledgement not received to Principal server from secondary server ..( so how to resolve...

Is it any data loss after firing as below command? pl. confirm

Use master

Go

ALTER DATABASE <Databasename> SET PARTNER FORCE_SERVICE_ALLOW_DATA_LOSS

Thanks

ananda

Thanks for reply.. I have changed the script for email notification as below and sending email number of records not to be zero

select MACHINE, COUNT(*) as Instance

into #tableA

from PROD.dbo.CM_INSTANCE...

Email notifications working fine and there is no issues..also without if condition that script is working and received email alert from database..

I received lot of mail wheather rows selected or...

Email not received from database even rows available as below query.. could suggestion me, what could be worng as below coding..I want receive email when rows available if no rows...

Ok. understand...

I changed EXISTS instead of NOT EXISTS..Mail not received because no rows selected that Query currently..

I have configured in SQL Jobs and run it every 5 mints then...

Thanks for reply..

I want send email the same query result.. But I don't want send mail if Diff value=0

could anyone suggestion me as below coding condition matching or not? if diff value = 0

if NOT EXISTS (Select A.MACHINE, A.Instance, B.InstanceA,

(B.InstanceA-A.Instance) as Diff from (select MACHINE, COUNT(*)

...

The below code working fine... I want send mail when difference data apperaing.. output like below, if Difference data = 0 don't want send mail.

Machine-CM6

Instance -23

InstanceA -19

Diff -4

EXEC...