Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
ksr39
Posting Yak Master
193 Posts |
Posted - 2012-01-31 : 10:26:25
|
Hi All,I'm trying to create a maintenance plan in one of my servers. but when Im trying to create the Maintenance plan Im getting the following error.Invalid column name 'msx_job_id' As my server is SQL Server 2005 with SP3 Enterprise edition. How to over come this problem.Thank you In Advance |
|
X002548
Not Just a Number
15586 Posts |
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2012-01-31 : 12:24:46
|
Is SSMS patched to the same level as the server?--Gail ShawSQL Server MVP |
|
|
ksr39
Posting Yak Master
193 Posts |
Posted - 2012-01-31 : 13:41:55
|
How to know whether my SSMS patch is same as the server |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2012-01-31 : 15:14:59
|
Help -> About--Gail ShawSQL Server MVP |
|
|
ksr39
Posting Yak Master
193 Posts |
Posted - 2012-01-31 : 15:54:03
|
Hi this is what i foundMicrosoft SQL Server Management Studio 9.00.1399.00Operating System 5.2.3790 |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2012-02-01 : 03:04:21
|
So the client is RTM and the server SP3. Yeah, that's likely to cause problems. You need to patch client machines as well as servers.--Gail ShawSQL Server MVP |
|
|
ksr39
Posting Yak Master
193 Posts |
Posted - 2012-02-01 : 13:04:50
|
ok thank you |
|
|
|
|
|