You may try OSQL -L.

You also can use SQL Server 2000 SQL Scan Tool (SQL Scan) to identify all installed instances.

Did you use same authentication mode to register SQL Server in EM in both servers?

You need to have a look to view sysjobs_view.

CREATE VIEW sysjobs_view

AS

SELECT *

FROM msdb.dbo.sysjobs

WHERE (owner_sid = SUSER_SID())

OR (ISNULL(IS_SRVROLEMEMBER(N'sysadmin'), 0) = 1)

OR (ISNULL(IS_MEMBER(N'TargetServersRole'), 0) = 1)

It...

Check your machine application/system logs for any related errors.

Do you mind post the result of srvinfo \\yourmachinename?

Do you have any kind of backup application running in this server to try to backup database files? What about anti-virus application?

Set the value to 2.

If you are in clustered SQL Server installation, you may found SQL Server license mode is by per seat instead of per processor even though you did choose the per...

quote:

---

I know there was a change in TargetServerRole as of SP3.

---

Brain is right. The...

I created user TEST1 who created and owned job JOB1. I created another user TEST2 and granted it to access MSDB and added it to the member of TargetServerRole. Use...

quote:

---

I've got one SPID (from any individual database on the server) that connects to the tempdb and creates up to 100...

Are you sure?

In addition of performance, You also have to face the large database maintenance and database recovery issues.

Grant those users to access MSDB and add them to the member of TargetServerRole.

Go back to Access --> Tools --> Add-Ins --> Linked Table Manager --> Select All --> Click to refresh the link between linked table and SQL Server.

OK. Go to Access --> open any one of tables in design view --> click properities from toolbar to find out the ODBC name used for linked table to SQL...