Yeah...I already confirmed the creation of the table....even tried to delete it....which is where the error came from...

When I ran the create table script is created the table just fine.  But when I ran the second script that creates the trigger and then "INSERT INTO dbo.AudtitLog(Command,PostTime,HostName,LoginName)" runs....because...

The only trick I found was that the account must be an active public email account and you have to restart the SQL Server Agent once you have DB mail...

Excellant! Thank you!  Now to learn how to create DDL triggers

I'll check out that link.

Thank you Euan. 

Thank you Joseph.  Appreciate the input!

I do as well.  I'd love to see that service pack out soon.

Not sure how you did it Jim...but still doesnt work for us.  64bit Database Mail still fails to initialize and sessions wont start for us. Even after a restart of...

You're kidding?  Thats awesome!  I've been thinking of revisiting the issue and trying to figure it out myself but this is good to hear....I had a tough time with it...

Excellant

Wow Excellant....exactly what I was looking for. A nice simple layout to get me started with explanations and everything.  Even with all the...

Thank you very very much for the tips Michael!!! I knew I was missing several things....I'm glad to know now that I need a full backup of the database as...

Thank you Michael.  

So you do a full backup as well as a t-log backup?  So the full backup doesnt include the t-logs?

Currently I'm working with a new SQL 2005...

Are you using the 64bit version of SQL 2005?  For some reason MS did not finish the job from what I've read on Database Mail in the 64 bit version. ...

I did this on my dev server.....cloned a db....backed it up....tested Full Text searches on it....then restored OVER it with the backup I created but choosing to rename as well...