If they did a migration to a new domain simply because they wanted new hardware... they could have brought up new DCs on new hardware, moved over the FSMO roles,...

Perfmon is designed to track how systems are performing through the use of performance counters. It's often an admin's best tool for troubleshooting issues like these. As to help on...

One other thing stood out to me. When you say changed domains, why did they change domains if all they were doing is an upgrade from a Win2K domain to...

Is the SQL Server sa password the same on all boxes (including the one you do have access to)? If so, you can run SQLCrack or some similar tool to...

A few things have to happen in order to allow access to xp_cmdshell.

First, you would have to set the proxy account, as the error indicates. That means that whoever...

Something else is going on because they should be blocked by the Deny. Just tested it and got the expected error.

How are the users logging into the SQL Server? Windows...

The application knows about the Windows user. However, if you connect to SQL Server using a SQL Server login, no Windows information is passed. Therefore, the SQL Server would have...

Just a warning... this is in place to allow multiserver administration. As a result, if Microsoft changes how this behaves (look at the changes from SQL Server 2000 SP2 to...

The recommendation from a security side is to remove them in production. They represent a known source for an attacker to use to deploy custom objects such as stored procedures,...

I'd take a look at your Citrix side. Keep in mind that Citrix is intended to be a shared environment, meaning resources may be eaten up on that side. Running...

There is information in Books Online about SQL Server architecture. However, your best sources are two particular books:

Inside SQL Server 2000 by Kalen Delaney

The Guru's Guide to SQL Server Architecture...

There are two supported ways to have a login show up as the dbo user. Neither require you to update the sysusers table.

The first, and simplest, is simply to make...

Those two things aren't generally related. The error you're getting is SQL Server can't get connect to DTC, not the other way around. This is an error we started seeing...

This error probably isn't related to your BUILTIN\Administrators change. MS DTC doesn't log in to SQL Server. However, this error is familiar to many of us who have dealt with...

That is correct. There have been no SQL Server related security patches since SP4. You can always verify by checking out here:

Microsoft Security Bulletin Search