posted 1/25/2012 by marcoadf - Views: [470]
Today, one of my team members faced an issue that I was not able to give the answer right away.
The problem was, in SSMS while he was connected to DEV JOBs, he couldnt edit steps, as image below:
First we started for privileges/permissions issue. But that was not the problem. After checking his SS version we got the problem:
select @@version
Microsoft SQL Server 2008 R2 (RTM) - 10.50.1617.0 (X64) Apr 22 2011 19:23:43 Copyright (c) Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)
After checking DEV version, we realised that he had an older version:
Microsoft SQL Server 2008 (SP3) - 10.0.5500.0 (X64) Sep 21 2011 22:45:45 Copyright (c) 1988-2008 Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.0 <X64> (Build 6002: Service Pack 2) (VM)
This is a reported problem. Can see link here. There are some workarounds mentioned, but you should be able to solve problem by updating SQL Server version, as we did.
Hope this helps you if you face a similar problem.