Is your public profile also the default profile?  In the DB Mail Configuration Wizard, select "manage profile security" and for the profile you want to use make sure the "Default...

I'm not much of an Access programmer, but value displayed in the "Host" column in the Activity Monitor can be embedded in the connection string/object and not actually match the host name of...

Jason, thanks for the feedback.  I thought it looked that easy, but I've never actually tried it, so it's always nice to hear that it worked for others. 

Thanks again,

MIJ

I hope this isn't too far off topic, but does the MSDTC issue apply if you're not dealing with cloned servers?  Or is this only a probelm becuase cloning results...

I think you're on the right track when you say "perhaps it depends on the environment".

The migration advocates have rightly pointed out the advantages of a "clean install", but there...

Lynn, thanks for the clue.  I don't know what I was doing the first time I searched, because I found a lot more relevant results when I searched again later....

I found this white paper to be useful (if you have the time): http://www.microsoft.com/downloads/details.aspx?FamilyID=3d5e96d9-0074-46c4-bd4f-c3eb2abf4b66&displaylang=en

And the SQL Server 2005 Upgrade Advisor is invaluable: http://www.microsoft.com/downloads/details.aspx?familyid=1470E86B-7E05-4322-A677-95AB44F12D75&displaylang=en

Other stuff that might be useful:...

I don't know about Delphi or SQL 7.0, but we recently have been migrating from SQL 2000 to SQL 2005, so I have a couple of general pointers.

First, I agree...

It did seem to take a while to install everything, so I can see why you wouldn't want to do more than you have to.  We only had a handful...

OK, that makes sense.  So does one process = one connection?

This is a third-party desktop client application, so I can't control (or even directly determine) how it opens and closes...

Hi Mark,

We had a similar deployment a few weeks back, and we applied both SP2 and GDR (same builds as you mentioned) to all SSMS installations.  I don't recall if...

Thanks, everyone, for the advice.

I'll admit I was leaning towards the SQL 2000 class because of its immediate utility and structure (the same material for SQL 2005 seemed to be...