Thank you guys - much appreciated.

Thanks Guys,

Sometimes you miss the obvious, I did. Everything was configured properly. Try my personal account and test mail works. Try the group account and it fails....

Sometimes you just have to repeat the effort. Spoke to a server administrator as I noted what looked like an OS issue. This was corrected. Subsequently repeated...

You gave me an idea which tentatively has resolved our problem. I noticed you went from 2000 to 2005. I was going from 2000 to 2008. While...

This is a poorly written information request. I realized that with some of the responses. I did specify a side-by-side scenario initially but botched from there. Even...

I may have confused some of you:

I want to upgrade SQL Server 2000 instances. Their OS is Windows Server 2003 SP1. The instances have no SQL Server...

I checked the advisor install requirements. For the server it requires SP2, SP1 is installed. I going to contact one of our server administrators, to see if we...

One last comment - I removed the 2008 Upgrade Advisor and installed 2005. Using the detect option against the 2000 instances - the advisor shows no Data Transformation Services...

Lowell,

Thanks for responding. I should have clarified that in my posting - the email account has the full domain. And the mapping you mentioned was done. I...

Erin,

Thank you for responding. I believe you are correct that DBMail is the service which actually sends the email.

Running msdb.dbo.sysmail_help_status_sp tell me the status of DBMail. ...

This is a followup to this issue. Running query SP_HELPDB does not list the database with it's owner. The query does provide the following message:

...

I ran the DBCC UPDATEUSAGE command without incident. The DBCC CheckDB runs fine. I don't have any experience dropping and recreating an index. What I've done is...

Jitendra,

You might want to review this URL:

http://sqlserverpedia.com/wiki/Shrinking_Databases

It provides a good oversight to concerns when shrinking your database. Hope this helps.

George,

>>In explorer in organize view is hide known extension types ticked? what happens if you uncheck that? >>

That was it. Thank you!!

Bob

Lynn,

>> How do you know that the original ERRORLOG is not renamed to ERRORLOG.1, etc.

The logs directory now has 2 ERRORLOG files. There is no ERRORLOG.1 file. ...