Hi Gail,

Sorry. It is 234KB. I typed wrongly.

Ok. But can you explain me why the avg_percent_in_fragmentation is not getting reduced for this scenario. For the same column if I create a clustered index in stead of non...

Hi All ,

sorry for the late reply. Actually the table is very small it has only 399 rows and size is 234MB. Previously it was a heap table. Just for...

The Job should run in node B.

Thanks for the reply.

So can I come to conclusion that if I change the time settings in windows, the same will be reflected in the SQL database. There is no...

Thank you very much.

Thank you for the information.

As you said that if I have 8 processor and I have 8 tempdb datafiles, then each processor will use one file. I just want to...

Please let us know if anybody is aware of this particular problem.

thanks for the reply.

So I can take the transaction log backup with the option truncate and shrink the log file after that. Can I shrink the file to the minimum...

So any idea why the error is happening? I checked with the SMTP messaging team that no mails received from the SQL server.

Hi,

I tried with the above solution but not getting the solution. Can you tell if any IIS setting is required or entry required in SMTP server to send mail?

I am able to send the message from that server through telnet command by SMTP server.

With the same smtp server I am able to send mail from another server. I...

Hi,

I have created SMTP priflle with valid data but still I am facing the same problem. Is there any software or settings in IIS or some other things are required?

Hi,

I ran telnet session from that server and I am able to deliver the message through command prompt. I think the error I am getting which is "command not implemented"...

Hi,

Through SMTP command I am able to send message from that server. But not through database mail. Anything to check? Is it due to the access problem?