| rameymt 2006-01-26, 4:53 pm |
| How can I view/manage SQL Server 2000 jobs in SQL Server 2005?
I just installed Microsoft SQL Server Management Studio 2005 and after
registering a SQL Server 2000 instance I tried to access the Jobs within the
SQL server Agent and I am getting the following error:
Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
For help, click:
http://go.microsoft.com/fwlink? Pro...er&LinkId=20476
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch.
(Microsoft.SqlServer.ConnectionInfo)
------------------------------
A severe error occurred on the current command. The results, if any, should
be discarded. (Microsoft SQL Server, Error: 0)
For help, click:
http://go.microsoft.com/fwlink? Pro...=0&LinkId=20476
The account I am using is the owner of these jobs. I aready installed SQL
Server 2000 DTS Designer Components and SQL Server 2005 Backward
Compatibility files. I can manage SQL Server 2000 DTS packages in SQL Server
2005 but cannot even display Jobs under the SQL Server Agent.
Thanks,
Michael
|