Hello,

I'm still encountering some problems with DB Mail on my Windows 7 machine. Below are the error messages

The mail could not be sent to the recipients because of the mail...

Considering sysmail_event_log the description is as follows

DatabaseMail process is started

1) Exception Information =================== Exception Type: System.NullReferenceException Message: Object reference not set to an...

The description is NULL

No

No

Thank you very much for your assistance.

I ended up using CLR for the two functions.

Use this instead. The key should be 8 characters in length

Private Sub btnTestEncryption_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnTestEncryption.Click

Dim...

Here, the VB.NET Code

Imports System.Security.Cryptography

Imports System.IO

Imports System.Text

Class EncryptDecrypt

Public Shared key As Byte()

Public Shared IV As Byte() = New Byte(7) {&H12, &H34, &H56,...

Thanks, you've really been helpfull. This time I can not script another table from another database. It give the message -"Table object [dbo].[CASE_CONFIRM] does not exist in Database [master]". I...

I tried the code and I got the following errors

Server: Msg 8101, Level 16, State 1, Procedure sp_GetDDL2, Line 78

An explicit value for the identity column in table '#Results'...

Thanks, the code works but it truncates the result of must of my tables. Is there anything you can do?

Thanks for the code anyway, But I still need a favour.

The SQL code you gave me has the following errors in Sql Server 2000. They include

Server: Msg 170, Level...