Okay, let's take this step-by-step...

Removing the BUILTIN\Administrators, while a good idea, doesn't help your SQL Server security with respect to the web. The reason being a connection from your web...

This is something we noticed empirically, I don't have docs saying this is actually the case. Take it with a grain of salt. Jobs run through SQL Agent seem to...

Here is the readout of a SQL Server:

Microsoft SQL Server  2000 - 8.00.818 (Intel X86)   

Dec 17 2002 14:22:05   

Copyright (c)...

Both of those IDs are raised using RAISERROR() in the appropriate stored procedures. EM uses sp_addlogin and sp_droplogin, at least according to a Profiler trace I just ran. You didn't,...

Based on the sp_addrolemember stored procedure, only members of the db_owner role can add a user/role to a fixed db role. Here is the relevant code:

...

The latest version will have (Updated - SP3) in the title bar. Not sure about the 8.00.002 since all of my versions are updated.

K. Brian Kelley, GSEC

http://www.truthsolutions.com/

Author: Start to Finish...

No, SQL Server 2000 Standard requires a Server version of the operating system. Personal Edition or Developer Edition (only available through MSDN) can be installed on Windows 2000 Professional.

K. Brian...

You can always write to a temporary file (xp_cmdshell using echo >>), then use xp_cmdshell to call isql or osql and login/execute the create proc statement.

K. Brian Kelley, GSEC

http://www.truthsolutions.com/

Author: Start...

If you want to dup what permissions you already have, you'd put the account in the local Administrators group for the system. Make the account change through EM because it...

If the service is set to start under the LocalSystem account, debugging won't work. Either a domain or local account will need to be created and SQL Server configured to...

Default would be to run under LocalSystem, and debugging requires an actual login, whether local or domain. If you have access to the server, check the account the MSSQLServer service...

Are those servers running with the service under LocalSystem or are they using a local/domain account?

K. Brian Kelley, GSEC

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring

http://www.netimpress.com/

You can query against syscomments to find matches (search against text and pull the id), but then you're still going to have to do something like a cursor with sp_helptext...

Is this consistent for a particular server or intermittent?

K. Brian Kelley, GSEC

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring

http://www.netimpress.com/

That error means a RECONFIGURE needs to be executed to "install" what configuration change you made. This shouldn't be related to changing the audit settings, because that's kept in a...