try public permission for the database and grant update on table

http://technet.microsoft.com/en-us/library/ms188371.aspx

one more thing are you doing it daily? and what timings? try online reindexing

I think you are missing something can u have the parameters printed in a textbox and see whether it is as per you requirement or not.

Query slowness is due to serveral reasons

poor Statistics or index or disk or network need to have run trace and identify .

for interview questions you have get through experience...

But why not they check OS Memory before accepting it?

We have only 2005 test server for us , so i tried on strange it is accepting the value.

OH great , i am out of mind , this didnt strike great thought

Grant already you informed that it is not the best solution, my question is what if agent is down.

we definetely need a service out of SQL to monitor these. hopw...

Take application development team help and alert in email.

what is that some calculation and is that log grows after this or during this ?

Why?

Is this running with SORT_IN_TEMPDB ON?

But then over a night the size jump up to 42...

mJai (8/26/2013)

---

Thanks Durai! My thoughts were like this:

- shutdown the db

- move the files from this disk/drive(X) to another temporary disk/drive(Z)

- perform whatever maintenance to this disk drive X such...

rajborntodare (8/26/2013)

---

Hi All

I am sorry, it has not been resolved,

Changing the account doesnt help any

The exact error msg was

WINDOWS COULDNOT START THE SQL SERVER AGENT (INSTANCE NAME) SERVICE ON...

restore the excryption key and check the reports.

Can i override...