1

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.
0

0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.