Nice to hear that it helped.

Hex code means.....

Error Result : 0x80040154   ( -2147221164 )

ID Defined as : REGDB_E_CLASSNOTREG

Error Type : OLE HRESULT Error

Facility : FACILITY_ITF   0x00000004   ( 4 )

Severity : SEVERITY_ERROR   0x00000001   ( 1 )

Code : 0x00000154   ( 340 )

Source Error...

I think there is a KB for this problem.

http://support.microsoft.com/kb/915850

You may experience a 45-second delay when you run a full-text query in an instance of SQL Server 2005 that is...

Is there some heavy IO activity during that time?

Can you please check if you have iLO feature enabled?

If yes, please update the driver

http://h20000.www2.hp.com/bizsupport/TechSupport/Document.jsp?lang=en&cc=us&objectID=c00688313&jumpid=reg_R1002_USEN 

Is it an HP machine?

327552 BUG: SQL Mail Only Works From One Instance at a Time

http://support.microsoft.com/default.aspx?scid=kb;EN-US;327552

I would give a shot to delete and recreate mail profile.

what the the contetnt of the log file. please paste the sample of it (the most reperative part)

Are you are doing audit login/logout event capture?

Yes you can delete old file.

Those setting are database wide setting and cannot be set for user.

If you are aware of the query which is causing it to grow 80 GB you may want to...

Access Violation can be caused by different reasons.

I would suggest you to open a Support Case with Microsoft. $249 is not a big deal to save your business.

Books Online is good place to start.

You can have Log-shipping between SQL 2000 and SQL 2005. BUT you cannot keep secondary in STANDBY mode.

Tools (Enterprise Manager / Management studio) cannot be used to set it...

from Enterprise Manager:

===================

exec sp_MSdbuseraccess N'db', N'%'

and then

select name, DATABASEPROPERTY(name, N'IsDetached'),     (case when DATABASEPROPERTY(name, N'IsShutdown') is null then -1 else DATABASEPROPERTY(name, N'IsShutdown') end),    

DATABASEPROPERTY(name, N'IsSuspect'), DATABASEPROPERTY(name, N'IsOffline'),     DATABASEPROPERTY(name, N'IsInLoad'),     (case when...

Can you please post recent ErrorLog? If SQL is not coming up, error log is the first place to start.

If you are looking for way to fire Alert for System Messages...

Then it's a Bad news...

In SQL 2005 "System messages cannot be modified with sp_altermessage

http://msdn2.microsoft.com/en-us/library/ms175094.aspx

sp_altermessage cannot be...

1. You can use DDL triggers.

2. If you are lucky and if you want to know who did it in past 24 hours, you can look into default SQL trace...