You're welcome. One other thing I though of is that if you declare the objects with case sensitive names (like columns), they will be returned as such. This must be...

Any changes to DTS packages that might attach files? Perhaps some file attachment is causing the failure. There is an error in the KB mentioning sending open files.

Steve Jones

steve@dkranch.net

You can restore with move option. This allows you to move the log file.

Or buy a bigger disk.

Steve Jones

steve@dkranch.net

The datatype is int. A property of this column is identity.

Steve Jones

steve@dkranch.net

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