April 2, 2008 at 8:50 am
I get following error message when I try to create a job:
TITLE: Microsoft SQL Server Management Studio
------------------------------
Unable to cast object of type 'Microsoft.SqlServer.Management.Smo.SimpleObjectKey' to type 'Microsoft.SqlServer.Management.Smo.Agent.JobObjectKey'. (Microsoft.SqlServer.Smo)
------------------------------
BUTTONS:
OK
------------------------------
what could be the cause of this? I have sa rights and have created job on the instance before.
April 2, 2008 at 8:57 am
I have gotten this before. This has happened when my SQL Server 2005 was on SP2 but the SQL Management Studio and its related tools was not.
Once I applied SP2 for SQL 2005 to my SQL tools the problem went away.
(Sometimes I forget when to upgrade the servers to also upgrade the server tools on my workstation!)
JTS
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply