You are not Logged in
Would you like to Login or Register

Today is: 10 February 2012
Check this months hot topics

Unable to cast object of type 'Microsoft.SqlServer.Management.Smo.SimpleObjectKey'

I was getting the following error when I attempted to create a new job in SQL Server Agent:

Unable to cast object of type 'Microsoft.SqlServer.Management.Smo.SimpleObjectKey' to type 'Microsoft.SqlServer.Management.Smo.Agent.JobObjectKey'. (Microsoft.SqlServer.Smo)

Nothing I did improved the situation. It then occured to me that it may not be an issue if I Terminal Severed onto the actual SQL Server.

Presto! It worked and my job was created.

What this complicated error message meant in my case was... "Log onto the box and do it"

I hope you manage to create your job.

kick it on DotNetKicks.com del.icio.us digg Mister Wong YahooMyWeb Reddit Furl Spurl blogmarks
Ric Hayman MCPD Skype
Author : Ric Hayman MCPD
Published : 11 October 2008

Ric is an MCPD Microsoft Certified Professional Developer with over 25 years commercial development experience using Microsoft technologies.

Comments

Scott Taylor said:

You're awesome. Worked perfectly by logging into the sql server. Thanks.

December 04, 2008 - 8:05 PM

Daniel said:

Thank you for your interpretation. So much easier to understand.

April 05, 2010 - 8:17 AM

Add Comment

Enter your comment below and it will be submitted for moderation.

Your Name

Add Tag

Please enter tags for this article, seperated by semi-colon ;

View Tag's by : # articles | # views