Wow. Andy's suggestion is probably the best one. How often is the data being added to or updated? Also, is there a possibility of keeping some tables...

The first error is usually gotten around with "admin" and "" for username and password respectively when it shows up.

As for the second, you said it's been running for a...

Very interesting, indeed. Please keep us informed. I for one would really be interested because my company will eventually be going to Exchange 2000 and it'd be good...

I'm not real familiar with MSDE with respect to applications development and installation. So if I sound like a complete buffoon, please forgive me after you slap me around...

Ok, you're speaking with respect to the maintenance plan. I believe that works through xp_sendmail, too, since it's coming from SQLMAINT.EXE. Steve asked this once before. Are...

I'm afraid with the information you've provided, no one can give a valid answer. Can you give a more complete synopsis of what you're trying to do?

K. Brian Kelley

bkelley@agfirst.com

Sacrificial Summer Intern. Appease the admin's wrath. 😉

But seriously, ok, we've ascertained xp_sendmail doesn't work like it should. However, an e-mail notification from SQL Agent does. When...

This may not be the most efficient way, but it works:

SELECT DISTINCT a.f1, b.detail, c.f2, c.detail

FROM a JOIN b ON a.f1 = b.[id]

JOIN (SELECT a.f2, b.detail

FROM a JOIN...

Swift kick to the server (if reachable) with a steel-toed boot? Hmmm, I'll keep digging.

K. Brian Kelley

bkelley@agfirst.com

Exchange Server 2000 say you? Here's a Q article on that there error:

http://support.microsoft.com/support/kb/articles/Q293/4/22.ASP

K. Brian Kelley

bkelley@agfirst.com

I think Steve and Andy have indicated the right paths for what you're trying to do, but to clarify, are you looking to

a) Prevent someone from seeing the information...

Prior to Windows 2000:

CDO Library, CDO Rendering Library - for MS Exchange Servers

CDO for NTS - for an SMTP Server (running locally)

As for Windows 2000, CDO for Windows 2000 is...

I don't believe CDONTS supports changing of the SMTP Server. I'm looking at the object model right now to refresh my memory and I don't see anything in relation...

Where I work, we follow a naming convention to what Michael Hotek proposes. Here's the link to the article on his site:

http://www.mssqlserver.com/articles/naming_conventions_p1.asp

K. Brian Kelley

bkelley@agfirst.com

Instead of a datetime or smalldatetime variable type for the field, change it to char(10) in the SQL Server table. That should let you see what's coming across.

K. Brian...