Unable to cast object of type ‘Microsoft.SqlServer.Management.Smo.SimpleObjectKey’
by mysticslayer on Feb.03, 2010, under Software, sql server
Today I was doing some tasks on SQL Server 2005 with SP2. I had some problems with adding jobs and getting the following error message:
Unable to cast object of type ‘Microsoft.SqlServer.Management.Smo.SimpleObjectKey’ to type ‘Microsoft.SqlServer.Management.Smo.Agent.JobObjectKey’.
The issue was using client tools without SP2. You can’t add jobs to a SQL Server 2005 with SP2 with SQL Server 2005 RTM Client Tools.
