Another VERY important note:  Your columns must contain consistent data or you risk data loss.  The driver that accesses Excel as a db determines data types for each column by...

Sorry ... not able to 'share' code from current work location.

But, here is a link to a very simple example on the MSDN site

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cdo/html/_olemsg_creating_and_sending_a_message.asp

Unfortunately, MS has not been really...

The Resolve Method can either be applied to the Recipient Collection or to each Recipient in the collection.  The later is preferred for automatted processing.  Reason:  The Resolved Property gets...

How are you controlling the attempted retries?

If you are using an ErrorHandler in your connection proc, it might be jumping right back to the Connection.Open!  I have seen this several...

Interesting reading this after yesterday's excellent article regarding potential pitfalls in the use of the ISNULL function!  Might want to double-check the article to ensure you dion't 'step into' the...

I believe the SQL Server SP integration into Visual Studio IDE requires the Enterprise Edition of Visual Studio.  In Professional version you can see the database objects but don't have...

The following exceprt is from BOL for "Configuring Linked Servers"

Note  SQL Server has been tested only against the Microsoft OLE DB Provider for SQL Server, Microsoft OLE DB Provider for Jet,...

As a developer, I make it a matter of principal to always invite the DBA to development meetings. However, perhaps it is overkill for them to be expected to...