Thanks for your reply. How do I know if i need to do that update?and will that cause any problem for end user. Is there any online feature for full-text...

How can this help for troubleshooting?

Here is another thing that I have to add access to that table is happening through stored procedure called

SP1. This sp is being called by User1, but in sp...

I agree with, but I can not change that piece of code.

I also tried and made the User2 as a sysadmin and still I received that permission denied error...

Hi ,I have similer problem,Could you solve it?

In sysmail_faileditems I didn't see any failure.I ran DatabaseMail.exe manullly,because I didn't see any

"DatabaseMail process is started" & "DatabaseMail process is shutting down" events in msdb.dbo.sysmail_log table.Even when I...

Sorry ,I guess I have missed something.What is OPC three script?

When I tried to run the DatabaseMail.exe manually in Windows event log I face with the following error message:

Exception Type: Microsoft.SqlServer.Management.SqlIMail.Server.Common.BaseException

Message: There was an error on the connection. Reason:...

I created Account and Profile from the scratch and when I run the following query:

SELECT items.subject,

items.last_mod_date

,l.description FROM dbo.sysmail_faileditems as items

INNER JOIN dbo.sysmail_event_log...

For some reason it seems External program (DatabaseMail.exe) does not been run at all.And when I tried to manually run DatabaseMail.exe, nothing happened.

In sysmail_sentitems,there is not any record.

In sysmail_unsentitems,In includes all the test emails I have tried

In sysmail_event_log does not show that DatabaseMail process has been started to stopped at all.

The...

Thanks for the reply.

I have already removed all profile and accounts under the profile and recreate it ,but still have the same issue.

Also when I checked msdb.dbo.sysmail_event_log tables,I could not find the following events.

DatabaseMail process is started

Databasemail is shuttingdown

It seems databasemail doesnot restart automatically ,when there is message in Message...

We have 10 severes and on each server,we have 2-3 databases.We log ship all of these databases from all servers to one centralized place,so the Developers can run their ad-hoc...

It's SAN bases disk(mount point)