CDONTS is a better solution I think, especially if you'll be doing a large volume of email. BOL has some good examples - I'd recommend opening Query Analyzer and experimenting...

Hi Jodie - missed your last reply or would have posted sooner.

I like Patrick's idea of the 30 minute rule - you want them to wrestle with it and learn,...

Vijay - please don't post your questions more than once. I posted an answer in the other forum where you posted.

Andy

David, thats a pretty interesting utility I'll have to remember. Only had problems with msi once or twice, but it was a pain when I did!

Andy

Hello Vijay,

You might be running out of disk space, CDONTS creates a text file per message. If you need more help, I'd suggest http://www.msdn.microsoft.com - unless you think its a...

Could you post your code??

Andy

What net libraries do you have installed?

Andy

Take a look at this:

http://support.microsoft.com/support/kb/articles/Q303/2/92.ASP

Andy

Very likely. You'll have to be in the dbowner or ddladmin roles (or one of the system roles). Connect as SA if you can.

Andy

I can see where it would be possible though not fun to solve this by querying ActiveDirectory. If Enterprise Manager can do it, should be a way for us to...

I imagine there are times that due to the small amount of data, the query planner may opt for a table scan rather than the index. Aside from it just...

Sounds like the tables are linked. If you use Access with an mdb, tables in SQL/MSDE are linked and cannot be altered. If you're in project mode (.adp), then you...

Shrinkfile should work.

Andy

Looks like they are both api calls, this just gives you an interface to them.

Andy

Access2K in project mode uses MSDE - basically SQL Server with no tools.

Andy