SQL 101 --> A SQL Server is a dedicated machine. Dedicated to SQL Server and no other software.

One other point. When changing the account for the SQL Agent service you will need to stop and restart the service. The same hold true for the SQL Server service....

Have your server admins executed memory tests ? (In particular a memory march test. I've seen bad, but intermittently bad, wreak havoc on a server. The only reason I mention...

For software updates and management I'd suggest SMS (Microsoft Systems Management Server). It allows you to inventory the environment, package updates and roll out upgrades to software.

sysobjects is a table that exists in every database.

Here's a link for a reference on system tables innSQL 2000:

http://www.microsoft.com/sql/techinfo/productdoc/2000/systables.mspx

I also agree that this is not possible whether you use SQL Security or Integrated Security. Once your login is authenticated to the SQL Server the only thing prohibiting/governing your...

This is nothing new. If servers, file systems and backup media are secure it is really not an issue. Just as an additional FYI SQL Server backups are not the only...

I do not believe that you will suffer any 'ill' affects other than possibly performance since you are removing 2 CPUs. The only other possiblility of an issue I see...

... another point of view ... SQL Server and EM are client/server tools. By definition client/server tools are meant to be utilized over a LAN. You are attempting LAN operations...

The password quandary, it's one dynamic subject. Well, I'd just like to address the complexity and cracking portions. Complexity ... well we require

3 of the 4 following criteria upper...

I do not believe that this capability exists in SQL2000 or in SQL2005. If a user has read access and can create a stored procedure (freely available decrypting ones on...

I'm no expert here but have the proper 'trust' relationships and permissions been set up ?

I'm not familiar with HP. Are you dual-pathed to the SAN ? Can your SAN admin change the ports that you are using ? Maybe a call (or support case)...

If you switch to using SMTP Mail or CDOSYS Mail the problem will also go away.

Here's the link if you're interested:

http://support.microsoft.com/default.aspx?scid=kb;en-us;312839

I've shunned SQL Mail since it's inception due...

Search this website for 'shrink transaction log' ... there are some interesting threads. The 'WITH' thing does not have to do with your problem. It determinese whether ot not messages...