In SSMS on a Windows 7 machine, while connecting to a server running SQL Server 2000, I am no longer able to click on the Jobs to see the Object Explorer Details. Previously, this was not an issue, but it appears to have begun not long after a restart of the SQL Server Agent.

Failed to retrieve data for this request...

Severity: 11
Error Number: 0
State: 0

In SQL Server Enterprise Manager on my XP machine, I am able to view the Job details, but it takes a long time; trying to view the properties of an individual Job also takes an inordinate amount of time.

In SSMS, I am not having any trouble opening tables and running queries or opening procs and running them.

Any insight into causes and/or fixes?

Responses to comments:

  • Connectivity is good.
  • msdb.sysjobhistory shows about 6500 records, with 90% of the records created in 2014.
  • RDP into the 2000 box indicates the same slowness for SQL Server Agent jobs display.
  • I do not experience lag time when:
    • I connect to the server
    • I open a table or procedure
    • When I run a basic query
  • Whenever I attempt to view the Job Details under SQL Server Agent, the lag time is significant.
  • Queries against msdb.sysjobhistory and msdb.sysjobs run fine in Query Analyzer.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.