See, My question is why SQL Server is using 21 GB of memory? Server looks fine .. but , memory consumption is too high.

Tell me : How can...

Due to that ,, I got the avg. page lock/ avg. object lock is more than 95 % ... last few days.

Will it work :

sp_configure 'max server memory',15360;...

Thank you !!!

Also the job is running continuously. and in job history it is saying that 'Starting agent' where as it should be' 'Waiting 60 second(s) before polling for further changes.''.

Thanks...

I got this message in Database mail log

Message

The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2011-09-07T12:30:14). Exception Message:...

Again I added an extra zero that is "1000000000"

Still I am getting the error:

But it is different error.

Message

Executed as user: LHOCR\sqlssadmin. Mail not queued. Database Mail is stopped. Use...

I have added one extra zero to that. not through T-SQL

and I don't know what is the attachment size.

That was a error message. that has not mentioned about the...

I have changed default parameters By Clicking on Database Mail -> Select Configure DB Mail -> Next -> Select the radio button "View or Change System Parameters".

Still it is having...

Create a maintenance plan for your Weekly backup, and set clear backup file more than 30 days .

OKAY, But how.... Can you please describe briefly? I will be thankful to you.

Thanks,,

I used SSIS ,,

It is working fine.

so, now I have to use SSIS package ? or you can suggest something....

generated script is not executing in express edition .. also copy database not working.

Any other option .. Like, Using SSMS.. or T-Sql

Run the following syntax and ckeck:

SELECT *

FROM

sysmessages

WHERE error = 50000