You'll have to wait for WAN access. If not, ask the IT department to create a database backup and put it up on an ftp site for you to download...

If you have experience with mainframe DB2 this is familiar term.

You mention out of 13 SQL Servers only 2 are 'flaky'. It may be time to play a Sesame Street game - "one of these things is not like the...

MSX = Master server, TSX = Target server. This is a part of SQL 2000 (introduced in v7.0). Check out BOL, under the index tab enter multiserver for a start.

The MSX/TSX server setup is ideal for a great many monitoring situations. It provides centralized procedure control, scheduling and execution. At present I use it for additional SQL Server monitoring...

hmmm ... providing the instance/port works ... hmmm ... you could add aliases with the client configuration utility as a work around but that does not fix the problem (I...

Time change as a possible cause of this ??? I do not understand how this could happen. Could someone provide some further information ? I ask this because we have...

Have you thought of upgrading to SQL2000 or SQL2005 ?

Just a thought, have you tried to conenct to both instances from one or more different computers ?

Just a little "typo" today:

When a client connects to SQL Server 2000, it is assigned a UMS scheduled ...

should be scheduler

Re-run setup ... after is goes through the environment check you can find the uninstall under advanced options. I traced it to that point but have not executed it.

They are databases as well with data and transaction logs ...

ahhh ... a taste of the old 'Sybase' code base ...

sp_spaceused is still the best tool for the JOB. system table 'stuff' is going to change in 2K5 (just...

My guess is that the "backup system db transaction logs" job is failing. If that is in fact the case it is because the 'system' databases (master, model & msdb) are...

No need to wait for the network team ... You could downlad and install Ethereal (free and works great) and probably figure it out after a 5 minute capture. Here's...