Thank you Adi,

I appreciate your help. I will look into my code and change as per your code.

In case of error, i will contact you.

Thanks for help.

Aadhar.

Actually i need to update DateUpdated column whenever i will make changes in row but there is no primary key in table

and DateCreated column whenever any insertion will occure

Error:The row...

Thats not the issue,

The issue is in trigger update statment..

No i haven not updated stats..

May b i'll have to check that..

I tried but it produces less rows..

This is what u are telling same thing.

If i split query and i take sub data and group it or i take temp table to store partial data and use...

large table has 20000000 rows and all group by are required

By ommiting single group by will raise me to an error..

Please find attachment

Thanks,

Aadhar

I'm using sql server 2008 r2.

I will check possible solutions as u mentioned tip..

anything that would help me more, please suggest..

Thanks GilaMonster,

Actually i need to create trigger through which i can track every change happen in sys.configurations so later on i should know what value has changed of what attribute..

I...

Or there could be a better solution..

Suppose let u think for a situation where value change can happen once in a month,

If i go with job, i need to give time that executes job, the minimal...

Thanks Bhuvnesh,

But i am looking for solution which can operate through trigger..:(

Thanks,

Thank you Ali,

But i have little confusion to create job and execute on every minute(Probably because we need to check values every moment) so it creates load on server to...

To

Adi Cohn-120898

Thanks for text.. i agree and conclude it should handle from gui side as it is not advisable to change all logins by different language.