np. just trying to clarify. Didn't want to pick on you.

Steve Jones

steve@dkranch.net

In the event of an abnormal termination, there isn't any "event" necessarily.

What you could do is write a sproc to compare the results of sp_who with your table and look...

Strange. No idea, but thanks for the followup.

Steve Jones

steve@dkranch.net

Andy is right. This is supplied through the ADO connection and there is no validation or verification. I can easily send a query from my workstation as host_name() "AWarren" if...

Agree with Brian. There is no way in SQL to track the access, other than profiler. You could use a sniffer, but profiler essentially does that. you could also implement...

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