Do you see any errors regarding to TCP/IP in SQL Server errorlog?

http://support.microsoft.com/default.aspx?scid=kb;en-us;308766&Product=sql2k

s_detach_db/sp_attach_db or backup/restore.

For login/password transfer, See http://support.microsoft.com/default.aspx?scid=kb;en-us;246133&Product=sql2k

http://www.dbazine.com/cook10.shtml

insert into old_zip_table select * from new_zip_code where zipcode not in (select zipcode from old_zip_table)

quote:

---

Besides adding completely new zip codes, I...

sp_who2 and sp_lock may be the command you are lookin for.

quote:

---

The GUI is usless because I cannot see the...

Can you provide more details what did you try to do? What service account do you use to run SQL Server Agent Service, Local system a/c, Domain User and their...

Do you create many DTS or large DTS packages?

Run sp_spaceused @updateusage = true to MSDB and check the size again.

A remote server configuration allows a client connected to one SQL Server to execute a stored procedure on another SQL Server without establishing another connection. Remote servers are set up...

Try this.

exec xp_cmdshell 'copy "\\org_servername\sharename\filename" "\\dest_servername\sharename\directoryname\"'

To use AWE memory, you must run the SQL Server 2000 database engine under a Windows 2000 account that has been assigned the Windows 2000 lock pages in memory privilege....

Check how many records in following tables.

sysjobhistory

restorehistory

sysdbmaintplan_history

Which version of SQL Server you run, 32bits or 64bits? If you run 32bit SQL Serevr, Is 'AWE' enabled in SQL Server?

What service account do you use to run SQL Server Agent service? It has to have sufficient priviliege as yours in order to run your job successfully. Or setup SQL...