Verify if SQL Server service account has 'sysadmin' right in SQL Serevr logins.

What is your SQL Server current version number? Check it from regsvr32.

Run RESTORE FILELISTONLY  to get a list of the databases files and file numbers contained in the backup set.

Then Run Restore command with FILE = file_numbes

Only members of the sysadmin and dbcreator fixed server roles can execute sp_attach_db and sysadmin to run sp_detach_db.

db_backupoperator  can run backup and dbcreator is able to execute restore.

I suggest you to control how...

Since you mentioned DTCtest was failed, You may try this.

Try to grant it to access SQL Server with 'sa' right by running sp_grantlogin 'NT AUTHORITY\NetworkService' and sp_addsrvrolemember. 

Do you have same issue between two Windows 2000 or 2003 servers?

Did you remove "BUILTIN\Administrators" group from both servers? Try to add it back to see what is going to...

You could create server alias name to like be a defualt instance for your named instance using client network utility.

In terms of memorty configuration, it really depends on how much...

For OLTP system, We always suggest not to use parallel execution, in this way, server will has more available CPU resources to serve many concurrent transactions requests.

By select * from sysprocesses,...

In order to see your MDB file in remote server from SQL Server, you have to use domain user account to run SQL Server service and that domain user account...

Remove rights from a login is nothing to do with stoping users to use EM.

You can delete following MMC from user's machine C:\WINNT\system32\mmc.exe /s "C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC"...

First, you have to find out which queries are running slow and parallel in those SPs that are used by monthly DB-process.

You can then add query hint "maxdop number" in...

What type of account does your SQL Server run, domain user or local system account?

Yes, It is.

There is because old SQL Server Agent sessions were still running after you removed the 'BUILTIN\Administrators" group.