Thank eveyone. I discoverd this last solution on another site just before

returning here. It works.

Thanks Jason,

     When I complete a job with a  notification, the SQL Agent Log File Viewer

    indicates 'An attempt was made to send and email when no email session

    has...

Thanks again Mike. I'm trying  to understand how to limit the row number of individual error logs.

R.,

Ed

Thanks Mike. Are you saying the DBCC ERRORLOG deletes  the oldest log?

R.,

Ed   SQL 2005 SP2

John,

    I spent 9 hours with MS trying to solve this same problem. Their final

    solution is a reinstall the instance. Talk about a sledge hammer.

   Fortunately I didn't...

I feel you pain Bro. MS tech support is no stranger to me either. Are you

saying if I clean out the installer files, the SP install will work? If so...

Thanks.

Yes. Additionally I  stopped all SQL services and set for manual restart,

then bounced the box.

Thanks for all the responses. One of the first things I did was try a fresh download of the SP. I’ve successfully installed the SP...

Thanks for the response Bill. The window indicates: "The following

unexpected error occured: Unable to install Windows Installer MSI file."

I've successfully installed this SP on my test DB bed. I've read...

Can someone provide the link to Microsoft for this licensing information?

Thanks,

Ed

Thanks to everyone for your help.

Also does anyone know if the SQLMailAgent can be supported by SMTP?

Thanks,

Ed

Thanks Greg and Happycat59, for the very helpful info.

You people are the greatest!  Da-aah, I’m such a dummy. I missed the fact when you guys (gals too) say to...

You're correct Scott, in my haste I created the table in both

master and test dbs. So I started from scratch again, created a table

as dbo owner, successfully changed the owner...