Thanks Andrew.

I might have requirement changes but i will first try your example and let you know.

Thanks very much for your help and suggestion.

Regards,

Thanks, yo uare right.

It was issue with antivirus policy recently changed.

So after changing the antivirus policy to allow emails, it works.

Thanks, appreciate your help!

Thanks, We haven't install any anti virus as its a test server and i have tried to test on both test server but both having same issue.

Could you please...

Hi,

I sldo checked Log File Viewer for Database Mail log and it says:

The mail couldn't be sent to the recipients because of the mail server failure. (sending Mail using Account...

Thanks for looking into.

Sorry for rate reply as i lost this thread.

I think its on.

I ran you query and found following.

is_broker_enabled = 1

Thanks Dom for making correction but while running your following query, i got the following error:

datediff(hour,convert(datetime,left(start,23),126),convert(datetime,left(start,23),126))/24

Do you mean to use here Stop instead of Start, right?

(datetime,left(start,23),126))/24

So your query should read...

Thanks Bruce for your nice tips but i am not a SQL guru and if you don't mind can you provide me an example or function which can help me...

Thanks Dom.

you are right that it will be a problem later if we don't change it right now.

I am waiting to see what kind of different format i am getting...

Thank you, I will ru nthis query and let you know.

Thanks much Andrew.

Please see the below resposne and my question.

What are the different date/time formats you've already got in your table?

==>We haven't not any idea as we are on...

Thanks much Andrew for oyur quick resposne.

I am not much SQL expert, could you please show me how to use in my query below?

Start and Stop is my actual date...

I just got the information that each table will grow atleast 100k -200k rows in next year.

Is it this information is enough to estimate DB configuration?

And also we will have...

Thanks lot.

If someone have any standard production setting, i need just to check it out.

David,

I am completely agreed with your thoguhts and really appreciate your response.

I will try to make sure with some testing data but i was just trying to foind out what...

Thanks much!

I know that its not real amount of data but could you please let me know what should be the ideal configuration?

I know oracle has small/medium DB size parameters...