It means there are duplicate entries in Active Directory for this service principal name. A directory administrator can use ldp.exe to search for the duplicates and either ldp.exe again or...

SQL Server 2000 SP3a w/ MS03-031 hotfix applied is a completely patched SQL Server (this doesn't include the OS). If you run a SELECT @@VERSION query it should come back...

Do you have full-text indexing installed? Is SQL Server Agent running under the System account (you can check this by running services.msc and looking at the login account).

NT Authority\System corresponds...

I do mine manually...

<a href="link" target="_blank">link description</a>

The target="_blank" just makes it open in a new window. I don't include this if it's a reference within the sqlservercentral.com site itself.

Stop and disable the Task Scheduler service.

Both Task Scheduler and the Microsoft Search service must be run under the System account. Task Scheduler will allow you to set a different service account and will even attempt...

You can also simply execute the system stored procedure sp_helprotect against each database.

If you're looking to decrypt a SQL Server login password, you're not going to find a simple script for it. NGS Software has tools (commercial) that can perform password cracks:...

If they are doing an in-place upgrade the groups, domain name, etc., should stay the same. So too should the SIDs, if I remember right. Therefore there should be little,...

My thoughts on this are at a top-notch conference, you'll see seminars like Brian's and Andy's. That's to be expected. However, a vendor being very open with their next product...

SQL Server 2000 Reporting Services does use ASP.NET. There may be an issue with the hotfix and Reporting Services (I encountered one). You can find a workaround here:

Create a user-defined database role for the appropriate database. You can do so in Enterprise Manager or through Query Analyzer. If using QA, you'll want to execute the following (make...

Agreed on managing resources carefully on a cluster. It's a given you must plan for the case where all the instances are on one node with respect to processors and...

There are quite a few third party tools out there like Spotlight from Quest Software and NetIQ's suite of tools. However, you can do a lot of it yourself using...

Just as a clarification, xp_startmail and xp_sendmail belong on the SQL Mail side. This is through SQL Server (and the SQL Server service itself). SQL Agent Mail (for SQL Server...