Hi,

Is this: http://www.databasejournal.com/features/mssql/article.php/3626056

what you are referring to? I am using sql server 2000. Thus I don't have this feature. Plus I saw the configuration for db_mail, it has...

Hi.

Thanks for your effort in trying to help me. But the link you gave me seems a little irrelevant. I am using sql server's trigger to send email. So... I...

Hi,

Thanks for your reply. 🙂

Yup. The smtp server is provided for us to send smtp mails. But they require us to have: external server's IP address, the sender's IP Address...

Hi,

Nope. Because I am only given the IP address of the external SMTP server. Maybe to make myself clearer, I'll explain the process that I need to see happening:

When a...

Hi,

I am also having a problem regarding smtp_sendmail. I am using trigger to send mails to inform administrator of a new record added into database. However, I only managed...

I understand that Public only has "Execute" and "Select".

But these are object permissions.

I am looking for a way to display statement permissions which are the following:

Create Table

Create View

Create Procedure

Create Default

Create...