Let us know. I'm reaching. Not too much in Technet on mail.

Steve Jones

steve@dkranch.net

Brian,

nice introductary article. I'd love to see a followup dealing with more complex designs and including child tables.

Steve Jones

steve@dkranch.net

Outlook have it's SP applied?

Steve Jones

steve@dkranch.net

I'm a problem solver. I enjoy working with T-SQL and finding the solution to some query issue.

Building DTS packages is fun and I've been working with VB and Dmo a...

Has anything changed on the server or the exhchange server recently?

Also, when you say you stop and restart, is this to get SQL Mail working, or is there a problem...

, check out the system functions in BOL. Lots of goodies.

Steve Jones

steve@dkranch.net

Sorry,

select host_name()

The user will be

select suser_name(), user_name()

depending on if you want login or db user. You can get all of these from sp_who

Steve Jones

steve@dkranch.net

Use #1

Steve Jones

steve@dkranch.net

Thanks for the followup. Let is know if it works in production.

Steve Jones

steve@dkranch.net

The best way is to insert the audit record by joining back to the original table. To handle multi row inserts, I've done the following.

in trigger:

if update()

begin

...

Great idea, I'll have to try that.

Steve Jones

steve@dkranch.net

Is this a copy objects task? If so, I've had numerous problems with those.

Steve Jones

steve@dkranch.net

Thanks for the followup. What version worked BTW?

Steve Jones

steve@dkranch.net

Or suck in the data into a table and process it there. I agree with Brian and Andy, pls post more info.

Steve Jones

steve@dkranch.net

you can get the hostname() from the system, but this is passed by the client. Also, because of proxy servers and NAT, IP addresses are not necessarily unique.

Steve Jones

steve@dkranch.net